Mailgun

Explore the interactive ERD

Table & Field Reference

route_action

Column	Type	Keys
`action`	Unknown	PK
`route_id`	Unknown	PKFK

route

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`expression`	Unknown
`priority`	Unknown

receiving_dns_record

Column	Type	Keys
`_fivetran_id`	String	PK
`domain_id`	Unknown	FK
`cached`	Unknown
`priority`	Unknown
`record_type`	Unknown
`valid`	Unknown
`value`	Unknown

sending_dns_record

Column	Type	Keys
`_fivetran_id`	String	PK
`domain_id`	Unknown	FK
`cached`	Unknown
`name`	Unknown
`record_type`	Unknown
`valid`	Unknown
`value`	Unknown

domain

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_disabled`	Unknown
`name`	Unknown
`require_tls`	Unknown
`skip_verification`	Unknown
`smtp_login`	Unknown
`spam_action`	Unknown
`state`	Unknown
`type`	Unknown
`web_prefix`	Unknown
`web_scheme`	Unknown
`wildcard`	Unknown

blocklist_event

Column	Type	Keys
`_fivetran_id`	String	PK
`blocklist`	Unknown
`event`	Unknown
`ip`	Unknown
`ip_pool`	Unknown
`timestamps`	Unknown

rejected_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

rejected_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

rejected_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`event_type`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`method`	Unknown
`originating_ip`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`reject_description`	Unknown
`reject_reason`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

spam_trap_count

Column	Type	Keys
`ends`	String	PK
`start`	String	PK
`date`	Unknown
`pristine`	Unknown
`recycled`	Unknown
`total`	Unknown
`typo`	Unknown

delivered_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

delivered_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

delivered_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`delivery_status_attempt_no`	Unknown
`delivery_status_certificate_verified`	Unknown
`delivery_status_code`	Unknown
`delivery_status_description`	Unknown
`delivery_status_enhanced_code`	Unknown
`delivery_status_message`	Unknown
`delivery_status_mx_host`	Unknown
`delivery_status_session_seconds`	Unknown
`delivery_status_tls`	Unknown
`delivery_status_utf_8`	Unknown
`envelope_sender`	Unknown
`envelope_sending_ip`	Unknown
`envelope_targets`	Unknown
`envelope_transport`	Unknown
`event_type`	Unknown
`flags_is_authenticated`	Unknown
`flags_is_routed`	Unknown
`flags_is_system_test`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`method`	Unknown
`originating_ip`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`storage_env`	Unknown
`storage_key`	Unknown
`storage_region`	Unknown
`storage_url`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

complained_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

complained_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

complained_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`event_type`	Unknown
`flags_is_authenticated`	Unknown
`flags_is_routed`	Unknown
`flags_is_system_test`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

mailing_list

Column	Type	Keys
`email`	Unknown	PK
`access_level`	Unknown
`created_at`	Unknown
`description`	Unknown
`members_count`	Unknown
`name`	Unknown
`reply_preference`	Unknown

template

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`created_at`	Unknown
`created_by`	Unknown
`description`	Unknown
`name`	Unknown

inbox_ready_domain

Column	Type	Keys
`_fivetran_id`	String	PK
`created_at`	Unknown
`id`	Unknown
`name`	Unknown
`spam_trap_monitoring`	Unknown
`status`	Unknown
`txt_record`	Unknown
`verified_at`	Unknown

whitelist

Column	Type	Keys
`_fivetran_id`	String	PK
`domain_id`	Unknown	FK
`created_at`	Unknown
`reason`	Unknown
`type`	Unknown
`value`	Unknown

failed_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

failed_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

failed_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`delivery_status_attempt_no`	Unknown
`delivery_status_certificate_verified`	Unknown
`delivery_status_code`	Unknown
`delivery_status_description`	Unknown
`delivery_status_enhanced_code`	Unknown
`delivery_status_message`	Unknown
`delivery_status_mx_host`	Unknown
`delivery_status_session_seconds`	Unknown
`delivery_status_tls`	Unknown
`delivery_status_utf_8`	Unknown
`envelope_sender`	Unknown
`envelope_sending_ip`	Unknown
`envelope_targets`	Unknown
`envelope_transport`	Unknown
`event_type`	Unknown
`flags_is_authenticated`	Unknown
`flags_is_routed`	Unknown
`flags_is_system_test`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`method`	Unknown
`originating_ip`	Unknown
`reason`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`severity`	Unknown
`storage_env`	Unknown
`storage_key`	Unknown
`storage_region`	Unknown
`storage_url`	Unknown
`template_name`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

bounce

Column	Type	Keys
`email`	Unknown	PK
`domain_id`	Unknown	PKFK
`code`	Unknown
`created_at`	Unknown
`error`	Unknown

accepted_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

accepted_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

accepted_event_message_recipient

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`recipient`	Unknown

accepted_event_route

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`expression`	Unknown
`match_recipient`	Unknown

accepted_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`envelope_sender`	Unknown
`envelope_targets`	Unknown
`envelope_transport`	Unknown
`event_type`	Unknown
`flags_is_authenticated`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`method`	Unknown
`originating_ip`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`storage_env`	Unknown
`storage_key`	Unknown
`storage_region`	Unknown
`storage_url`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

clicked_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

clicked_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`client_info_client_name`	Unknown
`client_info_client_os`	Unknown
`client_info_client_type`	Unknown
`client_info_device_type`	Unknown
`client_info_user_agent`	Unknown
`event_type`	Unknown
`geolocation_city`	Unknown
`geolocation_country`	Unknown
`geolocation_region`	Unknown
`geolocation_sending_ip`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`timestamps`	Unknown
`url`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

unsubsrcibed_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

unsubsrcibed_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`client_info_client_name`	Unknown
`client_info_client_os`	Unknown
`client_info_client_type`	Unknown
`client_info_device_type`	Unknown
`client_info_user_agent`	Unknown
`event_type`	Unknown
`geolocation_city`	Unknown
`geolocation_country`	Unknown
`geolocation_region`	Unknown
`geolocation_sending_ip`	Unknown
`ip`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

seed_list_result

Column	Type	Keys
`result_id`	Unknown	PK
`seed_list_id`	Unknown	PKFK
`sender`	Unknown
`subject`	Unknown

seed_list_sending_domain

Column	Type	Keys
`domain_id`	Unknown	PKFK
`seed_list_id`	Unknown	PKFK

seed_list

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`delivery_stats_all_delivered`	Unknown
`delivery_stats_all_inbox`	Unknown
`delivery_stats_all_missing`	Unknown
`delivery_stats_all_pending`	Unknown
`delivery_stats_all_provider`	Unknown
`delivery_stats_all_spam`	Unknown
`delivery_stats_all_total`	Unknown
`delivery_stats_gmail_com_delivered`	Unknown
`delivery_stats_gmail_com_inbox`	Unknown
`delivery_stats_gmail_com_missing`	Unknown
`delivery_stats_gmail_com_pending`	Unknown
`delivery_stats_gmail_com_provider`	Unknown
`delivery_stats_gmail_com_spam`	Unknown
`delivery_stats_gmail_com_total`	Unknown
`delivery_stats_yahoo_com_delivered`	Unknown
`delivery_stats_yahoo_com_inbox`	Unknown
`delivery_stats_yahoo_com_missing`	Unknown
`delivery_stats_yahoo_com_pending`	Unknown
`delivery_stats_yahoo_com_provider`	Unknown
`delivery_stats_yahoo_com_spam`	Unknown
`delivery_stats_yahoo_com_total`	Unknown
`has_result`	Unknown
`is_auto_generated`	Unknown
`last_result_at`	Unknown
`mailing_list`	Unknown
`name`	Unknown
`seed_filter`	Unknown
`tags`	Json
`target_email`	Unknown
`updated_at`	Unknown

complaint

Column	Type	Keys
`_fivetran_id`	String	PK
`domain_id`	Unknown	FK
`created_at`	Unknown
`email`	Unknown

opened_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

opened_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`client_info_bot`	Unknown
`client_info_client_name`	Unknown
`client_info_client_os`	Unknown
`client_info_client_type`	Unknown
`client_info_device_type`	Unknown
`client_info_user_agent`	Unknown
`event_type`	Unknown
`geolocation_city`	Unknown
`geolocation_country`	Unknown
`geolocation_region`	Unknown
`geolocation_sending_ip`	Unknown
`ip`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown

stored_event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

stored_event_message_attachment

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`content_type`	Unknown
`filename`	Unknown
`size`	Unknown

stored_event_message_recipient

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`recipient`	Unknown

stored_event

Column	Type	Keys
`id`	Unknown	PK
`domain_id`	Unknown	FK
`campaigns`	Json
`delivery_status_attempt_no`	Unknown
`delivery_status_certificate_verified`	Unknown
`delivery_status_code`	Unknown
`delivery_status_description`	Unknown
`delivery_status_enhanced_code`	Unknown
`delivery_status_message`	Unknown
`delivery_status_mx_host`	Unknown
`delivery_status_session_seconds`	Unknown
`delivery_status_tls`	Unknown
`delivery_status_utf_8`	Unknown
`event_type`	Unknown
`flags_is_authenticated`	Unknown
`flags_is_routed`	Unknown
`flags_is_system_test`	Unknown
`flags_is_test_mode`	Unknown
`log_level`	Unknown
`message_from`	Unknown
`message_message_id`	Unknown
`message_size`	Unknown
`message_subject`	Unknown
`message_to`	Unknown
`recipient`	Unknown
`recipient_domain`	Unknown
`storage_env`	Unknown
`storage_key`	Unknown
`storage_region`	Unknown
`storage_url`	Unknown
`template_name`	Unknown
`timestamps`	Unknown
`user_variables_org_id`	Unknown
`user_variables_silo_id`	Unknown