This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores historical conversations.
| Column | Description | Example |
|---|---|---|
| conversation_id | bigint System-generated conversation type identifier. |
3654729 |
| event_id | bigint The event identifier from the source. |
4457523 |
| conversation_type_id | bigint The conversation type identifier (1 or 2). |
2 |
| conversation_type | varchar The conversation type (GROUP-CLINICAL or GROUP-ADHOC). |
GROUP-ADHOC |
| jid1 | varchar The conversation initiator for the conference room, or the first user identified in alphbetical order. |
|
| jid2 | varchar The conversation initiator for the second user, or the static string ROOM. |
ROOM |
| topic | varchar The conversation topic. |
|
| created_at | datetime The date when the conversation was created. |
2017-11-14 08:52:57.512595 |
| source_id | bigint The source identifier of the appliance that is providing data. |
1 |
| control_id | bigint The control identifier when the record was loaded. |
12644 |
This guide last modified:
2021-04-23 06:46.
.