# Mailgun schema ERD

Table and field reference for the Fivetran Mailgun connector.

## Table & Field Reference

### route_action

| Column | Type | Keys |
| --- | --- | --- |
| action | Unknown | PK |
| route_id | Unknown | PK, FK |

### 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 | PK, FK |
| tags | Unknown |  |

### rejected_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| tags | Unknown |  |

### delivered_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| tags | Unknown |  |

### complained_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| tags | Unknown |  |

### failed_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| error | Unknown |  |

### accepted_event_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| tags | Unknown |  |

### accepted_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| content_type | Unknown |  |
| filename | Unknown |  |
| size | Unknown |  |

### accepted_event_message_recipient

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| recipient | Unknown |  |

### accepted_event_route

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| sender | Unknown |  |
| subject | Unknown |  |

### seed_list_sending_domain

| Column | Type | Keys |
| --- | --- | --- |
| domain_id | Unknown | PK, FK |
| seed_list_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| tags | Unknown |  |

### stored_event_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| content_type | Unknown |  |
| filename | Unknown |  |
| size | Unknown |  |

### stored_event_message_recipient

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- route_action(route_id) → route(id)
- receiving_dns_record(domain_id) → domain(id)
- sending_dns_record(domain_id) → domain(id)
- rejected_event_tag(event_id) → rejected_event(id)
- rejected_event_message_attachment(event_id) → rejected_event(id)
- rejected_event(domain_id) → domain(id)
- delivered_event_tag(event_id) → delivered_event(id)
- delivered_event_message_attachment(event_id) → delivered_event(id)
- delivered_event(domain_id) → domain(id)
- complained_event_tag(event_id) → complained_event(id)
- complained_event_message_attachment(event_id) → complained_event(id)
- complained_event(domain_id) → domain(id)
- template(domain_id) → domain(id)
- whitelist(domain_id) → domain(id)
- failed_event_tag(event_id) → failed_event(id)
- failed_event_message_attachment(event_id) → failed_event(id)
- failed_event(domain_id) → domain(id)
- bounce(domain_id) → domain(id)
- accepted_event_tag(event_id) → accepted_event(id)
- accepted_event_message_attachment(event_id) → accepted_event(id)
- accepted_event_message_recipient(event_id) → accepted_event(id)
- accepted_event_route(event_id) → accepted_event(id)
- accepted_event(domain_id) → domain(id)
- clicked_event_tag(event_id) → clicked_event(id)
- clicked_event(domain_id) → domain(id)
- unsubsrcibed_event_tag(event_id) → unsubsrcibed_event(id)
- unsubsrcibed_event(domain_id) → domain(id)
- seed_list_result(seed_list_id) → seed_list(id)
- seed_list_sending_domain(domain_id) → domain(id)
- seed_list_sending_domain(seed_list_id) → seed_list(id)
- complaint(domain_id) → domain(id)
- opened_event_tag(event_id) → opened_event(id)
- opened_event(domain_id) → domain(id)
- stored_event_tag(event_id) → stored_event(id)
- stored_event_message_attachment(event_id) → stored_event(id)
- stored_event_message_recipient(event_id) → stored_event(id)
- stored_event(domain_id) → domain(id)