RingCentral

Explore the interactive ERD

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	PKFK

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	PKFK

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	PKFK
`on_demand_enabled`	Boolean
`on_demand_retention_period`	Int
`automatic_`

account_assigned_role

Column	Type	Keys
`id`	String	PKFK
`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	PKFK

missed_call_notification_advanced_sms_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

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	PKFK
`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	PKFK
`id`	String	PKFK

inbound_fax_notification_advanced_sms_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

user_auth_profile_scope

Column	Type	Keys
`value`	String	PK
`extension_id`	String	PKFK

sms_batch_rejected

Column	Type	Keys
`index`	Long	PK
`sms_batch_id`	String	PKFK
`description`	String
`error_code`	String

user_conference_setting

Column	Type	Keys
`extension_id`	String	PKFK
`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	PKFK
`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	PKFK
`mode`	String
`no_caller_id`	String
`pay_phones`	String

service_provider_config_schema

Column	Type	Keys
`value`	String	PK
`service_provider_config_id`	String	PKFK

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	PKFK
`content_uri`	String
`name`	String
`type`	String

message_attachment

Column	Type	Keys
`id`	Long	PK
`message_id`	Long	PKFK
`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	PKFK
`content_type`	String
`end_time`	Instant
`id`	String
`size`	Long
`start_time`	Instant
`status`	String

user_role_permission

Column	Type	Keys
`id`	String	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`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	PKFK

call_recording_extension

Column	Type	Keys
`id`	Long	PKFK
`call_direction`	String

meeting_service_info_dial_in_number

Column	Type	Keys
`phone_number`	String	PK
`extension_id`	String	PKFK
`country_id`	String	FK
`formatted_number`	String
`location`	String

post_added_person

Column	Type	Keys
`value`	String	PK
`post_id`	String	PKFK

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	PKFK

emergency_location_owner

Column	Type	Keys
`emergency_location_id`	String	PKFK
`id`	String	PKFK

forwarding_number

Column	Type	Keys
`id`	String	PK
`extension_id`	String	PKFK
`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	PKFK
`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	PKFK
`sms_batch_id`	String	PKFK

meeting_assistant

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

sms_opt_out_number

Column	Type	Keys
`account_id`	String	PKFK
`creation_time`	String
`from`	String
`source`	String
`status`	String
`to`	String

user_video_configuration

Column	Type	Keys
`extension_id`	String	PKFK
`provider`	String
`user_license_type`	String

user_feature_param

Column	Type	Keys
`name`	String	PK
`user_feature_id`	String	PKFK
`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	PKFK

company_directory_custom_field

Column	Type	Keys
`id`	String	PK
`company_directory_id`	String	PKFK
`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	PKFK
`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	PKFK

meeting_setting

Column	Type	Keys
`account_id`	String	PKFK
`telephony_third_party_audio`	Boolean
`recording_`
`schedule_meeting_`

account_signup_state

Column	Type	Keys
`value`	String	PK
`account_id`	String	PKFK

voicemail_notification_advanced_sms_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

user_call_log_leg

Column	Type	Keys
`leg_type`	String	PK
`extension_id`	String	PKFK
`user_call_log_id`	String	PKFK
`master`	Boolean

user_conference_setting_dial_in_phone_number

Column	Type	Keys
`phone_number`	String	PK
`extension_id`	String	PKFK
`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	PKFK

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	PKFK
`external_user_info`

caller_blocking_setting_greeting

Column	Type	Keys
`preset_id`	String	PK
`extension_id`	String	PKFK
`preset_name`	String
`type`	String

user_auth_profile

Column	Type	Keys
`extension_id`	String	PKFK
`effective_role_id`	String
`permission_`

account_business_address

Column	Type	Keys
`account_id`	String	PKFK
`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	PKFK

inbound_fax_notification_advanced_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

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	PKFK

post_mention

Column	Type	Keys
`id`	String	PKFK
`post_id`	String	PKFK
`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	PKFK
`from`	String
`to`	String

inbound_text_notification_advanced_sms_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

outbound_fax_notification_advanced_email

Column	Type	Keys
`email_address`	String	PK
`extension_id`	String	PKFK

sms_to

Column	Type	Keys
`value`	String	PK
`sms_id`	Long	PKFK

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	PKFK
`from`	String
`to`	String

post_attachment

Column	Type	Keys
`id`	String	PK
`post_id`	String	PKFK
`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	PKFK
`assignable`	Boolean
`read_only`	Boolean
`site_compatible`	String

service_provider_config_authentication_scheme

Column	Type	Keys
`name`	String	PK
`service_provider_config_id`	String	PKFK
`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	PKFK
`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	PKFK
`id`	String	PKFK
`status`	String

company_directory_phone_number

Column	Type	Keys
`phone_number`	String	PK
`company_directory_id`	String	PKFK
`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