Fivetran documentation

Search the docs

/

Maileon

Explore the interactive ERD

Table & Field Reference

contact_preference

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`category`	Unknown
`last_modified`	Unknown
`name`	Unknown
`source`	Unknown
`value`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`anonymous`	Unknown
`created`	Unknown
`custom_fields`	Json
`email`	Unknown
`external_id`	Unknown
`permission`	Unknown
`standard_fields`	Json
`updated`	Unknown

target_group

Column	Type	Keys
`id`	Unknown	PK
`author`	Unknown
`contact_filter_id`	Unknown
`contact_filter_name`	Unknown
`count_active_contacts`	Unknown
`count_contacts`	Unknown
`created`	Unknown
`evaluated`	Unknown
`name`	Unknown
`state`	Unknown
`type`	Unknown
`updated`	Unknown

mailing_list

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`schedule_time`	Unknown
`state`	Unknown
`type`	Unknown
`custom_`

recipient

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown

conversion

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`goal_id`	Unknown
`goal_name`	Unknown
`link_id`	Unknown
`link_url`	Unknown
`mailing_name`	Unknown
`mailing_sent_date`	Unknown
`mailing_sent_date_sql`	Unknown
`site_id`	Unknown
`site_name`	Unknown
`time_stamp`	Unknown
`timestamp_sql`	Unknown
`value`	Unknown

bounce

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`msg_id`	Unknown
`source`	Unknown
`status_code`	Unknown
`time_stamp`	Unknown
`type`	Unknown

unsubscription

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`msg_id`	Unknown
`source`	Unknown
`time_stamp`	Unknown

unique_opens

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`client_browser`	Unknown
`client_browser_group`	Unknown
`client_browser_type`	Unknown
`client_os_group`	Unknown
`client_os_name`	Unknown
`client_rendering_engine`	Unknown
`client_user_agent`	Unknown
`contact_anonymous`	Unknown
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`device_type`	Unknown
`format`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown

opens

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`client_browser`	Unknown
`client_browser_group`	Unknown
`client_browser_type`	Unknown
`client_os_group`	Unknown
`client_os_name`	Unknown
`client_rendering_engine`	Unknown
`client_user_agent`	Unknown
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`device_type`	Unknown
`format`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown

click

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`client_browser`	Unknown
`client_browser_group`	Unknown
`client_browser_type`	Unknown
`client_os_group`	Unknown
`client_os_name`	Unknown
`client_rendering_engine`	Unknown
`client_user_agent`	Unknown
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`device_type`	Unknown
`format`	Unknown
`link_id`	Unknown
`link_tag`	Json
`link_type`	Unknown
`link_url`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown

subscriber

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`ip`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown

unique_click

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	Unknown	FK
`mailing_id`	Unknown	FK
`client_browser`	Unknown
`client_browser_group`	Unknown
`client_browser_type`	Unknown
`client_os_group`	Unknown
`client_os_name`	Unknown
`client_rendering_engine`	Unknown
`client_user_agent`	Unknown
`contact_permission_status`	Unknown
`contact_permission_type`	Unknown
`device_type`	Unknown
`format`	Unknown
`link_id`	Unknown
`link_tag`	Json
`link_type`	Unknown
`link_url`	Unknown
`msg_id`	Unknown
`time_stamp`	Unknown