Twilio

Explore the interactive ERD

Table & Field Reference

role_permission

Column	Type	Keys
`permission`	String	PK
`role_id`	String	PKFK

outgoing_caller_id

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`friendly_name`	String
`phone_number`	String
`updated_at`	Instant

messaging_service

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`area_code_geomatch`	Boolean
`created_at`	Instant
`fallback_method`	String
`fallback_to_long_code`	Boolean
`fallback_url`	String
`friendly_name`	String
`inbound_method`	String
`inbound_request_url`	String
`mms_converter`	Boolean
`scan_message_content`	String
`smart_encoding`	Boolean
`status_callback`	String
`sticky_sender`	Boolean
`synchronous_validation`	Boolean
`updated_at`	Instant
`us_app_to_person_registered`	Boolean
`use_inbound_webhook_on_number`	Boolean
`usecase`	String
`validity_period`	Int

flow_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`account_id`	String	FK
`created_at`	Instant
`friendly_name`	String
`status`	String
`version`	Long

account_history

Column	Type	Keys
`id`	String	PK
`updated_at`	Instant	PK
`owner_account_id`	String	FK
`created_at`	Instant
`friendly_name`	String
`status`	String
`type`	String

conversation_message_media

Column	Type	Keys
`id`	String	PK
`message_id`	String	PKFK
`content_type`	String
`filename`	String
`size`	Long

participant

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`chat_service_id`	String	FK
`conversation_id`	String	FK
`role_id`	String	FK
`attributes`	String
`created_at`	Instant
`last_read_message_index`	Int
`last_read_timestamp`	Instant
`participant_identity`	String
`updated_at`	Instant

recording

Column	Type	Keys
`id`	String	PK
`call_id`	String	FK
`conference_id`	String	FK
`api_version`	String
`channels`	Int
`created_at`	Instant
`duration`	String
`error_code`	Int
`price`	String
`price_unit`	String
`source`	String
`start_time`	Instant
`status`	String
`updated_at`	Instant

trunk

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`auth_type`	String
`auth_type_set`	Json
`cnam_lookup_enabled`	Boolean
`created_at`	Instant
`domain_name`	String
`friendly_name`	String
`recording`	Json
`secure`	Boolean
`updated_at`	Instant

verification_attempt

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`service_id`	String	FK
`channel`	String
`conversion_status`	String
`created_at`	Instant
`price_currency`	String
`price_value`	BigDecimal
`updated_at`	Instant
`verification_id`	String
`channel_`

execution

Column	Type	Keys
`id`	String	PK
`flow_id`	String	FK
`contact_channel_address`	String
`context`	Json
`created_at`	Instant
`status`	String
`updated_at`	Instant

execution_step

Column	Type	Keys
`id`	String	PK
`execution_id`	String	FK
`context`	Json
`created_at`	Instant
`name`	String
`transitioned_from`	String
`transitioned_to`	String
`updated_at`	Instant

service

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`created_at`	Instant
`friendly_name`	String
`updated_at`	Instant

usage_record

Column	Type	Keys
`category`	String	PK
`end_date`	LocalDate	PK
`start_date`	LocalDate	PK
`account_id`	String	PKFK
`as_of`	Instant
`count`	String
`count_unit`	String
`description`	String
`price`	String
`price_unit`	String
`usage`	String
`usage_unit`	String

message

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`messaging_service_sid`	String	FK
`body`	String
`created_at`	Instant
`date_sent`	Instant
`direction`	String
`error_code`	String
`error_message`	String
`from`	String
`num_media`	String
`num_segments`	String
`price`	String
`price_unit`	String
`status`	String
`to`	String
`updated_at`	Instant

conference_participant_extended

Column	Type	Keys
`id`	String	PK
`call_id`	String	FK
`conference_id`	String	FK
`call_type`	String
`end_conference_on_exit`	Boolean
`is_coach`	Boolean
`is_moderator`	Boolean
`label`	String
`participant_region`	String
`start_conference_on_enter`	Boolean

