Table Type: Recording
This table stores the recording information for a conversation.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier of the recording info. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC. NULL if not deleted. | |
| conversation_id | string | The conversation id | |
| media_type | string | One of: audio, chat, email or message | |
| media_sub_type | string | The media sub-type. One of: Trunk, Station, Consult or Screen | |
| file_state | string | The state of the file. One of: ARCHIVED, AVAILABLE, DELETED, RESTORED, RESTORING, UPLOADING or ERROR | |
| delete_date | datetime | The date the recording was or will be deleted. | |
| session_id | string | The session id for the recording | |
| download_status | string | The download status of the recording. One of: null, ARCHIVED, ERROR, EXCEPTION, DELETED, DOWNLOADED, FAILED | |
| archive_date | datetime | The date the recording was archived, if any. | |
| action | string | This field is used to mark specific records for actions, such as setting the retention date or downloading. | |
| message | string | A message which indicates whether a download or other action succeeded, or if it failed, why it failed. | |
| when_downloaded | datetime | The datetime the recording was downloaded, if any. | |
| when_retention_date_changed | datetime | The date the retention date was changed, if any. |
Related Tables
- analytics_conversation
- analytics_session
- voice_recording
- email_recording
- chat_recording
- message_recording
- transcript
- chat_message
- email_message
- email_attachment
- message_message
- voice_transcript
