MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Auditor
Description: Links the source entity, such as a user, that triggered an audit event to the event's entry in the audit log.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
identifier numeric - Identity None No Unique ID for an entry.
createdDate datetime None No The date of the audit event.
ipAddress nvarchar (256) None Yes The ip address of the session that triggered the audit event, if applicable.
actor_identifier numeric (19) None Yes The unique ID of the user that triggered the audit event, if applicable. Maps to Actor.identifier.

Index Clustered? Unique? Fields
PK__Auditor__D112ED4946DEFF19 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Auditor_actor actor_identifier Actor

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK3D30355095EB91ED ReplyConfig_extnsnsExclddLog logNumber
FK44557A9695EB91ED ReplyConfig_rcpntDmnsAllwdLog logNumber
FK50D3CA3695EB91ED DropoffConfig_rcptDmnsAllwdLog logNumber
FK5367B5B595EB91ED InternalConfig_fileExtnsnsLog logNumber
FK7C00B24195EB91ED LocaleConfig_activeLocaleLog logNumber
FKA178A52F95EB91ED ActorLog logNumber
FKA9501BE795EB91ED InternalConfig_extnsnsExcldLog logNumber
FKB3F6227D95EB91ED EftConfig_syncConfigLog logNumber
FKB85DD0DF95EB91ED GeneralConfig_bndngStrngsLog logNumber
FKBFB25F5A95EB91ED DropoffConfig_extnsnsExclddLog logNumber
FKFEA1089B95EB91ED AbstractSingletonLog logNumber

No triggers