This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores devices and associated attributes: hardware version, line number, OS version, UUID, vendor where applicable.
| Column | Description | Example |
|---|---|---|
| device_id | bigint The unique device id. |
4 |
| source_id | bigint The source id of the appliance providing data. |
1 |
| identifier | varchar The device id. |
|
| hardware_version_id | int The hardware version id. |
1 |
| hardware_version | varchar The name of the hardware version. |
Spectralink8741 Pivot (Virtual) |
| os_version_id | int The OS version id. |
1 |
| os_version | varchar The name of the OS version. |
4.1.2 |
| vendor_id | int The device vendor id. |
2 |
| vendor | varchar The device vendor. |
XMPP |
| application_version_id | bigint The unique application version id. |
2 |
| application_version | varchar The application version name. |
4.4.6-1 |
| uuid | varchar The universal unique id for the device. |
|
| line_number | varchar The line number for the device. |
10263 |
| created_at | datetime The creation date. |
2018-01-03 20:12:22.526000 |
| updated_at | datetime The last updated date. |
2018-01-03 20:12:22.526000 |
| control_id | bigint The control id, indicating when the record was loaded or updated. |
25637 |
This guide last modified:
2021-04-23 06:46.
.