Postmark

Explore the interactive ERD

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	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown

message_inbound_cc

Column	Type	Keys
`email`	Unknown	PK
`message_inbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown

message_inbound_header

Column	Type	Keys
`index`	Unknown	PK
`message_inbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

message_inbound_attachment

Column	Type	Keys
`index`	Unknown	PK
`message_inbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown

message_outbound_recipient

Column	Type	Keys
`index`	Unknown	PK
`message_outbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`recipient`	Unknown

message_outbound_cc

Column	Type	Keys
`email`	Unknown	PK
`message_outbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown

message_outbound_bcc

Column	Type	Keys
`email`	Unknown	PK
`message_outbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`name`	Unknown

message_outbound_attachment

Column	Type	Keys
`index`	Unknown	PK
`message_outbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`attachment`	Unknown

message_outbound_event

Column	Type	Keys
`index`	Unknown	PK
`message_outbound_id`	Unknown	PKFK
`server_id`	Unknown	PKFK
`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	PKFK
`server_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`server_id`	Unknown	PKFK
`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	PKFK
`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