# Copper schema ERD

Table and field reference for the Fivetran Copper connector.

## Table & Field Reference

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| primary_timezone | Unknown |  |
| setting_enable_lead | Unknown |  |
| setting_team_permissions_enabled | Unknown |  |

### custom_field_definition_available_on

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_field_definition_id | Unknown | PK, FK |
| available_on | Unknown |  |

### custom_field_definition_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_field_definition_id | Unknown | FK |
| name | Unknown |  |
| rank | Unknown |  |

### custom_field_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency | Unknown |  |
| data_type | Unknown |  |
| is_filterable | Unknown |  |
| name | Unknown |  |

### contact_type

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

### custom_activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| icon_type | Unknown |  |
| is_default_task_type | Unknown |  |
| is_disabled | Unknown |  |
| is_interaction | Unknown |  |
| name | Unknown |  |

### pipeline

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

### task_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_id | Unknown | PK, FK |
| tags | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| custom_activity_type_id | Unknown | FK |
| opportunity_id | Json | FK |
| project_id | Json | FK |
| completed_date | Unknown |  |
| custom_field | Json |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| detail | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| related_resource_id | Unknown |  |
| related_resource_type | Unknown |  |
| reminder_date | Unknown |  |
| status | Unknown |  |

### pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| name | Unknown |  |
| win_probability | Unknown |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| tags | Unknown |  |

### project_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_definition_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| value | Json |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| detail | Unknown |  |
| name | Unknown |  |
| related_resource_id | Unknown |  |
| related_resource_type | Unknown |  |
| status | Unknown |  |

### opportunity_loss_reason

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

### company_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| category | Unknown |  |
| number | Unknown |  |

### company_social

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### company_website

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### company_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| tags | Unknown |  |

### company_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| custom_field_definition_id | Unknown | PK, FK |
| value | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| contact_type_id | Unknown | FK |
| age | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| date_created | Unknown |  |
| date_modified | Instant |  |
| detail | Unknown |  |
| email_domain | Unknown |  |
| followed | Unknown |  |
| interaction_count | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |

### customer_source

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

### people_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| category | Unknown |  |
| number | Unknown |  |

### people_social

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### people_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| category | Unknown |  |
| email | Unknown |  |

### people_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| tags | Unknown |  |

### people_website

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| people_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### people_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_definition_id | Unknown | PK, FK |
| people_id | Unknown | PK, FK |
| value | Json |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| company_id | Unknown | FK |
| contact_type_id | Unknown | FK |
| opportunity_id | Json | FK |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| date_created | Unknown |  |
| date_last_contacted | Unknown |  |
| date_lead_created | Unknown |  |
| date_modified | Instant |  |
| detail | Unknown |  |
| first_name | Unknown |  |
| interaction_count | Unknown |  |
| last_name | Unknown |  |
| leads_converted_from | Json |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| prefix | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| suffix | Unknown |  |
| title | Unknown |  |

### users_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| name | Unknown |  |

### opportunity_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| tags | Unknown |  |

### opportunity_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_definition_id | Unknown | PK, FK |
| opportunity_id | Unknown | PK, FK |
| value | Json |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| company_id | Unknown | FK |
| customer_source_id | Unknown | FK |
| loss_reason_id | Unknown | FK |
| pipeline_id | Unknown | FK |
| pipeline_stage_id | Unknown | FK |
| primary_contact_id | Unknown | FK |
| close_date | Unknown |  |
| company_name | Unknown |  |
| converted_unit | Unknown |  |
| converted_value | Unknown |  |
| date_created | Unknown |  |
| date_last_contacted | Unknown |  |
| date_lead_created | Unknown |  |
| date_modified | Unknown |  |
| date_stage_changed | Unknown |  |
| detail | Unknown |  |
| interaction_count | Unknown |  |
| leads_converted_from | Json |  |
| monetary_unit | Unknown |  |
| monetary_value | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| status | Unknown |  |
| win_probability | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| user_id | Unknown | FK |
| activity_date | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| detail | Unknown |  |
| new_value | Unknown |  |
| old_value | Unknown |  |
| parent_type | Unknown |  |
| type_category | Unknown |  |
| type_id | Unknown |  |

