Infobip

Explore the interactive ERD

Table & Field Reference

conversation_form

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`form_fields`	Unknown
`is_default`	Unknown
`is_enabled`	Unknown
`title`	Unknown
`updated_at`	Unknown

trigger

Column	Type	Keys
`id`	Unknown	PK
`conversation_form_id`	Unknown	FK
`expression_neq_queue`	Unknown
`form_id`	Unknown
`is_enabled`	Unknown
`order_index`	Unknown
`times_triggered`	Unknown
`title`	Unknown

disposition_field_name

Column	Type	Keys
`disposition_form_id`	Unknown	PKFK
`field_id`	Unknown	PKFK
`disposition_id`	Unknown
`disposition_value`	Unknown

disposition

Column	Type	Keys
`form_id`	Unknown	PK
`conversation_form_id`	Unknown	FK
`conversation_id`	Unknown	FK

agent

Column	Type	Keys
`id`	Unknown	PK
`availability`	Unknown
`created_at`	Unknown
`display_name`	Unknown
`enabled`	Unknown
`role`	Unknown
`status`	Unknown
`updated_at`	Unknown

waiting_strategy_client_type

Column	Type	Keys
`client_types`	Unknown	PK
`waiting_strategy_id`	Unknown	PKFK

waiting_strategy

Column	Type	Keys
`id`	Unknown	PK
`announcement_message_audio_source_type`	Unknown
`announcement_message_enabled`	Unknown
`announcement_message_repeat_interval_unit`	Unknown
`announcement_message_repeat_interval_value`	Unknown
`announcement_message_tts_audio_source_languages`	Unknown
`announcement_message_tts_audio_source_speech_rate`	Unknown
`announcement_message_tts_audio_source_text`	Unknown
`announcement_message_tts_audio_source_voice_gender`	Unknown
`announcement_message_tts_audio_source_voice_name`	Unknown
`applications`	Json
`created_at`	Unknown
`did_numbers`	Json
`greeting_message_audio_source_type`	Unknown
`greeting_message_enabled`	Unknown
`greeting_message_tts_audio_source_languages`	Unknown
`greeting_message_tts_audio_source_speech_rate`	Unknown
`greeting_message_tts_audio_source_text`	Unknown
`greeting_message_tts_audio_source_voice_gender`	Unknown
`greeting_message_tts_audio_source_voice_name`	Unknown
`maximum_wait_time_message_audio_source_type`	Unknown
`maximum_wait_time_message_enabled`	Unknown
`maximum_wait_time_message_tts_audio_source_languages`	Unknown
`maximum_wait_time_message_tts_audio_source_speech_rate`	Unknown
`maximum_wait_time_message_tts_audio_source_text`	Unknown
`maximum_wait_time_message_tts_audio_source_voice_gender`	Unknown
`maximum_wait_time_message_tts_audio_source_voice_name`	Unknown
`maximum_wait_time_unit`	Unknown
`maximum_wait_time_value`	Unknown
`music_on_hold_enabled`	Unknown
`name`	Unknown
`updated_at`	Unknown
`version`	Unknown

message

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	FK
`channel`	Unknown
`content_text`	Unknown
`content_type`	Unknown
`created_at`	Unknown
`direction`	Unknown
`froms`	Unknown
`single_send_message`	Json
`tos`	Unknown
`updated_at`	Unknown

note

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Unknown	FK
`conversation_id`	Unknown	FK
`content`	Unknown
`created_at`	Unknown
`type`	Unknown
`updated_at`	Unknown

routings

Column	Type	Keys
`id`	Unknown	PK
`queue_id`	Unknown	FK
`created_at`	Unknown
`enabled`	Unknown
`expresssion`	Json
`name`	Unknown
`orders`	Unknown
`priority`	Unknown
`queue_name`	Unknown
`route_only_during_working_hours`	Unknown
`updated_at`	Unknown

hold_config_queue

Column	Type	Keys
`hold_config_id`	Unknown	PKFK
`queue_id`	Unknown	PKFK

hold_config

Column	Type	Keys
`id`	Unknown	PK
`announcement_message_audio_source_type`	Unknown
`announcement_message_duration_unit`	Unknown
`announcement_message_duration_value`	Unknown
`announcement_message_file_audio_source_file_descriptor`	Unknown
`announcement_message_tts_audio_source_file_descriptor`	Unknown
`announcement_message_tts_audio_source_languages`	Unknown
`announcement_message_tts_audio_source_speech_rate`	Unknown
`announcement_message_tts_audio_source_text`	Unknown
`announcement_message_tts_audio_source_voice_gender`	Unknown
`announcement_message_tts_audio_source_voice_name`	Unknown
`created_at`	Unknown
`defaults`	Unknown
`enabled`	Unknown
`name`	Unknown
`on_hold_music_enabled`	Unknown
`on_hold_music_file_audio_source_file_descriptor`	Unknown
`on_hold_music_use_default`	Unknown
`updated_at`	Unknown

agent_wrap_up

