AuditDetail
Application audit table for entities that are manually maintained.
erDiagram
AuditObject ||--o{ AuditDetail : "AuditObjectID"
Fields
| Field |
Type |
Description |
| AuditObjectID |
numeric |
Internal ID that references the AuditObject entity (Foreign Key) |
| ChangeSet |
string |
A json document that contains the changed attributes and values |
| Created |
datetime |
Date/Time the audit was created |
| ID |
numeric |
Internal ID for the AuditDetail entity (Primary Key) |
| Info |
string |
A json document that may contain additional information about the audit |
| ObjectDisplayName |
string |
The display name for the audited object. This name can change during the lifetime of the object. |
| ObjectGuid |
guid |
The Guid of the audited object |
| Operation |
string |
Audited operation |
| Relation1DisplayName |
string |
Display name of the first related object |
| Relation1Guid |
guid |
Guid of the first related object |
| Relation2DisplayName |
string |
Display name of the second related object |
| Relation2Guid |
guid |
Guid of the second related object |
| User |
string |
User that performed the operation |
References
| Column Name |
Referenced Table |
Description |
| AuditObjectID |
AuditObject |
Lookup table for audit objects |