# RingCentral schema ERD

Table and field reference for the Fivetran RingCentral connector.

## Table & Field Reference

### meeting

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| extension_id | String | FK |
| id | String |  |
| start_time | Instant |  |
| topic | String |  |

### email_notification_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| extension_id | String | FK |
| from_extension_id | String | FK |
| availability | String |  |
| conversation_id | String |  |
| cover_index | String |  |
| cover_page_text | String |  |
| creation_time | Instant |  |
| delivery_error_code | String |  |
| direction | String |  |
| fax_page_count | String |  |
| fax_resolution | String |  |
| from_location | String |  |
| last_modified_time | Instant |  |
| message_status | String |  |
| pg_to_department | Boolean |  |
| priority | String |  |
| read_status | String |  |
| sms_delivery_time | String |  |
| sms_sending_attempts_count | Int |  |
| subject | String |  |
| type | String |  |
| vm_transcription_status | String |  |

### meeting_setting_audio_option

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| account_id | String | PK, FK |

### service_provider_config

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bulk_max_operations | Int |  |
| bulk_max_payload_size | Int |  |
| bulk_supported | Boolean |  |
| change_password_supported | Boolean |  |
| etag_supported | Boolean |  |
| filter_max_results | Int |  |
| filter_supported | Boolean |  |
| patch_supported | Boolean |  |
| sort_supported | Boolean |  |
| xml_data_format_supported | Boolean |  |

### call_recording_setting

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| on_demand_enabled | Boolean |  |
| on_demand_retention_period | Int |  |
| automatic_** |  |  |

### account_assigned_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| auto_assigned | Boolean |  |
| extension_id | String |  |
| site_restricted | String |  |

### company_directory

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| federated_account_id | String | FK |
| department | String |  |
| email | String |  |
| extension_number | String |  |
| first_name | String |  |
| job_title | String |  |
| last_name | String |  |
| name | String |  |
| profile_image_etag | String |  |
| site_code | String |  |
| site_id | String |  |
| site_name | String |  |
| status | String |  |
| type | String |  |

### extension

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| extension_number | String |  |
| hidden | Boolean |  |
| name | String |  |
| permissions_admin_enabled | Boolean |  |
| permissions_international_calling_enabled | Boolean |  |
| profile_image_content_type | String |  |
| profile_image_etag | String |  |
| profile_image_last_modified | Instant |  |
| site_code | String |  |
| site_id | String |  |
| site_name | String |  |
| status | String |  |
| sub_type | String |  |
| type | String |  |
| call_queue_info_** |  |  |
| contact_** |  |  |

### forwarding_number_feature

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| forwarding_number_id | String | PK, FK |

### missed_call_notification_advanced_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### call_queue_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| call_queue_id | String | FK |
| extension_number | String | FK |

### meeting_assisted_user

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| name | String |  |

### message_to

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| message_id | Long | PK, FK |
| extension_id | String | FK |
| extension_number | String |  |
| fax_error_code | String |  |
| location | String |  |
| message_status | String |  |
| name | String |  |
| phone_number | String |  |
| target | Boolean |  |

### chat_member

| Column | Type | Keys |
| --- | --- | --- |
| chat_id | String | PK, FK |
| id | String | PK, FK |

### inbound_fax_notification_advanced_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### user_auth_profile_scope

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| extension_id | String | PK, FK |

### sms_batch_rejected

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| sms_batch_id | String | PK, FK |
| description | String |  |
| error_code | String |  |

### user_conference_setting

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| allow_join_before_host | Boolean |  |
| host_code | String |  |
| mode | String |  |
| participant_code | String |  |
| primary_phone_number | String |  |
| tap_to_join_uri | String |  |

### extension_device_model_add_on

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_device_id | String | PK, FK |
| count | Int |  |
| name | String |  |

### call_monitoring_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| call_monitoring_group_id | String | FK |
| extension_number | String | FK |

