Fivetran documentation

Search the docs

/

PartnerStack Vendor

Explore the interactive ERD

Table & Field Reference

sale_cycle_stage

Column	Type	Keys
`id`	Unknown	PK
`api_name`	Unknown
`created_at`	Unknown
`description`	Unknown
`internal_status`	Unknown
`name`	Unknown
`object_type`	Unknown
`position`	Unknown
`sales_cycle_key`	Unknown
`sales_cycle_name`	Unknown
`updated_at`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`archived`	Unknown
`created_at`	Unknown
`features_application_enabled`	Unknown
`features_deals_enabled`	Unknown
`features_deals_salesforce`	Unknown
`features_disable_link_create`	Unknown
`features_leads_enabled`	Unknown
`is_default`	Unknown
`name`	Unknown
`slug`	Unknown
`updated_at`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`customer_key`	Unknown	FK
`amount`	Unknown
`amount_usd`	Unknown
`approved`	Unknown
`category_key`	Unknown
`created_at`	Unknown
`currency`	Unknown
`extension`	Json
`metadata`	Json
`product_key`	Unknown
`updated_at`	Unknown

reward

Column	Type	Keys
`id`	Unknown	PK
`action_key`	Unknown	FK
`customer_key`	Unknown	FK
`partnership_key`	Unknown	FK
`transaction_key`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`decline_reason`	Unknown
`description`	Unknown
`invoice_key`	Unknown
`invoice_payment_date`	Unknown
`invoice_status`	Unknown
`line_amount`	Unknown
`line_key`	Unknown
`offer_description`	Unknown
`offer_key`	Unknown
`reward_status`	Unknown
`trigger_key`	Unknown
`updated_at`	Unknown

deal_file

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	PKFK
`field_key`	Unknown
`name`	Unknown

form_template_field

Column	Type	Keys
`index`	Unknown	PK
`form_template_id`	Unknown	FK
`default_value`	Unknown
`help_text`	Unknown
`hidden`	Unknown
`internal_name`	Unknown
`maps_to`	Json
`name`	Unknown
`optioneight`	Unknown
`optionfive`	Unknown
`optionfour`	Unknown
`optionnine`	Unknown
`optionone`	Unknown
`optionseven`	Unknown
`optionsix`	Unknown
`optionthree`	Unknown
`optiontwo`	Unknown
`optionzero`	Unknown
`placeholder_text`	Unknown
`position`	Unknown
`protected`	Unknown
`required`	Unknown
`type`	Unknown

form_template

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown

deal_field

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	FK
`api_name`	Unknown
`external_type`	Unknown
`help_text`	Unknown
`hidden`	Unknown
`internal_name`	Unknown
`name`	Unknown
`option`	Json
`placeholder_text`	Unknown
`position`	Unknown
`required`	Unknown
`type`	Unknown

deal

Column	Type	Keys
`id`	Unknown	PK
`group_key`	Unknown	FK
`partner_key`	Unknown	FK
`account_name`	Unknown
`amount`	Unknown
`close_date`	Unknown
`contact_first_name`	Unknown
`contact_last_name`	Unknown
`created_at`	Unknown
`external_key`	Unknown
`field_data`	Json
`lost_reason`	Unknown
`meta`	Json
`mold_key`	Unknown
`source`	Unknown
`stage`	Unknown
`team_created_at`	Unknown
`team_key`	Unknown
`team_member_created_at`	Unknown
`team_member_email`	Unknown
`team_member_first_name`	Unknown
`team_member_key`	Unknown
`team_member_last_name`	Unknown
`team_member_updated_at`	Unknown
`team_name`	Unknown
`team_updated_at`	Unknown
`updated_at`	Unknown

sub_id

Column	Type	Keys
`sub_id`	Unknown	PK
`action_id`	Unknown	PKFK

action

Column	Type	Keys
`id`	Unknown	PK
`customer_key`	Unknown	FK
`partnership_key`	Unknown	FK
`archived`	Unknown
`company_key`	Unknown
`company_name`	Unknown
`created_at`	Unknown
`type`	Unknown
`updated_at`	Unknown
`value`	Unknown

customer_field

