This guide last modified:
2021-04-23 06:46.
.
| 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 |
This guide last modified:
2021-04-23 06:46.
.