### extension_device

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| emergency_location_id | String | FK |
| emergency_service_address_country_id | String | FK |
| emergency_service_address_state_id | String | FK |
| extension_id | String | FK |
| shipping_address_country_id | String | FK |
| shipping_address_state_id | String | FK |
| box_billing_id | Int |  |
| computer_name | String |  |
| emergency_address_editable_status | String |  |
| emergency_service_address_additional_customer_email | String |  |
| emergency_service_address_additional_customer_name | String |  |
| emergency_service_address_additional_customer_phone | String |  |
| emergency_service_address_city | String |  |
| emergency_service_address_customer_email | String |  |
| emergency_service_address_customer_name | String |  |
| emergency_service_address_customer_phone | String |  |
| emergency_service_address_line_provisioning_status | String |  |
| emergency_service_address_out_of_country | Boolean |  |
| emergency_service_address_street | String |  |
| emergency_service_address_street_2 | String |  |
| emergency_service_address_sync_status | String |  |
| emergency_service_address_tax_id | String |  |
| emergency_service_address_zip | String |  |
| emergency_visibility | String |  |
| in_company_net | Boolean |  |
| last_location_report_time | String |  |
| line_pooling | String |  |
| name | String |  |
| serial | String |  |
| site_id | String |  |
| site_name | String |  |
| sku | String |  |
| status | String |  |
| type | String |  |
| use_as_common_phone | Boolean |  |
| model_** |  |  |
| shipping_** |  |  |

### timezone

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| bias | String |  |
| description | String |  |
| name | String |  |

### permission_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| display_name | String |  |

### caller_blocking_setting

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| mode | String |  |
| no_caller_id | String |  |
| pay_phones | String |  |

### service_provider_config_schema

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| service_provider_config_id | String | PK, FK |

### languages

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| formatting_locale | Boolean |  |
| greeting | Boolean |  |
| iso_code | String |  |
| locale_code | String |  |
| name | String |  |
| ui | Boolean |  |

### user_call_handling_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| enabled | Boolean |  |
| name | String |  |
| shared_lines_timeout | Int |  |
| type | String |  |

### chat_post

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| chat_id | String | FK |
| activity | String |  |
| creation_time | Instant |  |
| creator_id | String |  |
| group_id | String |  |
| icon_emoji | String |  |
| icon_uri | String |  |
| last_modified_time | Instant |  |
| text | String |  |
| title | String |  |
| type | String |  |

### chat_task_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| chat_task_id | String | PK, FK |
| content_uri | String |  |
| name | String |  |
| type | String |  |

### message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| message_id | Long | PK, FK |
| content_type | String |  |
| file_name | String |  |
| height | Int |  |
| size | Int |  |
| type | String |  |
| vm_duration | Int |  |
| width | Int |  |

### meeting_recording

| Column | Type | Keys |
| --- | --- | --- |
| content_download_uri | String | PK |
| meeting_uuid | String | PK, FK |
| content_type | String |  |
| end_time | Instant |  |
| id | String |  |
| size | Long |  |
| start_time | Instant |  |
| status | String |  |

### user_role_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| user_role_id | String | FK |
| assignable | Boolean |  |
| read_only | Boolean |  |
| site_compatible | String |  |

### call_monitoring_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| name | String |  |

### emergency_location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| address_country_id | String | FK |
| address_state_id | String | FK |
| address_city | String |  |
| address_customer_name | String |  |
| address_status | String |  |
| address_street | String |  |
| address_street_2 | String |  |
| address_zip | String |  |
| name | String |  |
| site_id | String |  |
| site_name | String |  |
| sync_status | String |  |
| usage_status | String |  |
| visibility | String |  |

### extension_device_phone_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_device_id | String | PK, FK |
| phone_info_country_id | String | FK |
| phone_info_extension_id | String | FK |
| emergency_address_local_only | Boolean |  |
| emergency_address_required | Boolean |  |
| line_type | String |  |
| phone_info_** |  |  |

### post_attachment_field

| Column | Type | Keys |
| --- | --- | --- |
| style | String | PK |
| title | String | PK |
| value | String | PK |
| post_attachment_id | String | PK, FK |

### user_feature

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| available | Boolean |  |
| reason_code | String |  |
| reason_message | String |  |
| reason_permission | String |  |

### user_call_log

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | PK, FK |
| message_id | String | FK |
| action | String |  |
| billing_cost_included | Int |  |
| billing_cost_purchased | Int |  |
| delegate_id | String |  |
| delegate_name | String |  |
| deleted | Boolean |  |
| direction | String |  |
| duration | Int |  |
| internal_type | String |  |
| last_modified_time | Instant |  |
| reason | String |  |
| reason_description | String |  |
| recording_id | String |  |
| recording_type | String |  |
| result | String |  |
| session_id | String |  |
| short_recording | Boolean |  |
| start_time | Instant |  |
| telephony_session_id | String |  |
| transport | String |  |
| type | String |  |
| from_** |  |  |
| to_** |  |  |

