# Postmark schema ERD

Table and field reference for the Fivetran Postmark connector.

## Table & Field Reference

### browser_usage

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| date | Unknown |  |
| from_date | String |  |
| google_chorme | Unknown |  |
| safari | Unknown |  |
| safari_mobile | Unknown |  |
| to_date | String |  |
| custom_** |  |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dkim_host | Unknown |  |
| dkim_pending_host | Unknown |  |
| dkim_pending_text_value | Unknown |  |
| dkim_revoked_host | Unknown |  |
| dkim_revoked_text_value | Unknown |  |
| dkim_text_value | Unknown |  |
| dkim_update_status | Unknown |  |
| dkim_verified | Unknown |  |
| name | Unknown |  |
| return_path_domain | Unknown |  |
| return_path_domain_cname_value | Unknown |  |
| return_path_domain_verified | Unknown |  |
| safe_to_remove_revoked_key_from_dns | Unknown |  |
| spf_host | Unknown |  |
| spf_text_value | Unknown |  |
| weak_dkim | Unknown |  |

### sender_signature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| confirmation_personal_note | Unknown |  |
| confirmed | Unknown |  |
| dkim_host | Unknown |  |
| dkim_pending_host | Unknown |  |
| dkim_pending_text_value | Unknown |  |
| dkim_revoked_host | Unknown |  |
| dkim_revoked_text_value | Unknown |  |
| dkim_text_value | Unknown |  |
| dkim_update_status | Unknown |  |
| dkim_verified | Unknown |  |
| domain | Unknown |  |
| email_address | Unknown |  |
| name | Unknown |  |
| reply_to_email_address | Unknown |  |
| return_path_domain | Unknown |  |
| return_path_domain_cname_value | Unknown |  |
| return_path_domain_verified | Unknown |  |
| safe_to_remove_revoked_key_from_dns | Unknown |  |
| spf_host | Unknown |  |
| spf_text_value | Unknown |  |
| weak_dkim | Unknown |  |

### browser_usage_platform

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| date | Unknown |  |
| desktop | Unknown |  |
| from_date | String |  |
| mobile | Unknown |  |
| to_date | String |  |
| unknown | Unknown |  |

### message_inbound_to

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_inbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |

### message_inbound_cc

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_inbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |

### message_inbound_header

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_inbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### message_inbound_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_inbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| content_id | Unknown |  |
| content_length | Unknown |  |
| content_type | Unknown |  |
| name | Unknown |  |

### message_inbound

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| blocked_reason | Unknown |  |
| date | Unknown |  |
| from_email | Unknown |  |
| from_name | Unknown |  |
| html_body | Unknown |  |
| mailbox_hash | Unknown |  |
| original_recipient | Unknown |  |
| reply_to | Unknown |  |
| server_id | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| tags | Unknown |  |
| text_body | Unknown |  |

### server

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bounce_hook_url | Unknown |  |
| click_hook_url | Unknown |  |
| color | Unknown |  |
| delivery_hook_url | Unknown |  |
| delivery_type | Unknown |  |
| enable_smtp_api_error_hook | Unknown |  |
| inbound_address | Unknown |  |
| inbound_domain | Unknown |  |
| inbound_hash | Unknown |  |
| inbound_hook_url | Unknown |  |
| inbound_spam_threshold | Unknown |  |
| include_bounce_content_in_hook | Unknown |  |
| name | Unknown |  |
| open_hook_url | Unknown |  |
| post_first_open_only | Unknown |  |
| raw_email_enabled | Unknown |  |
| server_link | Unknown |  |
| smtp_api_activated | Unknown |  |
| track_link | Unknown |  |
| track_open | Unknown |  |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| associated_server_id | Unknown | PK, FK |
| active | Unknown |  |
| alias | Unknown |  |
| html_body | Unknown |  |
| layout | Unknown |  |
| name | Unknown |  |
| subject | Unknown |  |
| text_body | Unknown |  |
| type | Unknown |  |

### outbound_statistics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| bounce_rate | Unknown |  |
| bounced | Unknown |  |
| from_date | Unknown |  |
| opens | Unknown |  |
| sent | Unknown |  |
| smtp_api_error | Unknown |  |
| spam_complaint | Unknown |  |
| spam_complaint_rate | Unknown |  |
| to_date | Unknown |  |
| total_click | Unknown |  |
| total_tracked_link_sent | Unknown |  |
| tracked | Unknown |  |
| unique_link_clicked | Unknown |  |
| unique_open | Unknown |  |
| with_client_recorded | Unknown |  |
| with_link_tracking | Unknown |  |
| with_open_tracking | Unknown |  |
| with_platform_recorded | Unknown |  |
| with_read_time_recorded | Unknown |  |

### message_outbound_to

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |

### message_outbound_recipient

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| recipient | Unknown |  |

### message_outbound_cc

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |

### message_outbound_bcc

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| name | Unknown |  |

### message_outbound_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| attachment | Unknown |  |

### message_outbound_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_outbound_id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| delivery_message | Unknown |  |
| destination_ip | Unknown |  |
| destination_server | Unknown |  |
| received_at | Unknown |  |
| recipient | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### message_outbound

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| body | Unknown |  |
| html_body | Unknown |  |
| received_at | Unknown |  |
| received_from | Unknown |  |
| sandboxed | Unknown |  |
| server_id | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| track_links | Unknown |  |
| track_open | Unknown |  |
| custom_** |  |  |

