# Crossbeam schema ERD

Table and field reference for the Fivetran Crossbeam connector.

## Table & Field Reference

### partner_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK, FK |
| partner_id | Unknown | PK, FK |
| label | Unknown |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK |
| domain | Unknown |  |
| name | Unknown |  |

### population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |
| population_type | Unknown |  |
| standard_type | Unknown |  |

### partner_population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |
| population_type | Unknown |  |
| standard_type | Unknown |  |

### report_population

| Column | Type | Keys |
| --- | --- | --- |
| organization_uuid | Unknown | PK, FK |
| population_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |

### report_partner_population

| Column | Type | Keys |
| --- | --- | --- |
| organization_uuid | Unknown | PK, FK |
| partner_population_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK |
| comparison_type | Unknown |  |
| folder_uuid | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| partner_impact_scores | Json |  |
| partner_standard_population | Json |  |
| report_type | Unknown |  |
| tag_id | Unknown |  |

### account_record_population

| Column | Type | Keys |
| --- | --- | --- |
| account_record_id | Unknown | PK, FK |
| crossbeam_record_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| name | Unknown |  |

### account_record

| Column | Type | Keys |
| --- | --- | --- |
| crossbeam_record_id | Unknown | PK |
| organization_uuid | Unknown | PK |
| record_id | Unknown | PK |
| crossbeam_owner_id | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| owner_phone | Unknown |  |
| record_name | Unknown |  |
| record_type | Unknown |  |
| record_website | Unknown |  |
| crm_** |  |  |

### overlap_lead_partner_source_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_uuid | Unknown | PK, FK |
| overlap_lead_crossbeam_record_id | Unknown | PK, FK |
| overlap_lead_partner_crossbeam_record_id | Unknown | PK, FK |
| field_name | Unknown |  |
| field_value | Unknown |  |

### overlap_lead_partner_population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| overlap_lead_crossbeam_record_id | Unknown | PK, FK |
| overlap_lead_partner_crossbeam_record_id | Unknown | PK, FK |
| name | Unknown |  |

### overlap_lead_population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| overlap_lead_crossbeam_record_id | Unknown | PK, FK |
| overlap_lead_partner_crossbeam_record_id | Unknown | PK, FK |
| name | Unknown |  |

### overlap_lead

| Column | Type | Keys |
| --- | --- | --- |
| crossbeam_record_id | Unknown | PK |
| organization_uuid | Unknown | PK |
| partner_crossbeam_record_id | Unknown | PK |
| partner_id | Unknown | FK |
| is_deleted | Unknown |  |
| partner_crossbeam_owner_id | Unknown |  |
| partner_logo_url | Unknown |  |
| partner_name | Unknown |  |
| partner_owner_email | Unknown |  |
| partner_owner_name | Unknown |  |
| partner_owner_phone | Unknown |  |
| partner_record_email | Unknown |  |
| partner_record_type | Unknown |  |
| record_email | Unknown |  |
| record_id | Unknown |  |
| record_name | Unknown |  |
| record_website | Unknown |  |

### user_organization

| Column | Type | Keys |
| --- | --- | --- |
| organization_uuid | Unknown | PK |
| user_id | Unknown | PK, FK |
| domain | Unknown |  |
| label | Unknown |  |
| logo_url | Unknown |  |
| name | Unknown |  |
| role_description | Unknown |  |
| role_name | Unknown |  |
| role_uuid | Unknown |  |
| sales_edge_role | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_uuid | Unknown | PK |
| active | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| picture_url | Unknown |  |

### lead_record_population

| Column | Type | Keys |
| --- | --- | --- |
| crossbeam_record_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| lead_record_id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| name | Unknown |  |

### lead_record

| Column | Type | Keys |
| --- | --- | --- |
| crossbeam_record_id | Unknown | PK |
| organization_uuid | Unknown | PK |
| record_id | Unknown | PK |
| crossbeam_owner_id | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| owner_phone | Unknown |  |
| record_name | Unknown |  |
| record_type | Unknown |  |
| record_website | Unknown |  |
| crm_** |  |  |

### overlap_account_partner_source_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_uuid | Unknown | PK, FK |
| overlap_account_crossbeam_record_id | Unknown | PK, FK |
| overlap_account_partner_crossbeam_record_id | Unknown | PK, FK |
| field_name | Unknown |  |
| field_value | Unknown |  |

### overlap_account_partner_population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| overlap_account_crossbeam_record_id | Unknown | PK, FK |
| overlap_account_partner_crossbeam_record_id | Unknown | PK, FK |
| name | Unknown |  |

