MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.AbstractSingleton
Description: Common attributes for configuration items.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
identifier numeric - Identity None No Unique ID for an entry.
createdDate datetime None No The original creation data/time for the entry.
modifiedDate datetime None No The last modified date/time for the entry.
version numeric (19) None No The version number for the entry.
crux nvarchar (24) None Yes Random seed data.
kind nvarchar (256) None Yes The type of configuration; enforces uniqueness of the single instance of the configuration.

Index Clustered? Unique? Fields
PK__Abstract__D112ED491B007CDB Yes Yes
UQ__Abstract__ED32B9611DDCE986 No Yes

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key Constraint Affected Table Affected Field
FK19A00FE32C87F94 PickupConfig identifier
FK3CA0D2AC32C87F94 ReplyConfig identifier
FK459A15832C87F94 SmtpConfig identifier
FK48FE93532C87F94 DMZGatewayConfig identifier
FK6A394DE932C87F94 LdapConfig identifier
FK70F86B6232C87F94 DropoffConfig identifier
FKA155673232C87F94 DatabasePurgeConfig identifier
FKA8B4265C32C87F94 LocaleConfig identifier
FKB73C5A2A32C87F94 GeneralConfig identifier
FKBA21F30D32C87F94 UserConfig identifier
FKC378407F32C87F94 InternalConfig identifier
FKC69F33FE32C87F94 FileConfig identifier
FKCB2114F532C87F94 EftConfig identifier
FKF1E3B59432C87F94 WebServicesConfig identifier

No triggers