MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.AbstractSingletonLog
Description: Auditing table for changes to corresponding with table AbstractSingleton.
Primary Keys: identifier
logNumber
Field Type Defaults Nulls? Comments
identifier numeric (19) None No Unique ID for an entry.
logNumber numeric (19) None No Audit log identifier.
logOperation tinyint None Yes The type of operation audited. The types include:
0 - Addition
1 - Modification
2 - Deletion.
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__B55535B721AD7A6A Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FKFEA1089B95EB91ED logNumber Auditor

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK3A5FEACCD247948F SmtpConfigLog identifier
FK3A5FEACCD247948F SmtpConfigLog logNumber
FK3C3D1748D247948F LocaleConfigLog identifier
FK3C3D1748D247948F LocaleConfigLog logNumber
FK5841A8BAD247948F GeneralConfigLog identifier
FK5841A8BAD247948F GeneralConfigLog logNumber
FK5EC6F60FD247948F EftConfigLog identifier
FK5EC6F60FD247948F EftConfigLog logNumber
FK5F2548F8D247948F ReplyConfigLog identifier
FK5F2548F8D247948F ReplyConfigLog logNumber
FK609AA166D247948F PickupConfigLog identifier
FK609AA166D247948F PickupConfigLog logNumber
FK6292A89BD247948F LdapConfigLog identifier
FK6292A89BD247948F LdapConfigLog logNumber
FK6DAA645D247948F InternalConfigLog identifier
FK6DAA645D247948F InternalConfigLog logNumber
FK74BC40F7D247948F UserConfigLog identifier
FK74BC40F7D247948F UserConfigLog logNumber
FK7CD96C82D247948F DropoffConfigLog identifier
FK7CD96C82D247948F DropoffConfigLog logNumber
FK91751EB2D247948F DatabasePurgeConfigLog identifier
FK91751EB2D247948F DatabasePurgeConfigLog logNumber
FKD8A48E66D247948F FileConfigLog identifier
FKD8A48E66D247948F FileConfigLog logNumber
FKE714B9CFD247948F DMZGatewayConfigLog identifier
FKE714B9CFD247948F DMZGatewayConfigLog logNumber
FKF1C89D10D247948F WebServicesConfigLog identifier
FKF1C89D10D247948F WebServicesConfigLog logNumber

No triggers