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 |