### chat_note

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| chat_id | String | FK |
| creator_id | String | FK |
| last_modified_by_id | String | FK |
| locked_by_id | String | FK |
| creation_time | Instant |  |
| last_modified_time | Instant |  |
| preview | String |  |
| status | String |  |
| title | String |  |
| type | String |  |

### inbound_text_notification_advanced_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### call_recording_extension

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK, FK |
| call_direction | String |  |

### meeting_service_info_dial_in_number

| Column | Type | Keys |
| --- | --- | --- |
| phone_number | String | PK |
| extension_id | String | PK, FK |
| country_id | String | FK |
| formatted_number | String |  |
| location | String |  |

### post_added_person

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| post_id | String | PK, FK |

### chat

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| creation_time | Instant |  |
| description | String |  |
| last_modified_time | Instant |  |
| name | String |  |
| public | Boolean |  |
| status | String |  |
| type | String |  |

### federated_account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| federation_id | String | FK |
| company_name | String |  |
| conflict_count | Long |  |
| federated_name | String |  |
| link_creation_time | String |  |
| main_number_** |  |  |

### email_notification_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### emergency_location_owner

| Column | Type | Keys |
| --- | --- | --- |
| emergency_location_id | String | PK, FK |
| id | String | PK, FK |

### forwarding_number

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | PK, FK |
| device_id | String | FK |
| flip_number | String |  |
| label | String |  |
| phone_number | String |  |
| type | String |  |

### account_call_log_leg

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| account_call_log_id | String | PK, FK |
| message_id | String | FK |
| action | String |  |
| billing_cost_included | Int |  |
| billing_cost_purchased | Int |  |
| delegate_id | String |  |
| delegate_name | String |  |
| direction | String |  |
| duration | Long |  |
| duration_ms | Long |  |
| extension_id | String |  |
| internal_type | String |  |
| leg_type | String |  |
| master | Boolean |  |
| party_id | String |  |
| reason | String |  |
| reason_description | String |  |
| recording_id | String |  |
| recording_type | String |  |
| result | String |  |
| short_recording | Boolean |  |
| sip_uuid_info | String |  |
| start_time | Instant |  |
| telephony_session_id | String |  |
| transfer_target_telephony_session_id | String |  |
| transferee_telephony_session_id | String |  |
| transport | String |  |
| type | String |  |
| from_** |  |  |
| to_** |  |  |

### account_call_log

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| message_id | String | FK |
| action | String |  |
| billing_cost_included | Int |  |
| billing_cost_purchased | Int |  |
| delegate_id | String |  |
| delegate_name | String |  |
| deleted | Boolean |  |
| direction | String |  |
| duration | Long |  |
| duration_ms | Long |  |
| extension_id | String |  |
| internal_type | String |  |
| last_modified_time | Instant |  |
| party_id | String |  |
| reason | String |  |
| reason_description | String |  |
| recording_id | String |  |
| recording_type | String |  |
| result | String |  |
| session_id | String |  |
| short_recording | Boolean |  |
| sip_uuid_info | String |  |
| start_time | Instant |  |
| telephony_session_id | String |  |
| transfer_target_telephony_session_id | String |  |
| transferee_telephony_session_id | String |  |
| transport | String |  |
| type | String |  |
| from_** |  |  |
| to_** |  |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| calling_code | String |  |
| emergency_calling | Boolean |  |
| free_softphone_line | Boolean |  |
| iso_code | String |  |
| login_allowed | Boolean |  |
| name | String |  |
| number_selling | Boolean |  |
| signup_allowed | Boolean |  |

### sms_batch_rejected_to

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| index | Long | PK, FK |
| sms_batch_id | String | PK, FK |

### meeting_assistant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| name | String |  |

### sms_opt_out_number

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| creation_time | String |  |
| from | String |  |
| source | String |  |
| status | String |  |
| to | String |  |

### user_video_configuration

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| provider | String |  |
| user_license_type | String |  |

