# PartnerStack Vendor schema ERD

Table and field reference for the Fivetran PartnerStack Vendor connector.

## 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, 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 |  |

### 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 | PK, FK |

### 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 |  |

## Relationships

- transaction(customer_key) → customer(key)
- reward(customer_key) → customer(key)
- reward(action_key) → action(id)
- reward(transaction_key) → transaction(id)
- reward(partnership_key) → partnership(id)
- deal_file(deal_id) → deal(id)
- form_template_field(form_template_id) → form_template(id)
- deal_field(deal_id) → deal(id)
- deal(partner_key) → partnership(partner_key)
- deal(group_key) → groups(id)
- sub_id(action_id) → action(id)
- action(customer_key) → customer(key)
- action(partnership_key) → partnership(id)
- customer_field(customer_key) → customer(key)
- customer(partnership_key) → partnership(id)
- partner_team_member(id) → partner_team(id)
- partner_team(team_key) → partnership(team_key)
- partner_team(team_name) → partnership(team_name)
- partner_team(partnership_id) → partnership(id)
- partnership_tag(partnership_id) → partnership(id)
- partnership(group_key) → groups(id)
- lead_field(lead_id) → lead(id)
- lead(customer_key) → customer(key)
- lead(mold_key) → form_template(id)
- lead(partner_key) → partnership(id)
- lead(group_key) → groups(id)