Fivetran documentation

Search the docs

/

TextUs

Explore the interactive ERD

Table & Field Reference

account_phone_number

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`phone_number`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`brand_status`	Unknown
`children_count`	Unknown
`contacts_enabled`	Unknown
`family_count`	Unknown
`has_cumulative_plan`	Unknown
`logo`	Unknown
`messaging_restricted`	Unknown
`multi_user`	Unknown
`name`	Unknown
`office_hour`	Json
`shortened_link_domain`	Unknown
`tcr_campaign`	Json
`type`	Unknown

user_by_organization

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`account_created`	Unknown
`account_name`	Unknown
`end_date`	Unknown
`organization_name`	Unknown
`parent_account_name`	Unknown
`start_date`	Unknown
`user_created`	Unknown
`user_name`	Unknown
`user_role`	Unknown
`custom_`

message_deliverability

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`account_name`	Unknown
`active_user`	Unknown
`delivered_messages`	Unknown
`delivered_rate`	Unknown
`end_date`	Unknown
`failed_messages`	Unknown
`failed_rate`	Unknown
`organization_name`	Unknown
`parent_account_name`	Unknown
`received_messages`	Unknown
`sent_and_received_ratio`	Unknown
`sent_messages`	Unknown
`start_date`	Unknown
`user_name`	Unknown
`custom_`

user_engagement

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`account_name`	Unknown
`active_conversations`	Unknown
`active_conversations_response_rate`	Unknown
`active_conversations_with_responses`	Unknown
`customer_initiated_conversations`	Unknown
`end_date`	Unknown
`messages_per_conversation`	Unknown
`organization_name`	Unknown
`parent_account_name`	Unknown
`start_date`	Unknown
`total_response_rate`	Unknown
`user_name`	Unknown
`custom_`