Chat Conversation (table: chat_conversations)
Field Name | Data Type |
|---|---|
agent_id | number |
agent_team_id | number |
brand | string |
custom field | custom_data[x] |
date_assigned | datetime |
date_created | datetime |
date_ended | datetime |
date_first_agent_message | datetime |
department_id | number |
ended_by | string |
id | number |
is_agent | boolean |
is_window | boolean |
person_email | string |
person_id | number |
person_name | string |
rating_comment | string |
rating_overall | number |
rating_response_time | number |
session_id | number |
status | string |
subject | string |
total_to_ended | number |
visitor_id | number |
agent | Person |
agent_team | Agent Team |
department | Department |
labels | Label Chat Conversation |
messages | Chat Message |
person | Person |
session | Session |
visitor | Visitor |
Chat Message (table: chat_messages)
Field Name | Data Type |
|---|---|
author_id | number |
content | string |
conversation_id | number |
date_created | datetime |
id | number |
is_html | boolean |
is_sys | boolean |
is_user_hidden | boolean |
metadata | string |
origin | string |
person_name | string |
author | Person |
conversation | Chat Conversation |
Please log in or register to submit a comment.