incoming_phone_number

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`address_id`	String	FK
`emergency_address_id`	String	FK
`trunk_id`	String	FK
`address_requirements`	String
`beta`	Boolean
`capabilities_mms`	Boolean
`capabilities_sms`	Boolean
`capabilities_voice`	Boolean
`created_at`	Instant
`emergency_status`	String
`friendly_name`	String
`origin`	String
`phone_number`	String
`updated_at`	Instant
`voice_caller_id_lookup`	Boolean
`voice_url`	String

conversation_user

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`chat_service_id`	String	FK
`role_id`	String	FK
`attributes`	String
`created_at`	Instant
`friendly_name`	String
`is_notifiable`	Boolean
`is_online`	Boolean
`updated_at`	Instant
`url`	String
`user_identity`	String

role

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`chat_service_id`	String	FK
`created_at`	Instant
`friendly_name`	String
`type`	String
`updated_at`	Instant

coached_call

Column	Type	Keys
`call_id`	String	PKFK
`coach_id`	String	PKFK

call

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`outgoing_caller_id`	String	FK
`parent_call_id`	String	FK
`trunk_id`	String	FK
`annotation`	String
`answered_by`	String
`caller_name`	String
`created_at`	Instant
`direction`	String
`duration`	String
`end_time`	Instant
`forwarded_from`	String
`from`	String
`from_formatted`	String
`group_id`	String
`price`	String
`price_unit`	String
`queue_time`	String
`start_time`	Instant
`status`	String
`to`	String
`to_formatted`	String
`updated_at`	Instant

receipt

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`conversation_id`	String	FK
`message_id`	String	FK
`participant_id`	String	FK
`service_id`	String	FK
`channel_message_id`	String
`created_at`	Instant
`error_code`	Int
`status`	String
`updated_at`	Instant

conference_participant

Column	Type	Keys
`call_id`	String	PKFK
`conference_id`	String	PKFK
`call_id_to_coach`	String	FK
`coaching`	Boolean
`created_at`	Instant
`end_conference_on_exit`	Boolean
`hold`	Boolean
`muted`	Boolean
`start_conference_on_enter`	Boolean
`status`	String
`updated_at`	Instant

verification_service

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`code_length`	Int
`created_at`	Instant
`custom_code_enabled`	Boolean
`default_template_sid`	String
`do_not_share_warning_enabled`	Boolean
`dtmf_input_required`	Boolean
`friendly_name`	String
`lookup_enabled`	Boolean
`mailer_sid`	String
`psd_2_enabled`	Boolean
`push_apn_credential_sid`	String
`push_fcm_credential_sid`	String
`push_include_date`	Boolean
`skip_sms_to_landlines`	Boolean
`tts_name`	String
`updated_at`	Instant
`verify_event_subscription_enabled`	Boolean
`totp_`

conference

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`friendly_name`	String
`region`	String
`status`	String
`updated_at`	Instant

address

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`city`	String
`created_at`	Instant
`customer_name`	String
`emergency_enabled`	Boolean
`friendly_name`	String
`iso_country`	String
`postal_code`	String
`region`	String
`street`	String
`updated_at`	Instant
`validated`	Boolean
`verified`	Boolean

conversation

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`chat_service_id`	String	FK
`attributes`	String
`created_at`	Instant
`friendly_name`	String
`messaging_service_id`	String
`state`	String
`timer_date_closed`	Instant
`timer_date_inactive`	Instant
`unique_name`	String
`updated_at`	Instant
`url`	String

conversation_message

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`conversation_id`	String	FK
`participant_id`	String	FK
`service_id`	String	FK
`attributes`	String
`author`	String
`body`	String
`created_at`	Instant
`delivery_delivered`	String
`delivery_failed`	String
`delivery_read`	String
`delivery_sent`	String
`delivery_total`	Int
`delivery_undelivered`	String
`index`	String
`updated_at`	Instant
`url`	String