# Ringover schema ERD

Table and field reference for the Fivetran Ringover connector.

## Table & Field Reference

### group_user

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| orders | Unknown |  |
| ring_duration | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| is_jumper | Unknown |  |
| name | Unknown |  |
| total_users_count | Unknown |  |

### ivr

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| name | Unknown |  |

### call_survey

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | Unknown | FK |
| channel_id | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| profile_id | Unknown | PK |
| name | Unknown |  |

### call_tag

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### call

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| call_user_id | Unknown | FK |
| conference_id | Unknown | FK |
| contact_id | Unknown | FK |
| ivr_id | Unknown | FK |
| amd | Unknown |  |
| answered_time | Unknown |  |
| cdr_id | Unknown |  |
| channel_id | Unknown |  |
| contact_number | Unknown |  |
| direction | Unknown |  |
| end_time | Unknown |  |
| fax | Unknown |  |
| from_number | Unknown |  |
| incall_duration | Unknown |  |
| is_archived | Unknown |  |
| last_state | Unknown |  |
| note | Unknown |  |
| record | Unknown |  |
| scenario_id | Unknown |  |
| scenario_name | Unknown |  |
| star | Unknown |  |
| start_time | Unknown |  |
| to_number | Unknown |  |
| total_duration | Unknown |  |
| type | Unknown |  |
| voicemail | Unknown |  |

### ivr_scenario

| Column | Type | Keys |
| --- | --- | --- |
| ivr_id | Unknown | PK |
| scenario_id | Unknown | PK |
| id | Unknown | FK |
| color | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| scenario_type | Unknown |  |

### conversation_member

| Column | Type | Keys |
| --- | --- | --- |
| conversation_user_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| contact_id | Unknown | FK |
| coversation_id | Unknown | FK |
| group_id | Unknown | FK |
| ivr_id | Unknown | FK |
| number_raw | Unknown | FK |
| user_id | Unknown | FK |
| alphanumeric | Unknown |  |
| is_administrator | Unknown |  |
| picture | Unknown |  |
| table_name | String |  |

### conversation_star

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| star | Unknown |  |

### conversation_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| tags | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK |
| user_id | Unknown | PK |
| last_message_id | Unknown | FK |
| adminrules_can_invite | Unknown |  |
| adminrules_can_join | Unknown |  |
| adminrules_can_kick | Unknown |  |
| adminrules_can_leave | Unknown |  |
| adminrules_can_view_history | Unknown |  |
| can_thread_in | Unknown |  |
| creation_date | Unknown |  |
| favorite | Unknown |  |
| is_archived | Unknown |  |
| is_commented_by | Unknown |  |
| is_mms_write | Unknown |  |
| is_sms_write | Unknown |  |
| name | Unknown |  |
| purpose | Unknown |  |
| total_messages_count | Unknown |  |
| type | Unknown |  |
| unread_comment | Unknown |  |
| unread_messages_count | Unknown |  |
| update_date | Unknown |  |
| user_list | Json |  |

### number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conference_id | Unknown | FK |
| ivr_id | Unknown | FK |
| user_id | Unknown | FK |
| format_country | Unknown |  |
| format_country_code | Unknown |  |
| format_e_164_format | Unknown |  |
| format_international | Unknown |  |
| format_international_alt | Unknown |  |
| format_is_short_code | Unknown |  |
| format_national | Unknown |  |
| format_national_alt | Unknown |  |
| format_raw | Unknown |  |
| format_rfc_3966_format | Unknown |  |
| is_callable | Unknown |  |
| is_sms | Unknown |  |
| is_sms_write | Unknown |  |
| label | Unknown |  |
| type | Unknown |  |

### user_snooze_log_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| comment | Unknown |  |
| creation_date | Unknown |  |
| end_date | Unknown |  |
| label | Unknown |  |
| label_en | Unknown |  |
| label_es | Unknown |  |
| label_fr | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |

### user_snooze_log

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### transcription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | FK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |
| creation_date | Unknown |  |
| provider | Unknown |  |
| standard_id | Unknown |  |
| transcription_cdn_path | Unknown |  |
| transcription_status | Unknown |  |

### conversation_message_list

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conference_id | Unknown | FK |
| contact_id | Unknown | FK |
| conversation_user_id | Unknown | FK |
| number_raw | Unknown | FK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |
| archive_date | Unknown |  |
| buffer | Unknown |  |
| creation_date | Unknown |  |
| direction | Unknown |  |
| is_archived | Unknown |  |
| is_failed | Unknown |  |
| mdr_uuid | Unknown |  |
| nb_fragment | Unknown |  |
| thread_buffer_section | Unknown |  |
| thread_conversation_id_linked | Unknown |  |
| thread_conversation_sms_id_linked | Unknown |  |
| thread_nb_response | Unknown |  |
| thread_thread_uuid | Unknown |  |
| total_plan | Unknown |  |
| total_price | Unknown |  |
| update_date | Unknown |  |

