Dixa

Explore the interactive ERD

Table & Field Reference

agent

Column	Type	Keys
`id`	String	PK
`avatar_url`	String
`created_at`	Instant
`display_name`	String
`email`	String
`first_name`	String
`last_name`	String
`middle_name`	Json
`phone_number`	String

agent_presence_active_channel

Column	Type	Keys
`index`	Unknown	PK
`agent_id`	String	PKFK
`request_time`	LocalDateTime	PKFK
`user_id`	Unknown	PKFK
`active_channel`	Unknown

agent_presence

Column	Type	Keys
`request_time`	LocalDateTime	PK
`user_id`	Unknown	PK
`agent_id`	String	PKFK
`connection_status`	Unknown
`last_seen`	Instant
`presence_status`	Unknown

cc_email

Column	Type	Keys
`email_id`	String	PK
`id`	String	PKFK

bcc_email

Column	Type	Keys
`email_id`	String	PK
`id`	String	PKFK

email_recipient

Column	Type	Keys
`email_id`	String	PK
`id`	String	PKFK

attached_file

Column	Type	Keys
`file_name`	String	PK
`id`	String	PKFK

conversation_message

Column	Type	Keys
`id`	String	PK
`author_email`	String	FK
`conversation_id`	Long	FK
`author_name`	String
`chat_input_answer`	String
`chat_input_question`	String
`chat_menu_text`	String
`created_at`	Instant
`direction`	String
`duration`	Long
`from_phone_number`	String
`froms`	String
`initial_channel`	String
`is_automated_message`	Boolean
`recording_url`	String
`text`	String
`to_phone_number`	String
`voicemail_url`	String

conversation_internal_note

Column	Type	Keys
`id`	String	PK
`author_id`	String	FK
`conversation_id`	Long	FK
`created_at`	Instant
`message`	String

conversation_tag

Column	Type	Keys
`conversation_id`	Long	PKFK
`tag_id`	String	PKFK
`is_deactivated`	Boolean

conversation_rating

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Long	FK
`cancelled_timestamp`	Instant
`created_timestamp`	Instant
`languages`	String
`message`	String
`modified_timestamp`	Instant
`offered_timestamp`	Instant
`rated_timestamp`	Instant
`scheduled_for_timestamp`	Instant
`scheduled_timestamp`	Instant
`score`	Int
`status`	String
`type`	String
`unscheduled_timestamp`	Instant

conversation_custom_field_value

Column	Type	Keys
`index`	Unknown	PK
`conversation_custom_field_id`	Unknown	PKFK
`conversation_id`	Long	PKFK
`value`	Unknown

conversation_custom_field

Column	Type	Keys
`conversation_id`	Long	PKFK
`id`	Unknown	PKFK
`data_type`	Unknown

conversation

Column	Type	Keys
`id`	Long	PKFK
`assignee_id`	String	FK
`queue_id`	String	FK
`requester_id`	String	FK
`anonymized_at`	Instant
`assigned_at`	Instant
`assignee_email`	String
`assignee_name`	String
`assignee_phone_number`	String
`closed_at`	Instant
`created_at`	Instant
`direction`	String
`dixa_email_integration_id`	String
`dixa_email_integration_sender_name`	String
`facebook_page_id`	String
`facebook_page_name`	String
`forwarding_email`	String
`from_provisioned_phone_number_id`	String
`from_provisioned_phone_number_name`	String
`handling_duration`	Long
`initial_channel`	String
`last_message_created_at`	Instant
`originating_country`	String
`queue_name`	String
`queued_at`	Instant
`requester_email`	String
`requester_name`	String
`requester_phone_number`	String
`status`	String
`subject`	String
`to_provisioned_phone_number_id`	String
`to_provisioned_phone_number_name`	String
`total_duration`	Long
`transfer_time`	Instant
`transferee_name`	String
`transferee_number`	String
`updated_at`	Instant
`widget_id`	String
`widget_name`	String

team_member

Column	Type	Keys
`agent_id`	String	PKFK
`team_id`	String	PKFK

team

Column	Type	Keys
`id`	String	PK
`name`	String

