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 |