### user_feature_param

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| user_feature_id | String | PK, FK |
| value | String |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| custom | Boolean |  |
| description | String |  |
| display_name | String |  |
| hidden | Boolean |  |
| last_updated | Instant |  |
| scope | String |  |
| site_compatible | Boolean |  |

### extension_device_model_feature

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| extension_device_id | String | PK, FK |

### company_directory_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_directory_id | String | PK, FK |
| value | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| state_id | String | FK |
| area_code | String |  |
| city | String |  |
| npa | String |  |
| nxx | String |  |

### user_notification_setting

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| advanced_mode | Boolean |  |
| inbound_texts_notify_by_email | Boolean |  |
| inbound_texts_notify_by_sms | Boolean |  |
| include_managers | Boolean |  |
| missed_calls_notify_by_email | Boolean |  |
| missed_calls_notify_by_sms | Boolean |  |
| outbound_faxes_notify_by_email | Boolean |  |
| outbound_faxes_notify_by_sms | Boolean |  |
| inbound_faxes_** |  |  |
| voice_mails_** |  |  |

### voicemail_notification_advanced_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### meeting_setting

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| telephony_third_party_audio | Boolean |  |
| recording_** |  |  |
| schedule_meeting_** |  |  |

### account_signup_state

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| account_id | String | PK, FK |

### voicemail_notification_advanced_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### user_call_log_leg

| Column | Type | Keys |
| --- | --- | --- |
| leg_type | String | PK |
| extension_id | String | PK, FK |
| user_call_log_id | String | PK, FK |
| master | Boolean |  |

### user_conference_setting_dial_in_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| phone_number | String | PK |
| extension_id | String | PK, FK |
| country_id | Long | FK |
| default | Boolean |  |
| has_greeting | Boolean |  |
| location | String |  |
| premium | Boolean |  |

### outbound_fax_notification_advanced_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### call_queue

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| extension_number | String | FK |
| name | String |  |

### meeting_service_info

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| external_user_info** |  |  |

### caller_blocking_setting_greeting

| Column | Type | Keys |
| --- | --- | --- |
| preset_id | String | PK |
| extension_id | String | PK, FK |
| preset_name | String |  |
| type | String |  |

### user_auth_profile

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| effective_role_id | String |  |
| permission_** |  |  |

### account_business_address

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| city | String |  |
| company | String |  |
| country | String |  |
| email | String |  |
| main_site_name | String |  |
| state | String |  |
| street | String |  |
| zip | String |  |

### call_monitoring_group_member_permission

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| call_monitoring_group_member_id | String | PK, FK |

### inbound_fax_notification_advanced_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### call_standard_greeting

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category | String |  |
| content_uri | String |  |
| name | String |  |
| text | String |  |
| type | String |  |
| usage_type | String |  |

### missed_call_notification_advanced_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### post_mention

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| post_id | String | PK, FK |
| type | String |  |

### ivr_prompt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| content_type | String |  |
| content_uri | String |  |
| filename | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| assistant_phone | String |  |
| availability | String |  |
| birthday | String |  |
| business_fax | String |  |
| business_phone | String |  |
| business_phone_2 | String |  |
| callback_phone | String |  |
| car_phone | String |  |
| company | String |  |
| company_phone | String |  |
| email | String |  |
| email_2 | String |  |
| email_3 | String |  |
| first_name | String |  |
| home_phone | String |  |
| home_phone_2 | String |  |
| job_title | String |  |
| last_name | String |  |
| middle_name | String |  |
| mobile_phone | String |  |
| nick_name | String |  |
| notes | String |  |
| other_fax | String |  |
| other_phone | String |  |
| ringtone_index | String |  |
| web_page | String |  |
| business_address_** |  |  |
| home_address_** |  |  |
| other_address_** |  |  |

### state

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| country_id | String | FK |
| iso_code | String |  |
| name | String |  |

### sms

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| batch_id | String | FK |
| cost | Long |  |
| creation_time | Instant |  |
| direction | String |  |
| error_code | String |  |
| from | String |  |
| last_modified_time | Instant |  |
| message_status | String |  |
| segment_count | Int |  |
| text | String |  |

