Fivetran documentation

Search the docs

/

Mailjet

Explore the interactive ERD

Table & Field Reference

contact

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Instant
`delivered_count`	Unknown
`email`	Unknown
`exclusion_from_campaigns_updated_at`	Unknown
`is_excluded_from_campaigns`	Unknown
`is_opt_in_pending`	Unknown
`is_spam_complaining`	Unknown
`last_activity_at`	Unknown
`last_update_at`	Unknown
`name`	Unknown

campaign_overview

Column	Type	Keys
`id`	Unknown	PK
`clicked_count`	Unknown
`delivered_count`	Unknown
`edit_mode`	Unknown
`edit_type`	Unknown
`id_type`	Unknown
`opened_count`	Unknown
`processed_count`	Unknown
`send_time_start`	Unknown
`starred`	Unknown
`status`	Unknown
`subject`	Unknown
`title`	Unknown

campaign_draft

Column	Type	Keys
`id`	Unknown	PK
`contact_list_id`	Unknown	FK
`a_x_fraction`	Unknown
`a_x_fraction_name`	Unknown
`created_at`	Unknown
`current`	Unknown
`delivered_at`	Unknown
`edit_mode`	Unknown
`is_starred`	Unknown
`is_text_part_included`	Unknown
`locale`	Unknown
`modified_at`	Unknown
`preset`	Unknown
`reply_email`	Unknown
`sender`	Unknown
`sender_email`	Unknown
`sender_name`	Unknown
`status`	Unknown
`subject`	Unknown
`title`	Unknown
`url`	Unknown
`used`	Unknown

bounce_event

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`contact_id`	Unknown	FK
`bounced_at`	Unknown
`is_blocked`	Unknown
`is_state_permanent`	Unknown
`state_id`	Unknown

campaign_click_statistics

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`clicked_events_count`	Unknown
`clicked_messages_count`	Unknown
`position_index`	Unknown
`url`	Unknown

campaign_open_information

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`contact_id`	Unknown	FK
`message_id`	Unknown	FK
`arrived_at`	Unknown
`id`	Unknown
`opened_at`	Unknown
`user_agent_full`	Unknown
`user_agent_id`	Unknown

contact_list

Column	Type	Keys
`id`	Unknown	PK
`address`	Unknown
`created_at`	Instant
`is_deleted`	Unknown
`name`	Unknown
`subscriber_count`	Unknown

contact_filter

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`expression`	Unknown
`name`	Unknown
`status`	Unknown

template_category

Column	Type	Keys
`index`	Unknown	PK
`template_id`	Unknown	PKFK
`category`	Unknown

template_preview

Column	Type	Keys
`index`	Unknown	PK
`template_id`	Unknown	PKFK
`preview`	Unknown

template_purpose

Column	Type	Keys
`index`	Unknown	PK
`template_id`	Unknown	PKFK
`purpose`	Unknown

template_locale_list

Column	Type	Keys
`index`	Unknown	PK
`template_id`	Unknown	PKFK
`localelist`	Unknown

template

Column	Type	Keys
`id`	Unknown	PK
`author`	Unknown
`copyright`	Unknown
`created_at`	Instant
`description`	Unknown
`edit_mode`	Unknown
`is_starred`	Unknown
`is_text_part_generation_enabled`	Unknown
`last_updated_at`	Unknown
`locale`	Unknown
`name`	Unknown
`owner_id`	Unknown
`owner_type`	Unknown
`presets`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`contact_list_id`	Unknown	FK
`first_message_id`	Unknown	FK
`campaign_type`	Unknown
`click_tracked`	Unknown
`created_at`	Unknown
`custom_value`	Unknown
`from_email`	Unknown
`from_id`	Unknown
`from_name`	Unknown
`has_html_count`	Unknown
`has_txt_count`	Unknown
`is_deleted`	Unknown
`is_starred`	Unknown
`news_letter_id`	Unknown
`open_tracked`	Unknown
`send_end_at`	Unknown
`send_start_at`	Unknown
`spamass_score`	Unknown
`status`	Unknown
`subject`	Unknown
`unsubscribe_tracked_count`	Unknown
`workflow_id`	Unknown

message

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`arrived_at`	Unknown
`attachment_count`	Unknown
`attempt_count`	Unknown
`contact_alt`	Unknown
`delay`	Unknown
`destination_id`	Unknown
`filter_time`	Unknown
`is_click_tracked`	Unknown
`is_html_part_included`	Unknown
`is_open_tracked`	Unknown
`is_text_part_included`	Unknown
`is_unsub_tracked`	Unknown
`message_size`	Unknown
`sender_id`	Unknown
`spam_assassin_score`	Unknown
`spamass_rule`	Unknown
`state_permanent`	Unknown
`status`	Unknown
`subject`	Unknown
`uuid`	Unknown

contact_list_signup

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`contact_list_id`	Unknown	FK
`confirm_at`	Unknown
`confirm_ip`	Unknown
`consent_id`	Unknown
`email`	Unknown
`property`	Unknown
`signup_at`	Unknown
`signup_ip`	Unknown
`signup_key`	Unknown
`source`	Unknown
`source_id`	Unknown
`validation_response`	Unknown

click_stat

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`message_id`	Unknown	FK
`clicked_at`	Unknown
`clicked_delay`	Unknown
`url`	Unknown
`user_agent_id`	Unknown

geo_statistics

Column	Type	Keys
`_fivetran_id`	String	PK
`clicked_count`	Unknown
`country`	Unknown
`opened_count`	Unknown

message_information

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`contact_id`	Unknown	FK
`click_tracked_count`	Unknown
`created_at`	Unknown
`message_size`	Unknown
`open_tracked_count`	Unknown
`queued_count`	Unknown
`send_end_at`	Unknown
`sent_count`	Unknown
`spam_assassin_rule_alt`	Unknown
`spam_assassin_rule_id`	Unknown
`spam_assassin_score`	Unknown

toplink_clicked

Column	Type	Keys
`_fivetran_id`	String	PK
`clicked_count`	Unknown
`link_id`	Unknown
`url`	Unknown

message_history

Column	Type	Keys
`_fivetran_id`	String	PK
`message_id`	Unknown	PKFK
`comment`	Unknown
`event_at`	Unknown
`event_type`	Unknown
`state`	Unknown
`user_agent`	Unknown
`user_agent_id`	Unknown