# SparkPost schema ERD

Table and field reference for the Fivetran SparkPost connector.

## Table & Field Reference

### rejection_reason_metrics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count_rejected | Unknown |  |
| domain | Unknown |  |
| end_date | Unknown |  |
| metric_type | Unknown |  |
| reason | Unknown |  |
| rejection_category_id | Unknown |  |
| rejection_category_name | Unknown |  |
| start_date | Unknown |  |

### deliverability_metrics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| subaccount_id | Unknown | FK |
| template_id | Unknown | FK |
| count_accepted | Unknown |  |
| count_admin_bounce | Unknown |  |
| count_block_bounce | Unknown |  |
| count_bounce | Unknown |  |
| count_clicked | Unknown |  |
| count_delayed | Unknown |  |
| count_delayed_first | Unknown |  |
| count_delivered | Unknown |  |
| count_delivered_first | Unknown |  |
| count_delivered_subsequent | Unknown |  |
| count_generation_failed | Unknown |  |
| count_generation_rejection | Unknown |  |
| count_hard_bounce | Unknown |  |
| count_inband_bounce | Unknown |  |
| count_inbox_panel | Unknown |  |
| count_inbox_seed | Unknown |  |
| count_inbox_seed_private | Unknown |  |
| count_inbox_seed_virtual | Unknown |  |
| count_initial_rendered | Unknown |  |
| count_injected | Unknown |  |
| count_moved_to_inbox | Unknown |  |
| count_moved_to_spam | Unknown |  |
| count_nonprefetched_rendered | Unknown |  |
| count_nonprefetched_unique_confirmed_opened | Unknown |  |
| count_nonprefetched_unique_rendered | Unknown |  |
| count_outofband_bounce | Unknown |  |
| count_policy_rejection | Unknown |  |
| count_rejected | Unknown |  |
| count_rendered | Unknown |  |
| count_sent | Unknown |  |
| count_soft_bounce | Unknown |  |
| count_spam_complaint | Unknown |  |
| count_spam_panel | Unknown |  |
| count_spam_seed | Unknown |  |
| count_spam_seed_private | Unknown |  |
| count_spam_seed_virtual | Unknown |  |
| count_targeted | Unknown |  |
| count_undetermined_bounce | Unknown |  |
| count_unique_clicked | Unknown |  |
| count_unique_confirmed_opened | Unknown |  |
| count_unique_initial_rendered | Unknown |  |
| count_unique_rendered | Unknown |  |
| domain | Unknown |  |
| end_date | Unknown |  |
| ip_pool | Unknown |  |
| metric_type | Unknown |  |
| sending_domain | Unknown |  |
| sending_ip | Unknown |  |
| start_date | Unknown |  |
| total_delivery_time_first | Unknown |  |
| total_delivery_time_subsequent | Unknown |  |
| total_msg_volume | Unknown |  |
| ts | Unknown |  |
| watched_domain | Unknown |  |

### engagement_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count_clicked | Unknown |  |
| count_raw_clicked | Unknown |  |
| end_date | String |  |
| link_name | Unknown |  |
| start_date | String |  |

### event_rcpt_tag

