# Maileon schema ERD

Table and field reference for the Fivetran Maileon connector.

## Table & Field Reference

### contact_preference

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

## Relationships

- contact_preference(contact_id) → contact(id)
- recipient(mailing_id) → mailing_list(id)
- recipient(contact_id) → contact(id)
- conversion(contact_id) → contact(id)
- conversion(mailing_id) → mailing_list(id)
- bounce(mailing_id) → mailing_list(id)
- bounce(contact_id) → contact(id)
- unsubscription(mailing_id) → mailing_list(id)
- unsubscription(contact_id) → contact(id)
- unique_opens(mailing_id) → mailing_list(id)
- unique_opens(contact_id) → contact(id)
- opens(mailing_id) → mailing_list(id)
- opens(contact_id) → contact(id)
- click(mailing_id) → mailing_list(id)
- click(contact_id) → contact(id)
- subscriber(mailing_id) → mailing_list(id)
- subscriber(contact_id) → contact(id)
- unique_click(mailing_id) → mailing_list(id)
- unique_click(contact_id) → contact(id)