Fivetran documentation

Search the docs

/

Boostr

Explore the interactive ERD

Table & Field Reference

deal_member

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	PKFK
`user_id`	Unknown	FK
`product`	Unknown
`role`	Unknown
`seller_type`	Unknown
`share`	Unknown

deal_contact

Column	Type	Keys
`deal_id`	Unknown	PKFK
`id`	Unknown	PKFK
`email`	Unknown
`role`	Unknown

deal_integration

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	PKFK
`external_id`	Unknown
`external_type`	Unknown

deal

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`agency_id`	Unknown
`agency_name`	Unknown
`budget`	Unknown
`budget_loc`	Unknown
`closed_at`	Unknown
`closed_comments`	Unknown
`closed_reason`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`currency`	Unknown
`deleted_at`	Unknown
`end_date`	Unknown
`lead_id`	Unknown
`name`	Unknown
`next_steps`	Unknown
`source`	Unknown
`stage_id`	Unknown
`stage_name`	Unknown
`start_date`	Unknown
`type`	Unknown
`updated_at`	Unknown
`updated_by`	Unknown
`custom_`

product

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`top_parent_id`	Unknown	FK
`active`	Unknown
`audience_extension_enabled`	Unknown
`created_at`	Unknown
`full_name`	Unknown
`level`	Unknown
`margin`	Unknown
`name`	Unknown
`pg_enabled`	Unknown
`product_family_id`	Unknown
`product_family_name`	Unknown
`product_type`	Unknown
`rate_type_id`	Unknown
`revenue_type`	Unknown
`updated_at`	Unknown
`custom_`

activity_contact

Column	Type	Keys
`activity_id`	Unknown	PKFK
`id`	Unknown	PKFK

activity

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	FK
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`agency_id`	Unknown
`agency_name`	Unknown
`comment`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`happened_at`	Unknown
`lead_id`	Unknown
`lead_name`	Unknown
`publisher_id`	Unknown
`publisher_name`	Unknown
`type_id`	Unknown
`type_name`	Unknown
`updated_at`	Unknown
`updated_by`	Unknown
`user_name`	Unknown
`custom_`

user_team_member

Column	Type	Keys
`id`	Unknown	PKFK
`users_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`average_deal_size`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`email`	Unknown
`employee_id`	Unknown
`first_name`	Unknown
`is_active`	Unknown
`last_name`	Unknown
`team_created_at`	Unknown
`team_deleted_at`	Unknown
`team_id`	Unknown
`team_leader_email`	Unknown
`team_leader_id`	Unknown
`team_members_count`	Unknown
`team_name`	Unknown
`team_parent_id`	Unknown
`team_parent_name`	Unknown
`team_top_parent_id`	Unknown
`team_top_parent_name`	Unknown
`team_type`	Unknown
`team_updated_at`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown
`updated_by`	Unknown
`win_rate`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`address_city`	Unknown
`address_country`	Unknown
`address_email`	Unknown
`address_mobile`	Unknown
`address_phone`	Unknown
`address_state`	Unknown
`address_street_1`	Unknown
`address_street_2`	Unknown
`address_zip`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`deleted_at`	Unknown
`name`	Unknown
`position`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown
`updated_by`	Unknown
`works_at`	Unknown
`custom_`

account_client_contact

Column	Type	Keys
`account_id`	Unknown	PKFK
`id`	Unknown	PKFK
`is_active`	Unknown
`is_primary`	Unknown

account_team

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown
`role`	Unknown
`share`	Unknown
`type`	Unknown

account_type

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`type`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`parent_account_id`	Unknown	FK
`address_city`	Unknown
`address_country`	Unknown
`address_email`	Unknown
`address_mobile`	Unknown
`address_phone`	Unknown
`address_state`	Unknown
`address_street_1`	Unknown
`address_street_2`	Unknown
`address_zip`	Unknown
`category`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`deleted_at`	Unknown
`discount`	Unknown
`holding_company`	Unknown
`legacy_id`	Unknown
`name`	Unknown
`note`	Unknown
`region`	Unknown
`segment`	Unknown
`shell_record`	Unknown
`sub_category`	Unknown
`updated_at`	Unknown
`updated_by`	Unknown
`website`	Unknown
`custom_`

deal_product_budget

Column	Type	Keys
`index`	Unknown	PK
`deal_product_id`	Unknown	PKFK
`budget`	Unknown
`budget_loc`	Unknown
`month`	Unknown

deal_product

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	FK
`product_id`	Unknown	FK
`product_parent_id`	Unknown	FK
`product_top_parent_id`	Unknown	FK
`budget`	Unknown
`budget_loc`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`period`	Unknown
`show_in_forecast`	Unknown
`start_date`	Unknown
`term`	Unknown
`territory_id`	Unknown
`territory_name`	Unknown
`updated_at`	Unknown
`custom_`