| Column | Type | Keys |
| --- | --- | --- |
| rcpt_tag | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_sms_remote

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

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| template_id | Unknown | FK |
| ab_test_id | Unknown |  |
| ab_test_version | Unknown |  |
| amp_enabled | Unknown |  |
| bounce_class | Unknown |  |
| campaign_id | Unknown |  |
| click_tracking | Unknown |  |
| delv_method | Unknown |  |
| device_token | Unknown |  |
| end_date | String |  |
| error_code | Unknown |  |
| fbtype | Unknown |  |
| friendly_from | Unknown |  |
| geo_ip_city | Unknown |  |
| geo_ip_continent | Unknown |  |
| geo_ip_country | Unknown |  |
| geo_ip_latitude | Unknown |  |
| geo_ip_longitude | Unknown |  |
| geo_ip_postal_code | Unknown |  |
| geo_ip_region | Unknown |  |
| geo_ip_zip | Unknown |  |
| initial_pixel | Unknown |  |
| injection_time | Unknown |  |
| ip_address | Unknown |  |
| ip_pool | Unknown |  |
| mailbox_provider | Unknown |  |
| mailbox_provider_region | Unknown |  |
| mailfrom | Unknown |  |
| message_id | Unknown |  |
| msg_from | Unknown |  |
| msg_size | Unknown |  |
| num_retry | Unknown |  |
| open_tracking | Unknown |  |
| outbound_tls | Unknown |  |
| queue_time | Unknown |  |
| raw_rcpt_to | Unknown |  |
| raw_reason | Unknown |  |
| rcpt_hash | Unknown |  |
| rcpt_subs_country | Unknown |  |
| rcpt_subs_gender | Unknown |  |
| rcpt_to | Unknown |  |
| rcpt_type | Unknown |  |
| reason | Unknown |  |
| recipient_domain | Unknown |  |
| recv_method | Unknown |  |
| remote_addr | Unknown |  |
| report_by | Unknown |  |
| report_to | Unknown |  |
| routing_domain | Unknown |  |
| scheduled_time | Unknown |  |
| sending_domain | Unknown |  |
| sending_ip | Unknown |  |
| sms_coding | Unknown |  |
| sms_dst | Unknown |  |
| sms_dst_npi | Unknown |  |
| sms_dst_ton | Unknown |  |
| sms_segments | Unknown |  |
| sms_src | Unknown |  |
| sms_src_npi | Unknown |  |
| sms_src_ton | Unknown |  |
| sms_text | Unknown |  |
| start_date | String |  |
| subaccount_id | Unknown |  |
| subject | Unknown |  |
| target_link_name | Unknown |  |
| target_link_url | Unknown |  |
| template_version | Unknown |  |
| timestamps | Unknown |  |
| transactional | Unknown |  |
| transmission_id | Unknown |  |
| type | Unknown |  |
| user_agent | Unknown |  |
| user_agent_parsed_agent_family | Unknown |  |
| user_agent_parsed_device_brand | Unknown |  |
| user_agent_parsed_device_family | Unknown |  |
| user_agent_parsed_is_mobile | Unknown |  |
| user_agent_parsed_is_prefetched | Unknown |  |
| user_agent_parsed_is_proxy | Unknown |  |
| user_agent_parsed_os_family | Unknown |  |
| user_agent_parsed_os_version | Unknown |  |
| rcpt_meta_** |  |  |

### tracking_domain

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| defaults | Unknown |  |
| domain | Unknown |  |
| port | Unknown |  |
| secure | Unknown |  |
| status_cname_status | Unknown |  |
| status_compliance_status | Unknown |  |
| status_verified | Unknown |  |

### sending_ip

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| auto_warmup_enabled | Unknown |  |
| auto_warmup_stage | Unknown |  |
| customer_provided | Unknown |  |
| external_ip | Unknown |  |
| hostname | Unknown |  |
| ip_pool | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK |
| anniversary_date | Unknown |  |
| company_name | Unknown |  |
| country_code | Unknown |  |
| created | Unknown |  |
| options_blocklist_monitor | Unknown |  |
| options_inbox_placement | Unknown |  |
| options_smtp_tracking_default | Unknown |  |
| service_level | Unknown |  |
| status | Unknown |  |
| status_reason_category | Unknown |  |
| status_updated | Unknown |  |
| subscription_code | Unknown |  |
| subscription_name | Unknown |  |
| subscription_overage | Unknown |  |
| subscription_period | Unknown |  |
| subscription_plan_volume | Unknown |  |
| subscription_plan_volume_per_period | Unknown |  |
| subscription_recurring_charge | Unknown |  |
| subscription_self_serve | Unknown |  |
| subscription_type | Unknown |  |
| tfa_required | Unknown |  |
| ui_allow_deliverability_metrics | Unknown |  |
| ui_hide_terminated_subaccount | Unknown |  |
| ui_onboarding_view_developer_docs_completed | Unknown |  |
| updated | Unknown |  |
| usage_day_end | Unknown |  |
| usage_day_limit | Unknown |  |
| usage_day_start | Unknown |  |
| usage_day_used | Unknown |  |
| usage_month_end | Unknown |  |
| usage_month_limit | Unknown |  |
| usage_month_start | Unknown |  |
| usage_month_used | Unknown |  |
| usage_sandbox_limit | Unknown |  |
| usage_sandbox_used | Unknown |  |
| usage_timestamp | Unknown |  |

