Fivetran documentation

Search the docs

/

Integrate

Explore the interactive ERD

Table & Field Reference

contract_creative_id

Column	Type	Keys
`creative_id`	Unknown	PK
`contract_id`	Unknown	PKFK

contract_value_list

Column	Type	Keys
`value_list`	Unknown	PK
`contract_id`	Unknown	PKFK

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	PKFK

report_campaign_status

Column	Type	Keys
`campaign_status`	Unknown	PK
`report_id`	Unknown	PKFK

report_lead_status

Column	Type	Keys
`lead_status`	Unknown	PK
`report_id`	Unknown	PKFK

report_contract_id

Column	Type	Keys
`contract_id`	Unknown	PKFK
`report_id`	Unknown	PKFK

report_auto_campaign_id

Column	Type	Keys
`auto_campaign_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_auto_buyer_id

Column	Type	Keys
`auto_buyer_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_auto_publisher_id

Column	Type	Keys
`auto_publisher_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_auto_domain_list_id

Column	Type	Keys
`auto_domain_list_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_auto_general_list_id

Column	Type	Keys
`auto_general_list_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_auto_tag_id

Column	Type	Keys
`auto_tag_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_integration_id

Column	Type	Keys
`integration_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_batch_id

Column	Type	Keys
`bacth_id`	Unknown	PK
`report_id`	Unknown	PKFK

report_field

Column	Type	Keys
`field`	Unknown	PK
`report_id`	Unknown	PKFK

report_mapper

Column	Type	Keys
`mapper`	Unknown	PK
`report_id`	Unknown	PKFK

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	PKFK
`value`	Unknown

list_parent

Column	Type	Keys
`parent`	Unknown	PK
`list_id`	Unknown	PKFK

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