Store materialized AVS devices for auditing
Data model
Fields
| Field | Type | Description |
|---|---|---|
| device_id* | INT | Integer Primary Key of Table Devices Materialized |
| end_date | DATETIME | Date on which the materialized registration ended its validity |
| hardware_hash* | NVARCHAR (160) | Unique device identifier |
| id* | INT | Integer Type Primary Key |
| is_current* | BIT | Flag indicating whether the current registration is current |
| model* | NVARCHAR (120) | Device Model |
| name* | NVARCHAR (120) | Device name assigned by the operating system |
| operating_system* | NVARCHAR (120) | Device operating system |
| serial_number* | VARCHAR (60) | Device serial number |
| start_date* | DATETIME | Date on which the materialized registration began its validity |
| type* | NVARCHAR (120) | Device Type |
Primary Key
| PK01_AVS_AUDIT_DEVICE |
|---|
| id |