### conversation_message

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| creation_date | Unknown |  |
| is_archived | Unknown |  |
| is_sms_write | Unknown |  |
| name | Unknown |  |
| purpose | Unknown |  |
| type | Unknown |  |
| unread_messages_count | Unknown |  |
| update_date | Unknown |  |

### user_planning_time_range

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| day | Unknown |  |
| ends | Unknown |  |
| start | Unknown |  |

### user_planning

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |
| team_id | Unknown | FK |
| is_planning | Unknown |  |
| is_snooze | Unknown |  |
| planning_enable | Unknown |  |
| tz_identifier | Unknown |  |
| tz_now | Unknown |  |

### blacklist

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| comment | Unknown |  |
| direction | Unknown |  |

### team_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_ivr

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team_conference

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | FK |
| color | Unknown |  |
| company | Unknown |  |
| concat_name | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| initial | Unknown |  |
| last_name | Unknown |  |
| picture | Unknown |  |

### contact_number

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK |
| user_id | Unknown | PK |
| team_id | Unknown | FK |
| user_id | Unknown | FK |
| color | Unknown |  |
| company | Unknown |  |
| concat_name | Unknown |  |
| creation_date | Unknown |  |
| first_name | Unknown |  |
| im_owner | Unknown |  |
| initial | Unknown |  |
| is_shared | Unknown |  |
| last_name | Unknown |  |
| profile_picture | Unknown |  |
| social_data | Unknown |  |
| social_profile_url | Unknown |  |
| social_service | Unknown |  |
| social_service_id | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| creation_date | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

## Relationships

- group_user(user_id) → users(id)
- group_user(group_id) → groups(id)
- call_survey(call_id) → call(call_id)
- call_tag(id) → tags(id)
- call_tag(user_id) → call(user_id)
- call_tag(team_id) → call(team_id)
- call_tag(call_id) → call(call_id)
- call(conference_id) → team_conference(id)
- call(call_user_id) → users(id)
- call(ivr_id) → ivr(id)
- call(contact_id) → contact(id)
- call(user_id) → users(id)
- call(team_id) → team(id)
- ivr_scenario(id) → ivr(id)
- conversation_member(user_id) → users(id)
- conversation_member(group_id) → groups(id)
- conversation_member(ivr_id) → ivr(id)
- conversation_member(number_raw) → number(format_raw)
- conversation_member(contact_id) → contact(id)
- conversation_member(conversation_id) → conversation(id)
- conversation_member(coversation_id) → conversation(id)
- conversation_star(conversation_id) → conversation(id)
- conversation_star(user_id) → conversation(user_id)
- conversation_star(team_id) → conversation(team_id)
- conversation_tag(conversation_id) → conversation(id)
- conversation_tag(user_id) → conversation(user_id)
- conversation_tag(team_id) → conversation(team_id)
- conversation(last_message_id) → conversation_message_list(conversation_id)
- number(user_id) → users(id)
- number(conference_id) → team_conference(id)
- number(ivr_id) → ivr(id)
- user_snooze_log_list(user_id) → user_snooze_log(user_id)
- user_snooze_log_list(team_id) → user_snooze_log(team_id)
- user_snooze_log(user_id) → users(id)
- user_snooze_log(team_id) → team(id)
- transcription(user_id) → users(id)
- transcription(team_id) → team(id)
- transcription(call_id) → call(call_id)
- conversation_message_list(user_id) → users(id)
- conversation_message_list(conference_id) → team_conference(id)
- conversation_message_list(team_id) → team(id)
- conversation_message_list(conversation_user_id) → conversation_member(conversation_user_id)
- conversation_message_list(number_raw) → number(format_raw)
- conversation_message_list(conversation_id) → conversation_message(user_id)
- conversation_message_list(contact_id) → contact(id)
- conversation_message(user_id) → users(id)
- conversation_message(team_id) → team(id)
- conversation_message(conversation_id) → conversation(id)
- user_planning_time_range(user_id) → user_planning(user_id)
- user_planning(user_id) → users(id)
- user_planning(team_id) → team(id)
- blacklist(user_id) → users(id)
- blacklist(team_id) → team(id)
- blacklist(number) → number(id)
- team_number(id) → number(id)
- team_number(team_id) → team(id)
- team_ivr(id) → ivr(id)
- team_ivr(team_id) → team(id)
- team_tag(id) → tags(id)
- team_tag(team_id) → team(id)
- team_group(id) → groups(id)
- team_group(team_id) → team(id)
- team_conference(team_id) → team(id)
- users(team_id) → team(id)
- contact_number(id) → number(id)
- contact_number(user_id) → users(id)
- contact_number(team_id) → team(id)
- contact_number(contact_id) → contact(id)
- contact_number(user_id) → contact(user_id)
- contact_number(team_id) → contact(team_id)
- contact(user_id) → users(id)
- contact(team_id) → team(id)