Column	Type	Keys
`id`	Unknown	PK
`customer_key`	Unknown	PKFK
`api_name`	Unknown
`external_type`	Unknown
`help_text`	Unknown
`hidden`	Unknown
`internal_name`	Unknown
`name`	Unknown
`option`	Json
`placeholder_text`	Unknown
`position`	Unknown
`required`	Unknown
`type`	Unknown

customer

Column	Type	Keys
`key`	Unknown	PK
`partnership_key`	Unknown	FK
`created_at`	Unknown
`customer_key`	Unknown
`email`	Unknown
`field_data`	Json
`meta_field`	Unknown
`name`	Unknown
`partner_key`	Unknown
`provider_key`	Unknown
`source_key`	Unknown
`source_type`	Unknown
`test`	Unknown
`updated_at`	Unknown

partner_team_member

Column	Type	Keys
`id`	Unknown	PK
`id`	Unknown	FK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`role`	Unknown

partner_team

Column	Type	Keys
`id`	Unknown	PK
`partnership_id`	Unknown	FK
`team_key`	Unknown	FK
`team_name`	Unknown	FK
`partnership_key`	Unknown

partnership_tag

Column	Type	Keys
`tags`	Unknown	PK
`partnership_id`	Unknown	PKFK

partnership

Column	Type	Keys
`id`	Unknown	PK
`group_key`	Unknown	FK
`address_city`	Unknown
`address_country`	Unknown
`address_key`	Unknown
`address_postal`	Unknown
`address_primary`	Unknown
`address_region`	Unknown
`address_state`	Unknown
`address_street`	Unknown
`address_unit`	Unknown
`approved_status`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`joined_at`	Unknown
`last_name`	Unknown
`manager_manager_email`	Unknown
`manager_manager_name`	Unknown
`mdata`	Json
`partner_key`	Unknown
`stats_commission_earned`	Unknown
`stats_commission_paid`	Unknown
`stats_commission_unpaid`	Unknown
`stats_customer_count`	Unknown
`stats_deal_revenue`	Unknown
`stats_deal_submitted`	Unknown
`stats_drip_pending`	Unknown
`stats_lead_submitted`	Unknown
`stats_link_clicks`	Unknown
`stats_paid_account_count`	Unknown
`stats_partner_count`	Unknown
`stats_pending`	Unknown
`stats_revenue`	Unknown
`stats_transaction_count`	Unknown
`team_key`	Unknown
`team_name`	Unknown
`updated_at`	Unknown

lead_field

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	FK
`api_name`	Unknown
`external_type`	Unknown
`help_text`	Unknown
`hidden`	Unknown
`internal_name`	Unknown
`name`	Unknown
`options`	Json
`placeholder_text`	Unknown
`position`	Unknown
`required`	Unknown
`type`	Unknown
`value`	Unknown

lead

Column	Type	Keys
`id`	Unknown	PK
`customer_key`	Unknown	FK
`group_key`	Unknown	FK
`mold_key`	Unknown	FK
`partner_key`	Unknown	FK
`amount`	Unknown
`approved`	Unknown
`created_at`	Unknown
`external_key`	Unknown
`field_data_company`	Unknown
`field_data_email`	Unknown
`field_data_firstname`	Unknown
`field_data_industry`	Unknown
`field_data_lastname`	Unknown
`field_data_notes`	Unknown
`field_data_phone`	Unknown
`field_data_website`	Unknown
`meta_additional_prop`	Json
`meta_company`	Unknown
`meta_email`	Unknown
`meta_first_name`	Unknown
`meta_last_name`	Unknown
`stage_data_api_name`	Unknown
`stage_data_description`	Unknown
`stage_data_internal_status`	Unknown
`stage_data_key`	Unknown
`stage_data_name`	Unknown
`status`	Unknown
`team_created_at`	Unknown
`team_key`	Unknown
`team_member_created_at`	Unknown
`team_member_email`	Unknown
`team_member_first_name`	Unknown
`team_member_key`	Unknown
`team_member_last_name`	Unknown
`team_member_updated_at`	Unknown
`team_name`	Unknown
`team_updated_at`	Unknown
`updated_at`	Unknown