Column	Type	Keys
`_fivetran_id`	String	PK
`agent_id`	Unknown	FK
`is_active`	Unknown
`wrap_up_seconds`	Unknown

person_email

Column	Type	Keys
`address`	Unknown	PK
`person_id`	Unknown	PKFK

person_phone

Column	Type	Keys
`number`	Unknown	PK
`person_id`	Unknown	PKFK

person_push

Column	Type	Keys
`application_id`	Unknown	PK
`person_id`	Unknown	PKFK
`additional_data_birthdate`	Unknown
`additional_data_email`	Unknown
`additional_data_first_name`	Unknown
`additional_data_gender`	Unknown
`additional_data_last_name`	Unknown
`additional_data_middle_name`	Unknown
`registration_id`	Unknown
`system_data_`

person_shopping_cart_list

Column	Type	Keys
`_fivetran_id`	String	PK
`person_id`	Unknown	FK
`product_category`	Unknown
`product_image`	Unknown
`product_name`	Unknown
`product_price`	Unknown

person

Column	Type	Keys
`id`	Unknown	PKFK
`address`	Unknown
`birth_date`	Unknown
`city`	Unknown
`company_id`	Unknown
`country`	Unknown
`created_at`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`gender`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`modified_at`	Unknown
`modified_from`	Unknown
`origin`	Unknown
`profile_picture`	Unknown
`type`	Unknown

person_social_account

Column	Type	Keys
`application_id`	Unknown	PK
`person_id`	Unknown	PKFK
`type`	Unknown
`user_id`	Unknown
`system_data_`

bot

Column	Type	Keys
`id`	Unknown	PK
`channel`	Unknown
`destination`	Unknown
`display_name`	Unknown
`enabled`	Unknown
`message_persistence_policy`	Unknown
`session_timeout_in_sec`	Unknown
`webhook_event_headers`	Json
`webhook_event_url`	Unknown
`webhook_url`	Unknown

field_operator

Column	Type	Keys
`operator_name`	Unknown	PK
`field_id`	Unknown	PKFK

field_options

Column	Type	Keys
`option_name`	Unknown	PK
`field_id`	Unknown	PKFK

field

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_default`	Boolean
`is_enabled`	Unknown
`regex`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown

agent_conversation

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Unknown	FK
`queue_id`	Unknown	FK
`closed_at`	Unknown
`created_at`	Unknown
`pending_since`	Unknown
`priority`	Unknown
`status`	Unknown
`summary`	Unknown
`topic`	Unknown
`updated_at`	Unknown

account_wrap_up

Column	Type	Keys
`_fivetran_id`	String	PK
`is_active`	Unknown
`wrap_up_seconds`	Unknown

queue

Column	Type	Keys
`id`	Unknown	PK
`working_hours_id`	Unknown	FK
`created_at`	Unknown
`deleted_at`	Unknown
`enabled_agents_count`	Unknown
`enabled_routes_count`	Unknown
`is_auto_assignment_enabled`	Unknown
`is_sticky_auto_assignment_enabled`	Unknown
`name`	Unknown
`sticky_agent_timeout_days`	Unknown
`updated_at`	Unknown

company_domain

Column	Type	Keys
`domain_name`	Unknown	PK
`company_id`	Unknown	PKFK

company

Column	Type	Keys
`id`	Unknown	PK
`account_manager`	Unknown
`country`	Unknown
`created_at`	Unknown
`custom_attributes_contract_expiry`	Unknown
`customer_stage`	Unknown
`industry`	Unknown
`modified_at`	Unknown
`modified_from`	Unknown
`name`	Unknown
`notes`	Unknown
`origin`	Unknown
`region`	Unknown
`segment`	Unknown
`service_data`	Json
`vat_number`	Unknown

eligible_queue

Column	Type	Keys
`_fivetran_id`	String	PK
`queue_id`	Unknown	FK
`active`	Unknown
`auto_assignment_enabled`	Unknown
`queue_name`	Unknown

agent_recording

Column	Type	Keys
`agent_id`	Unknown	PK
`id`	Unknown	FK
`enabled`	Unknown
`enabled_changed_at`	Unknown
`inbound`	Unknown
`media_type`	Unknown
`outbound`	Unknown
`use_default`	Unknown

account_recording

Column	Type	Keys
`_fivetran_id`	String	PK
`enabled`	Unknown
`enabled_changed_at`	Unknown
`inbound`	Unknown
`media_type`	Unknown
`outbound`	Unknown
`video_download_preparation`	Unknown

working_hour

Column	Type	Keys
`id`	Unknown	PK
`close_conversations`	Unknown
`enabled`	Unknown
`holidays`	Json
`is_default`	Unknown
`message`	Unknown
`name`	Unknown
`timezone`	Unknown
`work_week`	Json

conversation

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Unknown	FK
`queue_id`	Unknown	FK
`closed_at`	Unknown
`created_at`	Unknown
`pending_since`	Unknown
`priority`	Unknown
`status`	Unknown
`summary`	Unknown
`topic`	Unknown
`updated_at`	Unknown