Table Storing AVS Devices
Data model
Fields
| Field | Type | Description |
|---|---|---|
| hardware_hash* | NVARCHAR (160) | Unique device identifier |
| id* | INT | Integer Type Primary Key |
| model* | NVARCHAR (120) | Device Model |
| modification_date* | DATETIME | Record Modification Date |
| name* | NVARCHAR (120) | Device name assigned by the operating system |
| operating_system* | NVARCHAR (120) | Device operating system |
| serial_number* | VARCHAR (60) | Device serial number |
| status* | INT | The status of the device |
| type* | NVARCHAR (120) | Device Type |
| version | VARCHAR (100) | Agent Version |
Primary Key
| PK01_AVS_DEVICE |
|---|
| id |