Database Schema Tables / Engage Dimension and Fact Tables |
Stores users and device use over time (use start, use end).
Column | Description | Example |
---|---|---|
user_device_id | bigint The unique id of the device user. |
1 |
source_id | bigint The source id of the appliance providing the data. |
1 |
device_id | bigint The device id. |
13 |
device_identifier | varchar The device identifier. |
02af6b70-ba1b-423b-a3d5-0b001c1430c3 |
user_id | bigint The user id. |
82 |
user_login | varchar The user login name. |
johnsmith |
device_use_started | datetime The time of the first activity of the user and device (Registered, Disconnected, Deliver). |
2017-11-14 10:03:38.444000 |
device_use_ended | datetime The time of the last activity of the user and device (Disconnected, UnRegistered). |
2017-11-15 08:29:56.570000 |
created_at | datetime The creation date. |
2017-12-06 04:34:26.899000 |
updated_at | datetime The last updated date. |
2017-12-06 04:34:26.899000 |
control_id | bigint The control id, indicating when the record was loaded or updated. |
12637 |