Fivetran documentation

Search the docs

/

Missive

Explore the interactive ERD

Table & Field Reference

contact_info

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`custom_label`	Unknown
`kind`	Unknown
`label`	Unknown
`value`	Unknown

contact_membership

Column	Type	Keys
`contact_id`	Unknown	PKFK
`id`	Unknown	PKFK
`kind`	Unknown
`name`	Unknown
`title`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`contact_book_id`	Unknown	FK
`deleted`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`modified_at`	Unknown
`starred`	Unknown

shared_label

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`color`	Unknown
`name`	Unknown
`name_with_parent_names`	Unknown
`parent`	Unknown
`share_with_organization`	Unknown
`share_with_team`	Unknown
`share_with_users`	Unknown
`visibility`	Unknown

conversation_message_in_reply_to

Column	Type	Keys
`index`	Unknown	PK
`conversation_message_id`	Unknown	PKFK
`in_reply_to`	Unknown

conversation_message_reference

Column	Type	Keys
`index`	Unknown	PK
`conversation_message_id`	Unknown	PKFK
`reference`	Unknown

conversation_message_to_field

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_message_id`	Unknown	FK
`address`	Unknown
`name`	Unknown

conversation_message_attachment

Column	Type	Keys
`id`	Unknown	PK
`conversation_message_id`	Unknown	PKFK
`extension`	Unknown
`filename`	Unknown
`height`	Unknown
`media_type`	Unknown
`size`	Unknown
`sub_type`	Unknown
`url`	Unknown
`width`	Unknown

conversation_message

Column	Type	Keys
`id`	Unknown	PK
`author`	Unknown
`bcc_field`	Json
`cc_field`	Json
`created_at`	Unknown
`delivered_at`	Unknown
`email_message_id`	Unknown
`from_field_address`	Unknown
`from_field_name`	Unknown
`preview`	Unknown
`reply_to_field`	Json
`subject`	Unknown
`type`	Unknown
`updated_at`	Unknown

contact_group_organization

Column	Type	Keys
`id`	Unknown	PK
`temp_contact_book_id`	Unknown	PK
`kind`	String
`name`	Unknown

contact_book

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`share_with_team`	Unknown	FK
`user_id`	Unknown	FK
`description`	Unknown
`email_account_id`	Unknown
`exclude_from_search`	Unknown
`import_error_text`	Unknown
`import_processed_rows_count`	Unknown
`import_rows_count`	Unknown
`importing`	Unknown
`name`	Unknown
`share_with_organization`	Unknown
`share_with_users`	Json

organization

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

team

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`name`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`avatar_url`	Unknown
`email`	Unknown
`me`	Unknown
`name`	Unknown

conversation_author

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`address`	Unknown
`name`	Unknown

conversation_external_author

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`address`	Unknown
`name`	Unknown

conversation_user

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`archived`	Unknown
`assigned`	Unknown
`closed`	Unknown
`email`	Unknown
`flagged`	Unknown
`junked`	Unknown
`name`	Unknown
`snoozed`	Unknown
`trashed`	Unknown
`unassigned`	Unknown

conversation_assignee

Column	Type	Keys
`id`	Unknown	PK
`conversation_id`	Unknown	PKFK
`archived`	Unknown
`assigned`	Unknown
`closed`	Unknown
`email`	Unknown
`flagged`	Unknown
`junked`	Unknown
`name`	Unknown
`snoozed`	Unknown
`trashed`	Unknown
`unassigned`	Unknown

conversation

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`team_id`	Unknown	FK
`app_url`	Unknown
`assignee_emails`	Unknown
`assignee_names`	Unknown
`attachments_count`	Unknown
`color`	Unknown
`completed_tasks_count`	Unknown
`drafts_count`	Unknown
`last_activity_at`	Unknown
`latest_message_subject`	Unknown
`messages_count`	Unknown
`send_later_messages_count`	Unknown
`shared_label_names`	Unknown
`shared_labels`	Json
`subject`	Unknown
`tasks_count`	Unknown
`web_url`	Unknown