### lead_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_id | Unknown | PK, FK |
| category | Unknown |  |
| number | Unknown |  |

### lead_social

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### lead_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_id | Unknown | PK, FK |
| tags | Unknown |  |

### lead_website

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_id | Unknown | PK, FK |
| category | Unknown |  |
| url | Unknown |  |

### lead_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_definition_id | Unknown | PK, FK |
| lead_id | Unknown | PK, FK |
| value | Json |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| company_id | Unknown | FK |
| contact_type_id | Unknown | FK |
| customer_source_id | Json | FK |
| city | Unknown |  |
| converted_at | Unknown |  |
| converted_contact_id | Unknown |  |
| converted_opportunity_id | Unknown |  |
| country | Unknown |  |
| date_created | Unknown |  |
| date_last_contacted | Unknown |  |
| date_modified | Unknown |  |
| detail | Json |  |
| email | Unknown |  |
| email_category | Unknown |  |
| first_name | Unknown |  |
| interaction_count | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| monetary_value | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| prefix | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| status_id | Unknown |  |
| street | Unknown |  |
| suffix | Unknown |  |
| title | Unknown |  |

## Relationships

- custom_field_definition_available_on(custom_field_definition_id) → custom_field_definition(id)
- custom_field_definition_option(custom_field_definition_id) → custom_field_definition(id)
- custom_activity_type(company_id) → company(id)
- task_tag(task_id) → task(id)
- task(opportunity_id) → opportunity(id)
- task(custom_activity_type_id) → custom_activity_type(id)
- task(assignee_id) → users(id)
- task(project_id) → project(id)
- pipeline_stage(pipeline_id) → pipeline(id)
- project_tag(project_id) → project(id)
- project_custom_field(custom_field_definition_id) → custom_field_definition(id)
- project_custom_field(project_id) → project(id)
- project(assignee_id) → users(id)
- company_phone_number(company_id) → company(id)
- company_social(company_id) → company(id)
- company_website(company_id) → company(id)
- company_tag(company_id) → company(id)
- company_custom_field(custom_field_definition_id) → custom_field_definition(id)
- company_custom_field(company_id) → company(id)
- company(contact_type_id) → contact_type(id)
- company(assignee_id) → users(id)
- people_phone_number(people_id) → people(id)
- people_social(people_id) → people(id)
- people_email(people_id) → people(id)
- people_tag(people_id) → people(id)
- people_website(people_id) → people(id)
- people_custom_field(custom_field_definition_id) → custom_field_definition(id)
- people_custom_field(people_id) → people(id)
- people(opportunity_id) → opportunity(id)
- people(contact_type_id) → contact_type(id)
- people(assignee_id) → users(id)
- people(company_id) → company(id)
- users_group(users_id) → users(id)
- opportunity_tag(opportunity_id) → opportunity(id)
- opportunity_custom_field(custom_field_definition_id) → custom_field_definition(id)
- opportunity_custom_field(opportunity_id) → opportunity(id)
- opportunity(pipeline_id) → pipeline(id)
- opportunity(customer_source_id) → customer_source(id)
- opportunity(pipeline_stage_id) → pipeline_stage(id)
- opportunity(assignee_id) → users(id)
- opportunity(loss_reason_id) → opportunity_loss_reason(id)
- opportunity(primary_contact_id) → people(id)
- opportunity(company_id) → company(id)
- activity(user_id) → users(id)
- activity(parent_id) → activity(id)
- lead_phone_number(lead_id) → lead(id)
- lead_social(lead_id) → lead(id)
- lead_tag(lead_id) → lead(id)
- lead_website(lead_id) → lead(id)
- lead_custom_field(custom_field_definition_id) → custom_field_definition(id)
- lead_custom_field(lead_id) → lead(id)
- lead(customer_source_id) → customer_source(id)
- lead(assignee_id) → users(id)
- lead(company_id) → company(id)
- lead(contact_type_id) → contact_type(id)