# Adform schema ERD

Table and field reference for the Fivetran Adform connector.

## Table & Field Reference

### buyer_stats_metadata_metric_spec_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| buyer_stats_metadata_metric_id | Unknown | PK, FK |
| buyer_stats_metadata_metric_spec_index | Unknown | PK, FK |
| defaults | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| title | Unknown |  |

### buyer_stats_metadata_metric_spec

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| buyer_stats_metadata_metric_id | Unknown | PK, FK |
| description | Unknown |  |
| key | Unknown |  |
| title | Unknown |  |

### buyer_stats_metadata_metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes | Json |  |
| category | Unknown |  |
| description | Unknown |  |
| display_format | Unknown |  |
| title | Unknown |  |

### manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| full_name | Unknown |  |
| user_group_ids | Json |  |

### time_zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| time_zone | Unknown |  |

### tracking_domain

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

### seller_stats_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| last_action_at | Unknown |  |
| location | Unknown |  |
| state | Unknown |  |

### campaigns

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| advertiser_id | Unknown |  |
| billing_code | Unknown |  |
| budget | Unknown |  |
| co_manager_id | Unknown |  |
| currency | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| purchase_order_number | Unknown |  |
| start_date | Instant |  |
| status | Unknown |  |
| sub_type | Unknown |  |
| time_zone | Unknown |  |
| type | Unknown |  |

### seller_stats_metadata_dimension

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| display_format | Unknown |  |
| title | Unknown |  |

### buyer_stats_metadata_dimension

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| display_format | Unknown |  |
| title | Unknown |  |

### buyer_stats_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| last_action_at | Instant |  |
| location | Unknown |  |
| status | Unknown |  |

### seller_stats_metadata_metric_spec_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| seller_stats_metadata_metric_spec_index | Unknown | PK, FK |
| seller_stats_metadata_spec_id | Unknown | PK, FK |
| defaults | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| title | Unknown |  |

### seller_stats_metadata_metric_spec

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| seller_stats_metadata_metric_id | Unknown | PK, FK |
| description | Unknown |  |
| key | Unknown |  |
| title | Unknown |  |

### seller_stats_metadata_metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attributes | Json |  |
| category | Unknown |  |
| description | Unknown |  |
| display_format | Unknown |  |
| title | Unknown |  |

### publisher

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

### order_budget_flight

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| budget | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| pacing_type | Unknown |  |
| period_type | Unknown |  |
| start_date | Unknown |  |

### order_impression_capping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| impressions | Unknown |  |
| period_duration | Unknown |  |
| period_type | Unknown |  |
| type | Unknown |  |
| viewability_duration | Unknown |  |
| viewability_type | Unknown |  |

### order_kpi

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| ctr_rate | Unknown |  |
| ecpa_effective_cost | Unknown |  |
| ecpc_effective_cost | Unknown |  |
| ecpm_reach_effective_cost | Unknown |  |
| ecpm_viewable_effective_cost | Unknown |  |
| effective_cost | Unknown |  |
| roas_rate | Unknown |  |
| tracking_point_filter_id | Unknown |  |
| video_completion_rate | Unknown |  |
| viewable_rate | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| active | Unknown |  |
| end_date | Unknown |  |
| goal_type | Unknown |  |
| start_date | Unknown |  |

### placement_creative_setting

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

### placement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| publisher_id | Unknown | FK |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

## Relationships

- buyer_stats_metadata_metric_spec_value(buyer_stats_metadata_metric_spec_index) → buyer_stats_metadata_metric_spec(index)
- buyer_stats_metadata_metric_spec_value(buyer_stats_metadata_metric_id) → buyer_stats_metadata_metric_spec(buyer_stats_metadata_metric_id)
- buyer_stats_metadata_metric_spec(buyer_stats_metadata_metric_id) → buyer_stats_metadata_metric(id)
- campaigns(manager_id) → manager(id)
- seller_stats_metadata_metric_spec_value(seller_stats_metadata_metric_spec_index) → seller_stats_metadata_metric_spec(index)
- seller_stats_metadata_metric_spec_value(seller_stats_metadata_spec_id) → seller_stats_metadata_metric_spec(seller_stats_metadata_metric_id)
- seller_stats_metadata_metric_spec(seller_stats_metadata_metric_id) → seller_stats_metadata_metric(id)
- order_budget_flight(orders_id) → orders(id)
- order_impression_capping(orders_id) → orders(id)
- order_kpi(orders_id) → orders(id)
- orders(campaign_id) → campaigns(id)
- placement(publisher_id) → publisher(id)