### snippet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| shared_with_subaccount | Unknown |  |
| updated_at | Unknown |  |

### bounce_metrics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bounce_category_id | Unknown |  |
| bounce_category_name | Unknown |  |
| bounce_class_description | Unknown |  |
| bounce_class_name | Unknown |  |
| classification_id | Unknown |  |
| count_bounce | Unknown |  |
| count_inband_bounce | Unknown |  |
| count_outofband_bounce | Unknown |  |
| domain | Unknown |  |
| end_date | Unknown |  |
| metric_type | Unknown |  |
| reason | Unknown |  |
| start_date | Unknown |  |

### subaccount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| compliance_status | Unknown |  |
| deliverability | Unknown |  |
| ip_pool | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subaccount_id | Unknown | FK |
| description | Unknown |  |
| has_draft | Unknown |  |
| has_published | Unknown |  |
| last_update_time | Unknown |  |
| last_use | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| shared_with_subaccount | Unknown |  |

### deliveries_by_attempt

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attempt | Unknown |  |
| count_delivered | Unknown |  |
| count_raw_clicked | Unknown |  |
| end_date | String |  |
| start_date | String |  |

### delay_reason_metrics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| count_delayed | Unknown |  |
| count_delayed_first | Unknown |  |
| domain | Unknown |  |
| end_date | Unknown |  |
| metric_type | Unknown |  |
| reason | Unknown |  |
| start_date | Unknown |  |

### sending_domain

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| creation_time | Unknown |  |
| domain | Unknown |  |
| is_default_bounce_domain | Unknown |  |
| shared_with_subaccount | Unknown |  |
| status_abuse_at_status | Unknown |  |
| status_cname_status | Unknown |  |
| status_compliance_status | Unknown |  |
| status_dkim_status | Unknown |  |
| status_mx_status | Unknown |  |
| status_ownership_verified | Unknown |  |
| status_postmaster_at_status | Unknown |  |
| status_spf_status | Unknown |  |
| status_verification_mailbox | Unknown |  |
| status_verification_mailbox_status | Unknown |  |

### recipient_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| internal_id | Unknown |  |
| list_group_id | Unknown |  |
| name | Unknown |  |
| total_accepted_recipient | Unknown |  |

### a_b_testing_variant

| Column | Type | Keys |
| --- | --- | --- |
| a_b_testing_id | Unknown | PK, FK |
| template_id | Unknown | PK, FK |
| count_accepted | Unknown |  |
| count_unique_confirmed_opened | Unknown |  |
| engagement_rate | Unknown |  |
| percents | Unknown |  |

### a_b_testing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| audience_selection | Unknown |  |
| confidence_level | Unknown |  |
| created_at | Unknown |  |
| default_template_count_accepted | Unknown |  |
| default_template_count_unique_confirmed_opened | Unknown |  |
| default_template_engagement_rate | Unknown |  |
| default_template_id | Unknown |  |
| default_template_percent | Unknown |  |
| engagement_timeout | Unknown |  |
| metric | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| test_mode | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### ip_pool_ip

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ip_pool_id | Unknown | PK, FK |
| auto_warmup_enabled | Unknown |  |
| external_ip | Unknown |  |
| hostname | Unknown |  |

### ip_pool

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_provided | Unknown |  |
| name | Unknown |  |

## Relationships

- deliverability_metrics(template_id) → template(id)
- deliverability_metrics(campaign_id) → event(campaign_id)
- deliverability_metrics(subaccount_id) → subaccount(id)
- event_rcpt_tag(event_id) → event(id)
- event_sms_remote(event_id) → event(id)
- event(template_id) → template(id)
- event(customer_id) → account(customer_id)
- subaccount(customer_id) → account(customer_id)
- template(subaccount_id) → subaccount(id)
- a_b_testing_variant(template_id) → template(id)
- a_b_testing_variant(a_b_testing_id) → a_b_testing(id)
- ip_pool_ip(ip_pool_id) → ip_pool(id)