Table Type: Historical Data
This table contains the historical routing status of a user at a particular time.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| user_id | string | Primary Key | The user_id of the user. |
| start_time | datetime | Primary Key, Required | The time the routing status started. |
| routing_status | string | The routing status of the user. One of: OFF_QUEUE, IDLE, INTERACTING, NOT_RESPONDING, COMMUNICATING | |
| end_time | datetime | The time the routing status ended. | |
| db_last_updated | datetime | Required | When this record was last updated in UTC. |