### company_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| country_id | String | FK |
| extension_id | String | FK |
| contact_center_provider_id | String |  |
| contact_center_provider_name | String |  |
| label | String |  |
| location | String |  |
| payment_type | String |  |
| phone_number | String |  |
| status | String |  |
| temporary_number_id | String |  |
| type | String |  |
| usage_type | String |  |
| vanity_pattern | String |  |

### chat_task

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| chat_id | String | FK |
| creator_id | String | FK |
| color | String |  |
| completeness_condition | String |  |
| completeness_percentage | Long |  |
| creation_time | Instant |  |
| description | String |  |
| due_date | Instant |  |
| last_modified_time | Instant |  |
| section | String |  |
| start_date | Instant |  |
| status | String |  |
| subject | String |  |
| type | String |  |
| recurrence_** |  |  |

### user_business_hour_range

| Column | Type | Keys |
| --- | --- | --- |
| day | String | PK |
| index | Int | PK |
| extension_id | String | PK, FK |
| from | String |  |
| to | String |  |

### inbound_text_notification_advanced_sms_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### outbound_fax_notification_advanced_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| extension_id | String | PK, FK |

### sms_to

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| sms_id | Long | PK, FK |

### account_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| category | String |  |
| display_name | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| operator_id | String | FK |
| regional_settings_formatting_locale_id | String | FK |
| regional_settings_greeting_language_id | String | FK |
| regional_settings_home_country_id | String | FK |
| regional_settings_language_id | String | FK |
| regional_settings_timezone_id | String | FK |
| service_info_brand_home_country_id | String | FK |
| service_info_contracted_country_id | String | FK |
| bsid | String |  |
| cfid | String |  |
| federated | Boolean |  |
| main_number | String |  |
| outbound_call_prefix | Int |  |
| partner_id | String |  |
| setup_wizard_state | String |  |
| signup_info_marketing_accepted | Boolean |  |
| signup_info_tos_accepted | Boolean |  |
| signup_info_verification_reason | String |  |
| status | String |  |
| status_info_comment | String |  |
| status_info_reason | String |  |
| status_info_till | String |  |
| limits_** |  |  |
| regional_settings_** |  |  |
| service_info_** |  |  |

### company_business_hour_range

| Column | Type | Keys |
| --- | --- | --- |
| day | String | PK |
| index | Int | PK |
| account_id | String | PK, FK |
| from | String |  |
| to | String |  |

### post_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| post_id | String | PK, FK |
| all_day | Boolean |  |
| author_icon_uri | String |  |
| author_name | String |  |
| color | String |  |
| creator_id | String |  |
| description | String |  |
| end_time | Instant |  |
| ending_after | Long |  |
| ending_condition | String |  |
| ending_on | String |  |
| fallback | String |  |
| footnote_icon_uri | String |  |
| footnote_text | String |  |
| footnote_time | String |  |
| image_uri | String |  |
| intro | String |  |
| location | String |  |
| recurrence | String |  |
| start_time | Instant |  |
| text | String |  |
| thumbnail_uri | String |  |
| title | String |  |
| type | String |  |

### user_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | String | FK |
| assignable | Boolean |  |
| description | String |  |
| display_name | String |  |
| read_only | Boolean |  |
| site_compatible | String |  |

### sms_batch

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| batch_size | Int |  |
| creation_time | Instant |  |
| from | String |  |
| last_modified_time | Instant |  |
| processed_count | Int |  |
| status | String |  |

### call_recording_custom_greeting

| Column | Type | Keys |
| --- | --- | --- |
| custom_id | String | PK |
| account_id | String | FK |
| language_id | String | FK |
| type | String |  |

### included_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_permission_id | String | PK, FK |
| assignable | Boolean |  |
| read_only | Boolean |  |
| site_compatible | String |  |

### service_provider_config_authentication_scheme

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| service_provider_config_id | String | PK, FK |
| description | String |  |
| documentation_uri | String |  |
| primary | Boolean |  |
| spec_uri | String |  |

### federation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| creation_time | String |  |
| display_name | String |  |
| last_modified_time | Instant |  |

### blocked_and_allowed_number

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| extension_id | String | FK |
| label | String |  |
| phone_number | String |  |
| status | String |  |

### extension_grant

