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 |