# Infobip schema ERD

Table and field reference for the Fivetran Infobip connector.

## 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 | PK, FK |
| field_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| queue_id | Unknown | PK, FK |

### 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 | PK, FK |

### person_phone

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| person_id | Unknown | PK, FK |

### person_push

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK |
| person_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### field_options

| Column | Type | Keys |
| --- | --- | --- |
| option_name | Unknown | PK |
| field_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 |  |

## Relationships

- trigger(conversation_form_id) → conversation_form(id)
- disposition_field_name(field_id) → field(id)
- disposition_field_name(disposition_form_id) → disposition(form_id)
- disposition(conversation_id) → conversation(id)
- disposition(conversation_form_id) → conversation_form(id)
- waiting_strategy_client_type(waiting_strategy_id) → waiting_strategy(id)
- message(conversation_id) → conversation(id)
- note(conversation_id) → conversation(id)
- note(agent_id) → agent(id)
- routings(queue_id) → queue(id)
- hold_config_queue(queue_id) → queue(id)
- hold_config_queue(hold_config_id) → hold_config(id)
- agent_wrap_up(agent_id) → agent(id)
- person_email(person_id) → person(id)
- person_phone(person_id) → person(id)
- person_push(person_id) → person(id)
- person_shopping_cart_list(person_id) → person(id)
- person(id) → company(id)
- person_social_account(person_id) → person(id)
- field_operator(field_id) → field(id)
- field_options(field_id) → field(id)
- agent_conversation(queue_id) → queue(id)
- agent_conversation(agent_id) → agent(id)
- queue(working_hours_id) → working_hour(id)
- company_domain(company_id) → company(id)
- eligible_queue(queue_id) → queue(id)
- agent_recording(id) → agent(id)
- conversation(queue_id) → queue(id)
- conversation(agent_id) → agent(id)