| Column | Type | Keys |
| --- | --- | --- |
| extension_id | String | PK, FK |
| call_delegation | Boolean |  |
| call_monitoring | Boolean |  |
| call_on_behalf_of | Boolean |  |
| call_pickup | Boolean |  |
| call_queue_members_setup | Boolean |  |
| call_queue_messages | Boolean |  |
| call_queue_setup | Boolean |  |
| group_paging | Boolean |  |

### chat_task_assignee

| Column | Type | Keys |
| --- | --- | --- |
| chat_task_id | String | PK, FK |
| id | String | PK, FK |
| status | String |  |

### company_directory_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| phone_number | String | PK |
| company_directory_id | String | PK, FK |
| formatted_phone_number | String |  |
| hidden | Boolean |  |
| label | String |  |
| primary | Boolean |  |
| type | String |  |
| usage_type | String |  |

### user_template

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| creation_time | Instant |  |
| last_modified_time | Instant |  |
| name | String |  |
| type | String |  |

## Relationships

- meeting(extension_id) → extension(id)
- email_notification_email(extension_id) → extension(id)
- message(extension_id) → extension(id)
- message(from_extension_id) → extension(id)
- meeting_setting_audio_option(account_id) → account(id)
- call_recording_setting(account_id) → account(id)
- account_assigned_role(id) → user_role(id)
- company_directory(federated_account_id) → federated_account(id)
- extension(account_id) → account(id)
- forwarding_number_feature(forwarding_number_id) → forwarding_number(id)
- missed_call_notification_advanced_sms_email(extension_id) → extension(id)
- call_queue_member(call_queue_id) → call_queue(id)
- call_queue_member(extension_number) → extension(id)
- meeting_assisted_user(extension_id) → extension(id)
- message_to(message_id) → message(id)
- message_to(extension_id) → extension(id)
- chat_member(chat_id) → chat(id)
- chat_member(id) → extension(id)
- inbound_fax_notification_advanced_sms_email(extension_id) → extension(id)
- user_auth_profile_scope(extension_id) → extension(id)
- sms_batch_rejected(sms_batch_id) → sms_batch(id)
- user_conference_setting(extension_id) → extension(id)
- extension_device_model_add_on(extension_device_id) → extension_device(id)
- call_monitoring_group_member(call_monitoring_group_id) → call_monitoring_group(id)
- call_monitoring_group_member(extension_number) → extension(id)
- extension_device(extension_id) → extension(id)
- extension_device(emergency_service_address_state_id) → state(id)
- extension_device(emergency_service_address_country_id) → country(id)
- extension_device(emergency_location_id) → emergency_location(id)
- extension_device(shipping_address_state_id) → state(id)
- extension_device(shipping_address_country_id) → country(id)
- caller_blocking_setting(extension_id) → extension(id)
- service_provider_config_schema(service_provider_config_id) → service_provider_config(_fivetran_id)
- user_call_handling_rule(extension_id) → extension(id)
- chat_post(chat_id) → chat(id)
- chat_task_attachment(chat_task_id) → chat_task(id)
- message_attachment(message_id) → message(id)
- meeting_recording(meeting_uuid) → meeting(uuid)
- user_role_permission(user_role_id) → user_role(id)
- user_role_permission(id) → user_permission(id)
- call_monitoring_group(account_id) → account(id)
- emergency_location(account_id) → account(id)
- emergency_location(address_country_id) → country(id)
- emergency_location(address_state_id) → state(id)
- extension_device_phone_line(extension_device_id) → extension_device(id)
- extension_device_phone_line(phone_info_country_id) → country(id)
- extension_device_phone_line(phone_info_extension_id) → extension(id)
- post_attachment_field(post_attachment_id) → post_attachment(post_id)
- user_feature(extension_id) → extension(id)
- user_call_log(extension_id) → extension(id)
- user_call_log(message_id) → message(id)
- chat_note(chat_id) → chat(id)
- chat_note(creator_id) → extension(id)
- chat_note(last_modified_by_id) → extension(id)
- chat_note(locked_by_id) → extension(id)
- inbound_text_notification_advanced_email(extension_id) → extension(id)
- call_recording_extension(id) → extension(id)
- meeting_service_info_dial_in_number(extension_id) → extension(id)
- meeting_service_info_dial_in_number(country_id) → country(id)
- post_added_person(post_id) → chat_post(id)
- federated_account(federation_id) → federation(id)
- email_notification_sms_email(extension_id) → extension(id)
- emergency_location_owner(emergency_location_id) → emergency_location(id)
- emergency_location_owner(id) → extension(id)
- forwarding_number(extension_id) → extension(id)
- forwarding_number(device_id) → extension_device(id)
- account_call_log_leg(message_id) → message(id)
- account_call_log_leg(account_call_log_id) → account_call_log(id)
- account_call_log(message_id) → message(id)
- account_call_log(account_id) → account(id)
- sms_batch_rejected_to(sms_batch_id) → sms_batch(id)
- sms_batch_rejected_to(index) → sms_batch_rejected(index)
- meeting_assistant(extension_id) → extension(id)
- sms_opt_out_number(account_id) → account(id)
- user_video_configuration(extension_id) → extension(id)
- user_feature_param(user_feature_id) → user_feature(id)
- user_role(account_id) → account(id)
- extension_device_model_feature(extension_device_id) → extension_device(id)
- company_directory_custom_field(company_directory_id) → company_directory(id)
- location(state_id) → state(id)
- user_notification_setting(extension_id) → extension(id)
- voicemail_notification_advanced_email(extension_id) → extension(id)
- meeting_setting(account_id) → account(id)
- account_signup_state(account_id) → account(id)
- voicemail_notification_advanced_sms_email(extension_id) → extension(id)
- user_call_log_leg(user_call_log_id) → user_call_log(id)
- user_call_log_leg(extension_id) → extension(id)
- user_conference_setting_dial_in_phone_number(extension_id) → extension(id)
- user_conference_setting_dial_in_phone_number(country_id) → country(id)
- outbound_fax_notification_advanced_sms_email(extension_id) → extension(id)
- call_queue(account_id) → account(id)
- call_queue(extension_number) → extension(id)
- meeting_service_info(extension_id) → extension(id)
- caller_blocking_setting_greeting(extension_id) → extension(id)
- user_auth_profile(extension_id) → extension(id)
- account_business_address(account_id) → account(id)
- call_monitoring_group_member_permission(call_monitoring_group_member_id) → call_monitoring_group_member(id)
- inbound_fax_notification_advanced_email(extension_id) → extension(id)
- missed_call_notification_advanced_email(extension_id) → extension(id)
- post_mention(post_id) → chat_post(id)
- post_mention(id) → extension(id)
- ivr_prompt(account_id) → account(id)
- contact(extension_id) → extension(id)
- state(country_id) → country(id)
- sms(batch_id) → sms_batch(id)
- company_phone_number(country_id) → country(id)
- company_phone_number(extension_id) → extension(id)
- chat_task(chat_id) → chat(id)
- chat_task(creator_id) → extension(id)
- user_business_hour_range(extension_id) → extension(id)
- inbound_text_notification_advanced_sms_email(extension_id) → extension(id)
- outbound_fax_notification_advanced_email(extension_id) → extension(id)
- sms_to(sms_id) → sms(id)
- account_custom_field(account_id) → account(id)
- account(regional_settings_home_country_id) → country(id)
- account(regional_settings_timezone_id) → timezone(id)
- account(regional_settings_language_id) → languages(id)
- account(regional_settings_greeting_language_id) → languages(id)
- account(regional_settings_formatting_locale_id) → languages(id)
- account(operator_id) → extension(id)
- account(service_info_brand_home_country_id) → country(id)
- account(service_info_contracted_country_id) → country(id)
- company_business_hour_range(account_id) → account(id)
- post_attachment(post_id) → chat_post(id)
- user_permission(category_id) → permission_category(id)
- sms_batch(account_id) → account(id)
- call_recording_custom_greeting(account_id) → account(id)
- call_recording_custom_greeting(language_id) → languages(id)
- included_permission(user_permission_id) → user_permission(id)
- service_provider_config_authentication_scheme(service_provider_config_id) → service_provider_config(_fivetran_id)
- federation(account_id) → account(id)
- blocked_and_allowed_number(extension_id) → extension(id)
- extension_grant(extension_id) → extension(id)
- chat_task_assignee(chat_task_id) → chat_task(id)
- chat_task_assignee(id) → extension(id)
- company_directory_phone_number(company_directory_id) → company_directory(id)
- user_template(account_id) → account(id)