# Mailjet schema ERD

Table and field reference for the Fivetran Mailjet connector.

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

### template_preview

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| template_id | Unknown | PK, FK |
| preview | Unknown |  |

### template_purpose

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| template_id | Unknown | PK, FK |
| purpose | Unknown |  |

### template_locale_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| template_id | Unknown | PK, FK |
| 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 | PK, FK |
| comment | Unknown |  |
| event_at | Unknown |  |
| event_type | Unknown |  |
| state | Unknown |  |
| user_agent | Unknown |  |
| user_agent_id | Unknown |  |

## Relationships

- campaign_draft(contact_list_id) → contact_list(id)
- bounce_event(campaign_id) → campaign(id)
- bounce_event(contact_id) → contact(id)
- campaign_click_statistics(campaign_id) → campaign(id)
- campaign_open_information(campaign_id) → campaign(id)
- campaign_open_information(contact_id) → contact(id)
- campaign_open_information(message_id) → message(id)
- template_category(template_id) → template(id)
- template_preview(template_id) → template(id)
- template_purpose(template_id) → template(id)
- template_locale_list(template_id) → template(id)
- campaign(contact_list_id) → contact_list(id)
- campaign(first_message_id) → message(id)
- message(contact_id) → contact(id)
- contact_list_signup(contact_list_id) → contact_list(id)
- contact_list_signup(contact_id) → contact(id)
- click_stat(contact_id) → contact(id)
- click_stat(message_id) → message(id)
- message_information(campaign_id) → campaign(id)
- message_information(contact_id) → contact(id)
- message_history(message_id) → message(id)