# Drip schema ERD

Table and field reference for the Fivetran Drip connector.

## Table & Field Reference

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| blacklist | Json |  |
| button_text | Unknown |  |
| confirmation_heading | Unknown |  |
| confirmation_text | Unknown |  |
| created_at | Unknown |  |
| days_between_popup | Unknown |  |
| days_between_popup_after_close | Unknown |  |
| description | Unknown |  |
| headline | Unknown |  |
| hide_on_mobile | Unknown |  |
| is_blacklist_enabled | Unknown |  |
| is_embeddable | Unknown |  |
| is_whitelist_enabled | Unknown |  |
| is_widget_enabled | Unknown |  |
| opacity | Unknown |  |
| orientation | Unknown |  |
| primary_color | Unknown |  |
| secondary_color | Unknown |  |
| seconds_before_popup | Unknown |  |
| send_ga_event | Unknown |  |
| show_labels | Unknown |  |
| whitelist | Json |  |

### email_series_subscriber_active

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| created_at | Instant |  |

### single_email_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| bcc | Unknown |  |
| created_at | Instant |  |
| localize_sending_time | Unknown |  |
| name | Unknown |  |
| send_at | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| text_body | Unknown |  |

### email_series_subscriber_removed

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| created_at | Instant |  |

### workflow_trigger_action_required

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| message | Unknown | PK |
| workflow_trigger_id | Unknown | PK, FK |

### workflow_trigger

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| workflow_id | Unknown | FK |
| provider | Unknown |  |
| trigger_type | Unknown |  |
| type | Unknown |  |
| properties_** |  |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| default_from_email | Unknown |  |
| default_from_name | Unknown |  |
| default_postal_address | Unknown |  |
| enable_third_party_cookies | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| primary_email | Unknown |  |
| url | Unknown |  |

### email_series_campaign_form

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| form_id | Unknown | PK, FK |

### email_series_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| active_subscriber_count | Unknown |  |
| bcc | Unknown |  |
| confirmation_url | Unknown |  |
| created_at | Instant |  |
| days_of_the_week_mask | Unknown |  |
| double_optin | Unknown |  |
| email_count | Unknown |  |
| localize_sending_time | Unknown |  |
| minutes_from_midnight | Unknown |  |
| name | Unknown |  |
| notify_subscribe_email | Unknown |  |
| notify_unsubscribe_email | Unknown |  |
| send_to_confirmation_page | Unknown |  |
| start_immediately | Unknown |  |
| status | Unknown |  |
| unsubscribed_subscriber_count | Unknown |  |
| use_custom_confirmation_page | Unknown |  |

### email_series_subscriber_unsubscribed

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK, FK |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| created_at | Instant |  |

### people_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| people_id | Unknown | PK, FK |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| base_lead_score | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| eu_consent | Unknown |  |
| first_name | Unknown |  |
| ip_address | Unknown |  |
| landing_url | Unknown |  |
| last_name | Unknown |  |
| lead_score | Unknown |  |
| lifetime_value | Unknown |  |
| original_referrer | Unknown |  |
| phone | Unknown |  |
| prospect | Unknown |  |
| sms_consent | Unknown |  |
| sms_number | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| time_zone | Unknown |  |
| user_agent | Unknown |  |
| utc_offset | Unknown |  |
| visitor_uuid | Unknown |  |
| zip | Unknown |  |
| custom_fields_** |  |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Instant |  |
| name | Unknown |  |
| status | Unknown |  |

### event_action

| Column | Type | Keys |
| --- | --- | --- |
| event_action | Unknown | PK |
| account_id | Unknown | PK, FK |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| counting_method | Unknown |  |
| created_at | Instant |  |
| default_value | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### custom_field_identifier

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Unknown | PK |
| account_id | Unknown | PK, FK |

## Relationships

- form(account_id) → account(id)
- email_series_subscriber_active(id) → people(id)
- email_series_subscriber_active(account_id) → account(id)
- email_series_subscriber_active(campaign_id) → email_series_campaign(id)
- single_email_campaign(account_id) → account(id)
- email_series_subscriber_removed(id) → people(id)
- email_series_subscriber_removed(account_id) → account(id)
- email_series_subscriber_removed(campaign_id) → email_series_campaign(id)
- workflow_trigger_action_required(workflow_trigger_id) → workflow_trigger(id)
- workflow_trigger(account_id) → account(id)
- workflow_trigger(workflow_id) → workflow(id)
- email_series_campaign_form(form_id) → form(id)
- email_series_campaign_form(campaign_id) → email_series_campaign(id)
- email_series_campaign(account_id) → account(id)
- email_series_subscriber_unsubscribed(id) → people(id)
- email_series_subscriber_unsubscribed(account_id) → account(id)
- email_series_subscriber_unsubscribed(campaign_id) → email_series_campaign(id)
- people_tag(people_id) → people(id)
- people(account_id) → account(id)
- workflow(account_id) → account(id)
- event_action(account_id) → account(id)
- conversation(account_id) → account(id)
- custom_field_identifier(account_id) → account(id)