MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.AuditEvent
Description: The audit log for audited events.
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.
ipAddress nvarchar (256) None Yes The source IP Address for the origin of the event.
kind nvarchar (255) None No The audit event type.
severity nvarchar (255) None No The severity of the event. One of Informational, Warning, Error.
actor_identifier numeric (19) None Yes The origin actor of the event.

Index Clustered? Unique? Fields
PK__AuditEve__D112ED493B6D4C6D Yes Yes

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

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_AuditEvent_nmrcPrprts AuditEvent_nmrcPrprts AuditEvent_identifier
FK_AuditEvent_strngPrprts AuditEvent_strngPrprts AuditEvent_identifier

No triggers