Table Type: Recording
Contains the downloaded chat recordings.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The message id |
| conversation_id | string | The conversation id | |
| recording_id | string | The recording id | |
| body_type | string | The message body type | |
| body | string | The message body | |
| to | string | The message recipient | |
| from | string | The message sender | |
| utc | string | The message timestamp | |
| chat_id | string | The chat id | |
| message_id | string | The message id | |
| message_type | string | The message type | |
| sender_communication_id | string | Communication of sender (v2 chats only) | |
| participant_purpose | string | Participant purpose of sender (v2 chats only) | |
| user | string | The user id for the sender (if available) | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. |