MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.EftConfig_syncConfigLog
Primary Keys: logNumber
EftConfig_identifier
synchronize
configItem
Field Type Defaults Nulls? Comments
logNumber numeric (19) None No Audit log identifier.
EftConfig_identifier numeric (19) None No ID to map back to the 'EftConfigLog' table.
synchronize tinyint None No An entry in the collection.
configItem nvarchar (255) None No An entry in the collection.
logOperation tinyint None Yes The type of operation audited. The types include:
0 - Addition
1 - Modification
2 - Deletion.

Index Clustered? Unique? Fields
PK__EftConfi__8FBA3DE91512995B Yes Yes

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

No primary keys as foreign key constraints
No triggers