Twilio schema and ERD

30 tables

Joins between these tables aren't mapped yet.

Loading diagram…

conference

conversation

flow

message

service

account

sid

string

owner_sid

string

friendly_name

string

status

string

type

string

date_created

date

date_updated

date

_weld_synced

date

address

sid

string

account_sid

string

friendly_name

string

customer_name

string

street

string

city

string

region

string

postal_code

string

call

sid

string

parent_call_sid

string

account_sid

string

from

string

phone_number_sid

string

status

string

start_time

date

conference

sid

string

account_sid

string

friendly_name

string

status

string

region

string

reason_conference_ended

string

date_created

date

date_updated

date

_weld_synced

date

conference_participant

participant_sid

string

conference_sid

string

label

string

call_sid

string

account_sid

string

call_direction

string

from

string

conference_participant_extended_coached_participant

participant_sid

string

coached_participant_sid

string

index

int

_weld_synced

date

conversation

sid

string

account_sid

string

chat_service_sid

string

messaging_service_sid

string

friendly_name

string

unique_name

string

state

string

attributes

string

conversation_message

sid

string

conversation_sid

string

account_sid

string

author

string

body

string

index

long

participant_sid

string

date_created

date

date_updated

date

_weld_synced

date

conversation_message_receipt

sid

string

message_sid

string

conversation_sid

string

channel

string

participant_sid

string

status

string

read_timestamp

date

delivered_timestamp

date

_weld_synced

date

conversation_participant

sid

string

conversation_sid

string

account_sid

string

identity

string

role_sid

string

messaging_binding_address

string

date_created

date

date_updated

date

_weld_synced

date

conversation_user

sid

string

account_sid

string

chat_service_sid

string

role_sid

string

identity

string

friendly_name

string

is_online

boolean

is_notifiable

boolean

attributes

string

date_created

date

date_updated

date

_weld_synced

date

flow

sid

string

account_sid

string

author_sid

string

friendly_name

string

status

string

revision

long

commit_message

string

valid

boolean

flow_definition_state

name

string

flow_sid

string

type

string

transitions

string

properties

string

_weld_synced

date

flow_definition_flag

flow_sid

string

key

string

value

string

_weld_synced

date

execution

sid

string

flow_sid

string

account_sid

string

contact_channel_address

string

contact_sid

string

flow_version

string

status

string

date_created

date

date_updated

date

initiated_by

string

_weld_synced

date

execution_context

execution_sid

string

key

string

value

string

_weld_synced

date

execution_step

sid

string

execution_sid

string

flow_sid

string

account_sid

string

parent_step_sid

string

name

string

type

string

status

string

execution_step_context

execution_step_sid

string

key

string

value

string

_weld_synced

date

incoming_phone_number

sid

string

account_sid

string

friendly_name

string

phone_number

string

voice_url

string

sms_url

string

status

string

capabilities_fax

boolean

message

sid

string

account_sid

string

body

string

date_created

date

date_sent

date

date_updated

date

direction

string

error_code

long

message_media

sid

string

message_sid

string

account_sid

string

content_type

string

date_created

date

date_updated

date

_weld_synced

date

messaging_service

sid

string

account_sid

string

friendly_name

string

inbound_request_url

string

fallback_url

string

status_callback

string

use_case

string

date_created

date

date_updated

date

_weld_synced

date

outgoing_caller_id

sid

string

account_sid

string

friendly_name

string

phone_number

string

date_created

date

date_updated

date

_weld_synced

date

recording

sid

string

call_sid

string

conference_sid

string

account_sid

string

duration

long

status

string

channels

long

source

string

service

sid

string

account_sid

string

friendly_name

string

date_created

date

date_updated

date

_weld_synced

date

role

sid

string

chat_service_sid

string

account_sid

string

friendly_name

string

type

string

permissions

string

date_created

date

date_updated

date

_weld_synced

date

trunk

sid

string

account_sid

string

friendly_name

string

domain_name

string

disaster_recovery_url

string

disaster_recovery_method

string

transfer_mode

string

recording

boolean

usage_record