| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores a distinct set of device statuses.
| Column | Description | Example |
|---|---|---|
| status_id | bigint The unique device status id. |
2 |
| source_id | bigint The source id of the appliance providing data. |
1 |
| status_name | varchar The device status (Registered, Disconnected, Delivery, UnRegistered). |
Registered |
| created_at | datetime The creation date. |
2017-12-06 04:32:31.069000 |
| updated_at | datetime The last updated date. |
2017-12-06 04:32:31.069000 |
| control_id | bigint The control id, indicating when the record was loaded or updated. |
12637 |