# Integrate schema ERD

Table and field reference for the Fivetran Integrate connector.

## Table & Field Reference

### contract_creative_id

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Unknown | PK |
| contract_id | Unknown | PK, FK |

### contract_value_list

| Column | Type | Keys |
| --- | --- | --- |
| value_list | Unknown | PK |
| contract_id | Unknown | PK, FK |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreements_accepted | Unknown |  |
| agreements_required | Unknown |  |
| alias | Unknown |  |
| allocated | Unknown |  |
| approved_date | Unknown |  |
| asset_count | Unknown |  |
| buyer_id | Unknown |  |
| buyer_name | Unknown |  |
| buyer_short_name | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_type | Unknown |  |
| changes_require_approval | Unknown |  |
| channel_name | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| end_date | Unknown |  |
| field_count | Unknown |  |
| goal | Unknown |  |
| insertion_order | Unknown |  |
| integration_type | Unknown |  |
| is_lead_review | Unknown |  |
| latest_lead_activity | Unknown |  |
| lead_review_type | Unknown |  |
| market_place_type | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| pacing | Unknown |  |
| pay_out | Unknown |  |
| percent_to_end_date | Unknown |  |
| percent_to_goal | Unknown |  |
| proofs_required | Unknown |  |
| publisher_id | Unknown |  |
| publisher_name | Unknown |  |
| publisher_short_name | Unknown |  |
| purchase_order | Unknown |  |
| rejected | Unknown |  |
| short_id | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| tag_name | Unknown |  |
| tags | Unknown |  |
| time_zone | Unknown |  |
| version | Unknown |  |

### report_contract_status

| Column | Type | Keys |
| --- | --- | --- |
| contract_status | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_campaign_status

| Column | Type | Keys |
| --- | --- | --- |
| campaign_status | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_lead_status

| Column | Type | Keys |
| --- | --- | --- |
| lead_status | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_contract_id

| Column | Type | Keys |
| --- | --- | --- |
| contract_id | Unknown | PK, FK |
| report_id | Unknown | PK, FK |

### report_auto_campaign_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_campaign_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_auto_buyer_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_buyer_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_auto_publisher_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_publisher_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_auto_domain_list_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_domain_list_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_auto_general_list_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_general_list_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_auto_tag_id

| Column | Type | Keys |
| --- | --- | --- |
| auto_tag_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_integration_id

| Column | Type | Keys |
| --- | --- | --- |
| integration_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_batch_id

| Column | Type | Keys |
| --- | --- | --- |
| bacth_id | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_field

| Column | Type | Keys |
| --- | --- | --- |
| field | Unknown | PK |
| report_id | Unknown | PK, FK |

### report_mapper

| Column | Type | Keys |
| --- | --- | --- |
| mapper | Unknown | PK |
| report_id | Unknown | PK, FK |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_extended_access | Unknown |  |
| auto_add_sources_type | Json |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| created_by_user_id | Unknown |  |
| email_body | Unknown |  |
| email_subject | Unknown |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| include_current_and_future | Unknown |  |
| is_agency | Unknown |  |
| modified_at | LocalDateTime |  |
| name | Unknown |  |
| organization | Unknown |  |
| schedule | Json |  |
| single_file | Unknown |  |
| template | Unknown |  |
| type | Unknown |  |
| ui_template_model | Unknown |  |
| upcoming_run_time | Unknown |  |

### list_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| value | Unknown |  |

### list_parent

| Column | Type | Keys |
| --- | --- | --- |
| parent | Unknown | PK |
| list_id | Unknown | PK, FK |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attribute | Unknown |  |
| campaigns_field_association | Unknown |  |
| campaigns_nested_field_association | Unknown |  |
| case_sensitive | Unknown |  |
| contracts_field_association | Unknown |  |
| contracts_nested_field_association | Unknown |  |
| created_at | Unknown |  |
| entry | Unknown |  |
| is_locked | Unknown |  |
| is_md_5 | Unknown |  |
| last_modified | LocalDateTime |  |
| mapping_count | Unknown |  |
| name | Unknown |  |
| name_lower_case | Unknown |  |
| owner_id | Unknown |  |
| path | Unknown |  |
| source | Unknown |  |
| type | Unknown |  |
| value_list_value | Unknown |  |

## Relationships

- contract_creative_id(contract_id) → contract(id)
- contract_value_list(contract_id) → contract(id)
- report_contract_status(report_id) → report(id)
- report_campaign_status(report_id) → report(id)
- report_lead_status(report_id) → report(id)
- report_contract_id(contract_id) → contract(id)
- report_contract_id(report_id) → report(id)
- report_auto_campaign_id(report_id) → report(id)
- report_auto_buyer_id(report_id) → report(id)
- report_auto_publisher_id(report_id) → report(id)
- report_auto_domain_list_id(report_id) → report(id)
- report_auto_general_list_id(report_id) → report(id)
- report_auto_tag_id(report_id) → report(id)
- report_integration_id(report_id) → report(id)
- report_batch_id(report_id) → report(id)
- report_field(report_id) → report(id)
- report_mapper(report_id) → report(id)
- list_value(list_id) → list(id)
- list_parent(list_id) → list(id)