### message_outbound_click

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| click_location | Unknown |  |
| client_company | Unknown |  |
| client_family | Unknown |  |
| client_name | Unknown |  |
| geo_coords | Unknown |  |
| geo_country | Unknown |  |
| geo_country_iso_code | Unknown |  |
| geo_ip | Unknown |  |
| original_link | Unknown |  |
| os_company | Unknown |  |
| os_family | Unknown |  |
| os_name | Unknown |  |
| platform | Unknown |  |
| received_at | Unknown |  |
| recipient | Unknown |  |
| record_type | Unknown |  |
| tags | Unknown |  |
| user_agent | Unknown |  |

### bounce

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| server_id | Unknown | PK, FK |
| message_id | Unknown | FK |
| bounced_at | Unknown |  |
| can_activate | Unknown |  |
| description | Unknown |  |
| detail | Unknown |  |
| dump_available | Unknown |  |
| email | Unknown |  |
| inactive | Unknown |  |
| name | Unknown |  |
| received_from | Unknown |  |
| record_type | Unknown |  |
| subject | Unknown |  |
| tags | Unknown |  |
| type | Unknown |  |
| type_code | Unknown |  |

### message_outbound_open

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| server_id | Unknown | PK, FK |
| client_company | Unknown |  |
| client_family | Unknown |  |
| client_name | Unknown |  |
| geo_coords | Unknown |  |
| geo_country | Unknown |  |
| geo_country_iso_code | Unknown |  |
| geo_ip | Unknown |  |
| os_company | Unknown |  |
| os_family | Unknown |  |
| os_name | Unknown |  |
| platform | Unknown |  |
| read_seconds | Unknown |  |
| received_at | Unknown |  |
| recipient | Unknown |  |
| record_type | Unknown |  |
| stream | Unknown |  |
| tags | Unknown |  |
| user_agent | Unknown |  |

### email_client_usage

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| apple_mail | Unknown |  |
| date | Unknown |  |
| from_date | String |  |
| gmail | Unknown |  |
| outlook | Unknown |  |
| to_date | String |  |
| custom_** |  |  |

### platform_usage

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| date | Unknown |  |
| desktop | Unknown |  |
| from_date | String |  |
| mobile | Unknown |  |
| to_date | String |  |
| unknown | Unknown |  |
| web_mail | Unknown |  |

### suppression

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| message_stream_id | Unknown | FK |
| server_id | Unknown | FK |
| created_at | Unknown |  |
| email_address | Unknown |  |
| origin | Unknown |  |
| suppression_reason | Unknown |  |

### bounce_count

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| date | Unknown |  |
| from_date | String |  |
| hard_bounce | Unknown |  |
| smtp_api_error | Unknown |  |
| soft_bounce | Unknown |  |
| to_date | String |  |
| transient | Unknown |  |

### message_stream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| server_id | Unknown | PK, FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| expected_purge_date | Unknown |  |
| name | Unknown |  |
| subscription_management_configuration_unsubscribe_handling_type | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### click_location

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| server_id | Unknown | FK |
| date | Unknown |  |
| from_date | String |  |
| html | Unknown |  |
| text | Unknown |  |
| to_date | String |  |

## Relationships

- browser_usage(server_id) → server(id)
- browser_usage_platform(server_id) → server(id)
- message_inbound_to(message_inbound_id) → message_inbound(id)
- message_inbound_to(server_id) → message_inbound(server_id)
- message_inbound_cc(message_inbound_id) → message_inbound(id)
- message_inbound_cc(server_id) → message_inbound(server_id)
- message_inbound_header(message_inbound_id) → message_inbound(id)
- message_inbound_header(server_id) → message_inbound(server_id)
- message_inbound_attachment(message_inbound_id) → message_inbound(id)
- message_inbound_attachment(server_id) → message_inbound(server_id)
- template(associated_server_id) → server(id)
- outbound_statistics(server_id) → server(id)
- message_outbound_to(message_outbound_id) → message_outbound(id)
- message_outbound_to(server_id) → message_outbound(server_id)
- message_outbound_recipient(message_outbound_id) → message_outbound(id)
- message_outbound_recipient(server_id) → message_outbound(server_id)
- message_outbound_cc(message_outbound_id) → message_outbound(id)
- message_outbound_cc(server_id) → message_outbound(server_id)
- message_outbound_bcc(message_outbound_id) → message_outbound(id)
- message_outbound_bcc(server_id) → message_outbound(server_id)
- message_outbound_attachment(message_outbound_id) → message_outbound(id)
- message_outbound_attachment(server_id) → message_outbound(server_id)
- message_outbound_event(message_outbound_id) → message_outbound(id)
- message_outbound_event(server_id) → message_outbound(server_id)
- message_outbound_click(id) → message_outbound(id)
- message_outbound_click(server_id) → server(id)
- bounce(server_id) → server(id)
- bounce(message_id) → message_outbound(id)
- message_outbound_open(id) → message_outbound(id)
- message_outbound_open(server_id) → server(id)
- email_client_usage(server_id) → server(id)
- platform_usage(server_id) → server(id)
- suppression(server_id) → server(id)
- suppression(message_stream_id) → message_stream(id)
- bounce_count(server_id) → server(id)
- message_stream(server_id) → server(id)
- click_location(server_id) → server(id)