Store AVS audit events
Data model
Fields
| Field | Type | Description |
|---|---|---|
| action* | INT | Share ID code |
| audit_device_id* | INT | Unique identifier of the associated materialized device |
| audit_group_support_id | INT | Unique identifier of the associated materialized support group |
| audit_user_id* | INT | Unique identifier of the associated materialized user |
| creation_date* | DATETIME | Record creation date |
| date_key* | INT | Key with date information |
| module* | INT | Module ID Code |
| time_key* | INT | Key with time information |
Primary Key
| PK01_AVS_AUDIT |
|---|
| audit_user_id, audit_device_id, module, action, date_key, time_key |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| audit_device_id* | dbo.AVS_AUDIT_DEVICE | id | FK02_AVS_AUDIT |
| audit_group_support_id | dbo.AVS_AUDIT_GROUP_SUPPORT | id | FK03_AVS_AUDIT |
| audit_user_id* | dbo.AVS_AUDIT_USERS | id | FK01_AVS_AUDIT |