This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores historical messages tied to a conversation.
| Column | Description | Example |
|---|---|---|
| conversation_id | bigint The conversation identifier. |
2186753 |
| message_id | bigint The unique message identifier from the source. |
12577374 |
| nick | varchar The name of the sender, if provided. |
John Smith |
| message_length | int The length of the message. |
20 |
| topic | varchar The conversation topic. |
|
| from_user_id | bigint The user id of the person sending the message. |
857 |
| from_user_login | varchar The user name of the person sending the message. |
johnsmith |
| sent_at | datetime The date when the message was sent. |
2017-11-14 09:13:43.030000 |
| created_at | datetime The date when the message was created. |
2017-12-06 04:43:08.384000 |
| 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. |
12645 |
This guide last modified:
2021-04-23 06:46.
.