custom_attribute_nested_option

Column	Type	Keys
`id`	Unknown	PK
`custom_attribute_id`	Unknown	FK
`custom_attribute_input_option_id`	Unknown	FK
`is_deactivated`	Unknown
`label`	Unknown
`nested_option`	Json
`value`	Unknown

custom_attribute_input_option

Column	Type	Keys
`id`	Unknown	PK
`custom_attribute_id`	Unknown	FK
`is_deactivated`	Unknown
`label`	Unknown
`value`	Unknown

custom_attribute

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`entity_type`	Unknown
`identifier`	Unknown
`input_definition_text`	Unknown
`is_archived`	Unknown
`is_deactivated`	Unknown
`is_required`	Unknown
`label`	Unknown
`updated_at`	Unknown

conversation_activity_log

Column	Type	Keys
`id`	String	PK
`author_id`	String	FK
`conversation_id`	Long	FK
`activity_timestamp`	Instant
`activity_type`	String
`type`	String
`attribute_`

queue_member

Column	Type	Keys
`agent_id`	String	PKFK
`queue_id`	String	PKFK
`priority`	Int

end_user

Column	Type	Keys
`id`	String	PK
`avatar_url`	String
`created_at`	Instant
`display_name`	String
`email`	String
`first_name`	String
`last_name`	String
`middle_name`	Json
`phone_number`	String

email_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

facebook_messenger_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

widget_chat_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

voicemail_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

contact_form_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

whatsapp_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

callback_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

pstn_phone_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

messenger_queue

Column	Type	Keys
`id`	String	PK
`queue_id`	String	PKFK

queue

Column	Type	Keys
`id`	String	PK
`do_not_offer_timeouts_callback`	Int
`do_not_offer_timeouts_contact_form`	Int
`do_not_offer_timeouts_email`	Int
`do_not_offer_timeouts_facebook_messenger`	Int
`do_not_offer_timeouts_messenger`	Int
`do_not_offer_timeouts_pstn_phone`	Int
`do_not_offer_timeouts_voicemail`	Int
`do_not_offer_timeouts_whatsapp`	Int
`do_not_offer_timeouts_widget_chat`	Int
`is_default`	Boolean
`is_do_not_offer_enabled`	Boolean
`is_preferred_agent_enabled`	Boolean
`member_list_type`	String
`name`	String
`offer_abandoned_conversations`	Boolean
`offer_timeout`	Int
`offering_algorithm`	String
`organization_id`	String
`personal_agent_offline_timeout`	Int
`preferred_agent_offline_timeout`	Int
`preferred_agent_timeouts_callback`	Int
`preferred_agent_timeouts_contact_form`	Int
`preferred_agent_timeouts_email`	Int
`preferred_agent_timeouts_facebook_messenger`	Int
`preferred_agent_timeouts_messenger`	Int
`preferred_agent_timeouts_pstn_phone`	Int
`preferred_agent_timeouts_voicemail`	Int
`preferred_agent_timeouts_whatsapp`	Int
`preferred_agent_timeouts_widget_chat`	Int
`priority`	Int
`queue_thresholds_available_agents`	Int
`queue_thresholds_longest_wait`	Int
`queue_thresholds_sla_percentage`	Int
`queue_thresholds_sla_time_limit`	Int
`queue_thresholds_waiting_conversations`	Int
`sla_calculation_method`	String
`twilio_queue_sid`	String
`wrapup_timeout`	Int

Dixa

Explore the interactive ERD

Table & Field Reference

agent

agent_presence_active_channel

agent_presence

cc_email

bcc_email

email_recipient

attached_file

conversation_message

conversation_internal_note

conversation_tag

conversation_rating

conversation_custom_field_value

conversation_custom_field

conversation

team_member

team

custom_attribute_nested_option

custom_attribute_input_option

custom_attribute

conversation_activity_log

tags

queue_member

end_user

email_queue

facebook_messenger_queue

widget_chat_queue

voicemail_queue

contact_form_queue

whatsapp_queue

callback_queue

pstn_phone_queue

messenger_queue

queue