Fivetran documentation

Search the docs

/

Drip

Explore the interactive ERD

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	PKFK
`campaign_id`	Unknown	PKFK
`id`	Unknown	PKFK
`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	PKFK
`campaign_id`	Unknown	PKFK
`id`	Unknown	PKFK
`created_at`	Instant

workflow_trigger_action_required

Column	Type	Keys
`code`	Unknown	PK
`message`	Unknown	PK
`workflow_trigger_id`	Unknown	PKFK

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	PKFK
`form_id`	Unknown	PKFK

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	PKFK
`campaign_id`	Unknown	PKFK
`id`	Unknown	PKFK
`created_at`	Instant

people_tag

Column	Type	Keys
`id`	Unknown	PK
`people_id`	Unknown	PKFK

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	PKFK

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	PKFK