# Boostr schema ERD

Table and field reference for the Fivetran Boostr connector.

## Table & Field Reference

### deal_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| product | Unknown |  |
| role | Unknown |  |
| seller_type | Unknown |  |
| share | Unknown |  |

### deal_contact

| Column | Type | Keys |
| --- | --- | --- |
| deal_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| email | Unknown |  |
| role | Unknown |  |

### deal_integration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |

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

### 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 | PK, FK |
| id | Unknown | PK, FK |
| is_active | Unknown |  |
| is_primary | Unknown |  |

### account_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| share | Unknown |  |
| type | Unknown |  |

### account_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

## Relationships

- deal_member(user_id) → users(id)
- deal_member(deal_id) → deal(id)
- deal_contact(id) → contact(id)
- deal_contact(deal_id) → deal(id)
- deal_integration(deal_id) → deal(id)
- product(top_parent_id) → product(id)
- product(parent_id) → product(id)
- activity_contact(id) → contact(id)
- activity_contact(activity_id) → activity(id)
- activity(deal_id) → deal(id)
- user_team_member(id) → users(id)
- user_team_member(users_id) → users(id)
- account_client_contact(id) → contact(id)
- account_client_contact(account_id) → account(id)
- account_team(account_id) → account(id)
- account_type(account_id) → account(id)
- account(parent_account_id) → account(id)
- deal_product_budget(deal_product_id) → deal_product(id)
- deal_product(product_id) → product(id)
- deal_product(deal_id) → deal(id)
- deal_product(product_top_parent_id) → product(id)
- deal_product(product_parent_id) → product(id)