AuditsLog
Primary Key
Primary Key | Field Type |
---|---|
ID | int |
Fields
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
AuditsID | int | |||
ClientUsersID | int | |||
AuditDate | datetime | |||
AuditCodesID | int | |||
ObjectGuid | uniqueidentifier | |||
ObjectTypesID | int | |||
User | nvarchar(255) | Default = suser_sname() | ||
Action | nvarchar(2) | |||
ActionDate | datetime | Default = getutcdate() |
Indexes
Index Name | Fields | Unique | Primary | Clustered |
---|---|---|---|---|
PK_AuditsLog | ID | yes | yes | yes |