| id | The primary key (auto-incremented) | PK | No |
| description | The descriptiong for this topic. | String(255) | Yes |
| language_id | The reference to the associated customer language. NULL or -1 if not set. | FK cust_lang | Yes |
| welcome_message | The welcome message sent to the customer when the chat session starts. | Clob | Yes |
| last_accept | The last time a session was accepted from the inside for this topic. | DateTime | Yes |
| seconds_pr_accept | The average number of seconds per accept for this topic. | Int | Yes |
| alert_timeout | The number of seconds for an unanswered session before we alert | Int | Yes |
| alert_template | The reply template to use for alerting | Int | Yes |
| alert_recipient | The recipient(s) for the alert template | String(255) | Yes |
| flags | Flags for this topic: show popup alert?, collect consent first?, use custom message? | Enum ChatTopicFlag | Yes |
| name | The name of this chat topic | String(255) | Yes |
| badge_header | The badge header of the chat topic | String(255) | Yes |
| warning_new_chat | Contains the user notify time in minutes | Int | Yes |
| manager_warning_new_chat | Contains the manager notify time in minutes | Int | Yes |
| widget_theme | Predefined themes for the chat widget | Enum WidgetTheme | Yes |
| widget_color | The base color of the widget | String(16) | Yes |
| widget_font | The font used in the widget | String(64) | Yes |
| widget_show_logo | Indicates if the logo should be shown in the widget | Bool | Yes |
| widget_show_agent_photo | Use agent photo and name when chatting | Bool | Yes |
| widget_welcome_title | Short welcome message when user initiates a chat | String(255) | Yes |
| widget_welcome_message | Short message displayed as long as the request is in queue or active | String(255) | Yes |
| widget_offline_header | Offline text shown in widget header | String(255) | Yes |
| widget_offline_message | Offline message shown in widget | String(1024) | Yes |
| widget_enable_ticket | Enable ticket submission in offline mode | Bool | Yes |
| category_id | Category on ticket created from off-line request | FK ej_category | Yes |
| priority_id | Priority on ticket created from off-line request | FK ticket_priority | Yes |
| widget_offline_fields | Required field when creating ticket in offline mode | Enum WidgetRequiredFields | Yes |
| widget_auto_faq | Enable automatic FAQ suggestions | Bool | Yes |
| kb_category_id | Root folder for FAQ suggestions | FK kb_category | Yes |
| widget_pre_form | Enable pre-chat form for anonymous users | Bool | Yes |
| widget_pre_message | Message to be shown in a pre-chat | String(1024) | Yes |
| widget_required_fields | Fields required to start a chat | Enum WidgetRequiredFields | Yes |
| widget_post_form | Enable post chat form | Bool | Yes |
| widget_post_header | Header text to show in post chat form | String(255) | Yes |
| widget_post_message | Message text to show in post chat form | String(1024) | Yes |
| widget_post_transcript | Enable transcript of chat session | Bool | Yes |
| widget_language | The language ISO code for the widget language | String(63) | Yes |
| use_opening_hours | Whether to use opening hours or not. | Bool | Yes |
| tzLocationId | Timezone used for the start/stop times for this topic. | FK TZLocation | Yes |
| mon_enabled | Whether open on Mondays. | Bool | Yes |
| mon_start | When opening hours start on Mondays. Only time-part is used. | DateTime | Yes |
| mon_stop | When opening hours stop on Mondays. Only time-part is used. | DateTime | Yes |
| tue_enabled | Whether open on Tuesdays. | Bool | Yes |
| tue_start | When opening hours start on Tuesdays. Only time-part is used. | DateTime | Yes |
| tue_stop | When opening hours stop on Tuesdays. Only time-part is used. | DateTime | Yes |
| wed_enabled | Whether open on Wednesdays. | Bool | Yes |
| wed_start | When opening hours start on Wednesdays. Only time-part is used. | DateTime | Yes |
| wed_stop | When opening hours stop on Wednesday. Only time-part is used. | DateTime | Yes |
| thu_enabled | Whether open on Thursdays. | Bool | Yes |
| thu_start | When opening hours start on Thursdays. Only time-part is used. | DateTime | Yes |
| thu_stop | When opening hours stop on Thursdays. Only time-part is used. | DateTime | Yes |
| fri_enabled | Whether open on Fridays. | Bool | Yes |
| fri_start | When opening hours start on Fridays. Only time-part is used. | DateTime | Yes |
| fri_stop | When opening hours stop on Fridays. Only time-part is used. | DateTime | Yes |
| sat_enabled | Whether open on Saturdays. | Bool | Yes |
| sat_start | When opening hours start on Saturdays. Only time-part is used. | DateTime | Yes |
| sat_stop | When opening hours stop on Saturdays. Only time-part is used. | DateTime | Yes |
| sun_enabled | Whether open on Sundays. | Bool | Yes |
| sun_start | When opening hours start on Sundays. Only time-part is used. | DateTime | Yes |
| sun_stop | When opening hours stop on Sundays. Only time-part is used. | DateTime | Yes |
| custom_queue_text | A text to be used in the queue message in the chat widget. Usage is controlled by the flags field, bit number 3 | String(255) | Yes |
| bot_enabled | Enable chatbot on this topic. Run the trigger scripts on bot events. | Bool | Yes |
| bot_name | Chatbot name | String(80) | Yes |
| bot_register_scriptid | Script id to register/unregister chatbot. 0 if there is no bot | FK ejscript | Yes |
| bot_session_created_scriptid | Script id to run on new session. | FK ejscript | Yes |
| bot_session_changed_scriptid | Script id to run when session state changes. | FK ejscript | Yes |
| bot_message_received_scriptid | Script id to run when new messages received from customer. | FK ejscript | Yes |
| use_lunch_hours | Whether to use lunch hours or not. | Bool | Yes |
| lunch_start | When opening hours starts for lunch. Only time-part is used. | DateTime | Yes |
| lunch_stop | When opening hours stops for lunch. Only time-part is used. | DateTime | Yes |
| widget_agent_use_firstname | Whether to use the firstname of the agent in the chat widget. | Bool | Yes |
| warning_chat_message | Contains the user notify time in minutes for new chat messages | Int | No |
| manager_warning_chat_message | Contains the manager notify time in minutes for new chat messages | Int | No |
| offline_form_time_limit | The number of minutes in the queue before the offline form is available | Int | Yes |
| offline_form_queue_length | The number of customers in the queue before the offline form is available | Int | Yes |
| widget_enable_rating | Setting this to true will enable rating support in the chat widget | Bool | Yes |
| widget_rating_text | The text to be displayed in the widget next to the rating stars | String(1024) | Yes |
| widget_badge_color | Optional color for chat widget badge | String(16) | Yes |
| widget_badge_text_color | Optional color for chat widget badge text | String(16) | Yes |
| widget_cust_msg_color | Optional color for chat widget customer message | String(16) | Yes |
| widget_cust_msg_text_color | Optional color for chat widget customer message text | String(16) | Yes |
| widget_agent_msg_color | Optional color for chat widget agent message | String(16) | Yes |
| widget_agent_msg_text_color | Optional color for chat widget agent message text | String(16) | Yes |
| widget_font_size | Optional size for chat widget font | String(16) | Yes |
| widget_button_color | Optional color for chat widget button | String(16) | Yes |
| widget_button_text_color | Optional color for chat widget button text | String(16) | Yes |