### overlap_account_population

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_uuid | Unknown | PK, FK |
| overlap_account_crossbeam_record_id | Unknown | PK, FK |
| overlap_account_partner_crossbeam_record_id | Unknown | PK, FK |
| name | Unknown |  |

### overlap_account

| Column | Type | Keys |
| --- | --- | --- |
| crossbeam_record_id | Unknown | PK |
| organization_uuid | Unknown | PK |
| partner_crossbeam_record_id | Unknown | PK |
| partner_id | Unknown | FK |
| is_deleted | Unknown |  |
| partner_crossbeam_owner_id | Unknown |  |
| partner_logo_url | Unknown |  |
| partner_name | Unknown |  |
| partner_owner_email | Unknown |  |
| partner_owner_name | Unknown |  |
| partner_owner_phone | Unknown |  |
| partner_record_id | Unknown |  |
| partner_record_name | Unknown |  |
| partner_record_type | Unknown |  |
| partner_record_website | Unknown |  |
| record_email | Unknown |  |
| record_id | Unknown |  |
| record_name | Unknown |  |
| record_type | Unknown |  |
| record_website | Unknown |  |

## Relationships

- partner_tag(partner_id) → partner(id)
- partner_tag(organization_uuid) → partner(organization_uuid)
- report_population(population_id) → population(id)
- report_population(organization_uuid) → report(organization_uuid)
- report_population(report_id) → report(id)
- report_partner_population(partner_population_id) → partner_population(id)
- report_partner_population(organization_uuid) → report(organization_uuid)
- report_partner_population(report_id) → report(id)
- account_record_population(id) → population(id)
- account_record_population(crossbeam_record_id) → account_record(crossbeam_record_id)
- account_record_population(account_record_id) → account_record(record_id)
- account_record_population(organization_uuid) → account_record(organization_uuid)
- overlap_lead_partner_source_data(organization_uuid) → overlap_lead(organization_uuid)
- overlap_lead_partner_source_data(overlap_lead_crossbeam_record_id) → overlap_lead(crossbeam_record_id)
- overlap_lead_partner_source_data(overlap_lead_partner_crossbeam_record_id) → overlap_lead(partner_crossbeam_record_id)
- overlap_lead_partner_population(id) → partner_population(id)
- overlap_lead_partner_population(organization_uuid) → overlap_lead(organization_uuid)
- overlap_lead_partner_population(overlap_lead_crossbeam_record_id) → overlap_lead(crossbeam_record_id)
- overlap_lead_partner_population(overlap_lead_partner_crossbeam_record_id) → overlap_lead(partner_crossbeam_record_id)
- overlap_lead_population(id) → population(id)
- overlap_lead_population(organization_uuid) → overlap_lead(organization_uuid)
- overlap_lead_population(overlap_lead_crossbeam_record_id) → overlap_lead(crossbeam_record_id)
- overlap_lead_population(overlap_lead_partner_crossbeam_record_id) → overlap_lead(partner_crossbeam_record_id)
- overlap_lead(partner_id) → partner(id)
- user_organization(user_id) → users(id)
- lead_record_population(id) → population(id)
- lead_record_population(crossbeam_record_id) → lead_record(crossbeam_record_id)
- lead_record_population(lead_record_id) → lead_record(record_id)
- lead_record_population(organization_uuid) → lead_record(organization_uuid)
- overlap_account_partner_source_data(overlap_account_crossbeam_record_id) → overlap_account(crossbeam_record_id)
- overlap_account_partner_source_data(overlap_account_partner_crossbeam_record_id) → overlap_account(partner_crossbeam_record_id)
- overlap_account_partner_source_data(organization_uuid) → overlap_account(organization_uuid)
- overlap_account_partner_population(id) → partner_population(id)
- overlap_account_partner_population(organization_uuid) → overlap_account(organization_uuid)
- overlap_account_partner_population(overlap_account_crossbeam_record_id) → overlap_account(crossbeam_record_id)
- overlap_account_partner_population(overlap_account_partner_crossbeam_record_id) → overlap_account(partner_crossbeam_record_id)
- overlap_account_population(id) → population(id)
- overlap_account_population(organization_uuid) → overlap_account(organization_uuid)
- overlap_account_population(overlap_account_crossbeam_record_id) → overlap_account(crossbeam_record_id)
- overlap_account_population(overlap_account_partner_crossbeam_record_id) → overlap_account(partner_crossbeam_record_id)
- overlap_account(partner_id) → partner(id)