# Yahoo DSP schema ERD

Table and field reference for the Fivetran Yahoo DSP connector.

## Table & Field Reference

### beacon_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| beacon_id | Int | PK, FK |
| beacon_updated_at | String | PK, FK |
| key | String |  |
| operator | String |  |
| value | String |  |

### beacon_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | String | PK |
| account_id | Int | FK |
| pixel_id | Int | FK |
| seat_id | Int | FK |
| app_id | String |  |
| app_locale | String |  |
| app_url | String |  |
| conversion_category | String |  |
| conversion_default_value | Double |  |
| created_at | String |  |
| destination_url | String |  |
| destination_url_operator | String |  |
| mobile_measurement_partner | String |  |
| name | String |  |
| rule_type | String |  |

### campaign_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| account_id | Int | FK |
| budget_type | String |  |
| created_at | Instant |  |
| currency | String |  |
| demo_vendor | String |  |
| frequency_cap_period_type | String |  |
| frequency_cap_value | Long |  |
| goal_type | String |  |
| goal_value | Long |  |
| name | String |  |
| package_enabled | Boolean |  |
| status | String |  |
| time_zone | String |  |

### package_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| package_id | Int | PK, FK |
| budget | Double |  |
| daily_budget | Double |  |
| daily_budget_type | String |  |
| end_date | Instant |  |
| imp_budget | Long |  |
| imp_daily_budget | Double |  |
| name | String |  |
| package_language | String |  |
| start_date | Instant |  |

### ad_countdown_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| ad_id | Int | PK, FK |
| ad_updated_at | Instant | PK, FK |
| countdown_prefix_id | Int |  |
| end_date | Instant |  |
| time_zone | String |  |

### advertiser_contact

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Int | PK, FK |
| address_line_1 | String |  |
| address_line_2 | String |  |
| city | String |  |
| country | String |  |
| email | String |  |
| first_name | String |  |
| last_name | String |  |
| postal_code | String |  |
| region | String |  |
| telephone | String |  |

### creative_details_media

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| creative_id | Int | PK, FK |
| bit_rate | Int |  |
| frame_rate | Int |  |
| height | Int |  |
| media_mime_type | String |  |
| media_url | String |  |
| width | Int |  |

### audience_poi_targeting_rule_chain

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Int | PK |
| audience_poi_id | Int | PK, FK |
| is_excluded | Boolean |  |

### deal_account

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Int | PK, FK |
| deal_id | Int | PK, FK |

### audience_poi

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| name | String |  |
| number_of_visits | Int |  |
| retention_days | String |  |
| status | String |  |

### contextual_category_by_taxonomy_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| taxonomy_type | String | PK |
| parent_category_id | Int | FK |
| description | String |  |
| level | Int |  |

### audience_ip_address_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| audience_ip_address_id | Int | PK, FK |
| created_date | Instant |  |
| fail_percentage | Double |  |
| status | String |  |
| type | String |  |

### audience_srt_included_keyword

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| audience_srt_id | Int | PK, FK |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_group_id | Int | FK |
| exchange_id | Int | FK |
| account_is_excluded | Boolean |  |
| description | String |  |
| exchange_deal_id | String |  |
| name | String |  |
| reserve_price | Double |  |
| status | String |  |

### creative_impression_tracking

| Column | Type | Keys |
| --- | --- | --- |
| tracking_event_type | String | PK |
| creative_id | Int | PK, FK |
| imp_tracker_url | String |  |

### audience_poi_targeting_rule_gid

| Column | Type | Keys |
| --- | --- | --- |
| gid_id | Int | PK |
| audience_poi_id | Int | PK, FK |
| is_excluded | Boolean |  |

### targeting_ab_testing

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| user_group_id | Int | FK |
| lower_bound | Int |  |
| name | String |  |
| traffic_percent | Int |  |
| upper_bound | Int |  |

### creative_details

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Int | PK, FK |
| call_to_action | String |  |
| company_name | String |  |
| description | String |  |
| duration | Int |  |
| title | String |  |

### line_fee_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| fee | Double |  |
| name | String |  |
| type_name | String |  |

### creative_expand_direction

| Column | Type | Keys |
| --- | --- | --- |
| direction | String | PK |
| creative_id | Int | PK, FK |

### ad_schedule_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| ad_id | Int | PK, FK |
| ad_updated_at | Instant | PK, FK |
| end_date | Instant |  |
| start_date | Instant |  |

### audience_mail_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| created_at | LocalDate |  |
| even_type | String |  |
| frequency | Int |  |
| name | String |  |
| status | String |  |

### audience_mail_event_time_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| audience_mail_event_id | Int | PK, FK |
| from_date | LocalDate |  |
| key | String |  |
| name | String |  |
| num_days | String |  |
| range_type | String |  |
| to_date | LocalDate |  |

### targeting_frequency_capping

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Int | PK, FK |
| cap_period | String |  |
| cap_value | String |  |
| enable_viewability_freq_cap | Boolean |  |
| serve_unknown_user | Boolean |  |

### creative_companion_banner

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| creative_id | Int | PK, FK |
| mime_type | String |  |
| name | String |  |

### targeting_demographic

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Int | PK, FK |
| threshold | Double |  |

### targeting_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| audience_type | String |  |
| created_at | LocalDate |  |
| is_excluded | Boolean |  |
| name | String |  |
| reach_count | Long |  |
| recency | Int |  |
| segment_type | String |  |

### audience_mail_domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| created_at | LocalDate |  |
| name | String |  |
| retention_days | Int |  |
| status | String |  |

### audience_email_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| created_at | LocalDate |  |
| name | String |  |
| status | String |  |

### targeting_deal

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| line_id | Int | PK, FK |
| exchange_deal_id | String | FK |
| exchange_id | Int | FK |
| account_is_excluded | Boolean |  |
| description | String |  |
| is_excluded | Boolean |  |
| name | String |  |
| reserve_price | Double |  |
| status | String |  |

### beacon_instrumentation_code

| Column | Type | Keys |
| --- | --- | --- |
| beacon_id | Int | PK, FK |
| pixel_id | Int | FK |
| custom_event_script | String |  |
| url_secure_multiple | String |  |
| url_secure_single | String |  |

### contextual_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| name | String |  |
| owner_type | String |  |
| taxonomy_type | String |  |

### audience_email_address_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| audience_email_address_id | Int | PK, FK |
| created_date | Instant |  |
| duplicated | Int |  |
| error_message | String |  |
| fail_percentage | Double |  |
| status | String |  |
| total_failed | Int |  |
| total_ids | Int |  |
| type | String |  |

### targeting_weather_temperature

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Int | PK, FK |
| all_temperatures | Boolean |  |
| is_fahrenheit | Boolean |  |
| max_temp | Int |  |
| min_temp | Int |  |

### audience_profile_size

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| profile_timestamp | Instant | PK |
| count | Long |  |

### audience_profile_gender

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String | PK |
| count | Long |  |
| unique_count | Long |  |

### pixel

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | PK, FK |
| name | String |  |

### targeting_dooh_screen_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| name | String |  |

### audience_mail_domain_excluded_domains

| Column | Type | Keys |
| --- | --- | --- |
| domain | String | PK |
| audience_mail_domain | Int | PK, FK |

### audience_srt

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| broad_optimization_type | String |  |
| created_at | LocalDate |  |
| match_type | String |  |
| name | String |  |
| retention_days | Int |  |
| status | String |  |

### audience_poi_targeting_rule_woeid

| Column | Type | Keys |
| --- | --- | --- |
| woe_id | Int | PK |
| audience_poi_id | Int | PK, FK |
| is_excluded | Boolean |  |

### targeting_weather_humidity

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Int | PK, FK |
| all_humidities | Boolean |  |
| max_humidity | Int |  |
| min_humidity | Int |  |

### targeting_type

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| line_id | Int | PK, FK |
| id | Int |  |
| is_targeted | Boolean |  |

### ad_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| line_id | Int | PK, FK |
| creative_id | Int | FK |
| media_type | String |  |
| name | String |  |
| status | String |  |

### creative_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| account_id | Int | FK |
| ad_choice_icon_location | String |  |
| ad_choices_enabled | Boolean |  |
| ad_type | String |  |
| creative_language | String |  |
| creative_tag_url | String |  |
| creative_type | String |  |
| is_third_party_code_secure | Boolean |  |
| landing_page_domain | String |  |
| landing_page_url | String |  |
| layout | String |  |
| mime_type | String |  |
| name | String |  |
| status | String |  |
| third_party_code | String |  |

### line_conversion_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| accept_view_through | Boolean |  |
| beacon_id | Int |  |
| beacon_value_pc | Double |  |
| click_window | Int |  |
| click_window_unit_type | String |  |
| name | String |  |
| view_beacon_value_discount | Double |  |
| view_window | Int |  |
| view_window_unit_type | String |  |

### creative_adx_categories

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK |
| creative_id | Int | PK, FK |

### audience_mail_event_text_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| audience_mail_event_id | Int | PK, FK |
| group_type | String |  |
| key | String |  |
| match_type | String |  |
| name | String |  |
| operator_type | String |  |
| value | String |  |

### targeting_geo

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| line_id | Int | PK, FK |
| code | String |  |
| description | String |  |
| excluded | Boolean |  |
| key | String |  |
| level | String |  |
| name | String |  |
| woeid | String |  |

### targeting_publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| line_id | Int | PK, FK |
| is_excluded | Boolean |  |
| name | String |  |

### audience_conversion_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| name | String |  |
| pixel_rule_id | Int |  |
| pixel_rule_name | String |  |
| pixel_rule_size | Long |  |
| status | String |  |

### audience_poi_custom_date_range

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| audience_poi_id | Int | PK, FK |
| end_date | LocalDate |  |
| start_date | LocalDate |  |

### audience_composite_exclude_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| composite_audience_id | Int | PK, FK |
| name | String |  |
| reach_count | Long |  |
| segment_type | String |  |
| status | String |  |

### audience_mail_domain_categories

| Column | Type | Keys |
| --- | --- | --- |
| audience_mail_domain_id | Int | PK, FK |
| id | Int | PK, FK |

### audience_lookalike_country

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| audience_lookalike_id | Int | PK, FK |

### audience_composite_include_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| composite_audience_id | Int | PK, FK |
| name | String |  |
| reach_count | Long |  |
| segment_type | String |  |
| status | String |  |

### line

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| order_id | Int | FK |
| package_id | Int | FK |
| app_id | String |  |
| app_locale | String |  |
| app_marketing_objective | String |  |
| app_url | String |  |
| bid_price | Double |  |
| billing_method_type | String |  |
| billing_price | Double |  |
| budget_type | String |  |
| completion_threshold | Int |  |
| goal_amount | Double |  |
| goal_mode_type | String |  |
| goal_type | String |  |
| is_native_enabled | Boolean |  |
| margin_goal | Double |  |
| margin_type | String |  |
| max_goal | Double |  |
| media_type | String |  |
| name | String |  |
| pacing_acceleration | Int |  |
| pacing_mode_type | String |  |
| status | String |  |

### order_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| campaign_updated_at | Instant | PK, FK |
| order_id | Int | PK, FK |
| pacing_type | String |  |
| period_multi_hour | Int |  |
| value_day | Int |  |
| value_hour | Int |  |
| value_minute | Int |  |
| value_month | Int |  |
| value_multi_hour | Int |  |
| value_week | Int |  |

### advertiser_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| seat_id | Int | FK |
| billing_price | Short |  |
| currency | String |  |
| iab_category_id | Int |  |
| iab_secondary_category_id | Int |  |
| is_crossdevice_off | Boolean |  |
| landing_page_url | String |  |
| name | String |  |
| status | String |  |
| time_zone | String |  |

### audience_lookalike

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| created_at | String |  |
| device_type | String |  |
| expected_size | Long |  |
| name | String |  |
| seed_audience_id | Int |  |
| seed_audience_name | String |  |
| seed_audience_type | String |  |
| status | String |  |

### seat

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| currency | String |  |
| name | String |  |
| time_zone | String |  |

### audience_srt_excluded_keyword

| Column | Type | Keys |
| --- | --- | --- |
| value | String | PK |
| audience_srt_id | Int | PK, FK |

### targeting_day_parting

| Column | Type | Keys |
| --- | --- | --- |
| day | String | PK |
| line_id | Int | PK, FK |
| hours | String |  |
| is_whole_day | Boolean |  |

### pixel_codes

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| pixel_id | Int | PK, FK |
| instrumentation_code | String |  |
| protocol | String |  |
| type | String |  |

### deal_account_group

| Column | Type | Keys |
| --- | --- | --- |
| account_group_id | Int | PK, FK |
| deal_id | Int | PK, FK |

### audience_device_id_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| audience_device_id | Int | PK, FK |
| created_date | Instant |  |
| duplicated | Int |  |
| error_message | String |  |
| fail_percentage | Double |  |
| status | String |  |
| total_failed | Int |  |
| total_ids | Int |  |
| type | String |  |

### targeting_contextuals_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| account_id | Int | PK, FK |
| line_id | Int | PK, FK |
| is_excluded | Boolean |  |
| name | String |  |
| taxonomy_type | String |  |

### audience_profile_location

| Column | Type | Keys |
| --- | --- | --- |
| continent | String | PK |
| country_name | String | PK |
| id | Int | PK |
| count | Long |  |
| unique_count | Long |  |

### audience_composite_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| clear_all_exclude | Boolean |  |
| name | String |  |
| people_count | Long |  |
| status | String |  |
| total_count | Long |  |

### audience_ip_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| created_at | LocalDate |  |
| name | String |  |
| retention_days | Int |  |
| status | String |  |

### audience_device_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | FK |
| created_at | LocalDate |  |
| is_device_only | Boolean |  |
| name | String |  |
| status | String |  |

### targeting_native_lists

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| created_at | Instant |  |
| is_excluded | Boolean |  |
| name | String |  |
| updated_at | Instant |  |

### audience_profile_age

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String | PK |
| count | Long |  |
| unique_count | Long |  |

### bid_multiplier_cap

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| bm_ad_learn_override | Boolean |  |
| multiplier_cap | Double |  |

### line_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| budget | Double |  |
| daily_budget | Double |  |
| daily_budget_type | String |  |
| end_date_str | Instant |  |
| imp_budget | Int |  |
| imp_daily_budget | Double |  |
| name | String |  |
| start_date_str | Instant |  |

### audience_poi_location_breadcrumb

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| audience_poi_location_id | Int | PK, FK |
| name | String |  |

### creative_user_interaction

| Column | Type | Keys |
| --- | --- | --- |
| action | String | PK |
| creative_id | Int | PK, FK |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| account_id | Int | PK, FK |
| name | String |  |

### audience_poi_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| has_children | Boolean |  |
| name | String |  |
| type | String |  |

### account_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| seat_id | Int | FK |
| code | String |  |
| name | String |  |

### audience_poi_targeting_rule_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Int | PK |
| audience_poi_id | Int | PK, FK |
| is_excluded | Boolean |  |

### site_list_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| site_list_id | Int | PK, FK |
| site_list_updated_at | Instant | PK, FK |
| item_name | String |  |

### audience_mail_domain_domains

| Column | Type | Keys |
| --- | --- | --- |
| domain | String | PK |
| audience_mail_domain_id | Int | PK, FK |

### targeting_site_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| created_at | Instant |  |
| is_excluded | Boolean |  |
| name | String |  |
| total_sites | Int |  |
| type | String |  |
| updated_at | Instant |  |

### targeting_dooh_venue_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| label | String |  |

### budget_schedule_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| campaign_id | Int | PK, FK |
| campaign_updated_at | Instant | PK, FK |
| budget_type | String |  |
| daily_budget | String |  |
| end_date | Instant |  |
| imp_budget | Int |  |
| imp_daily_budget | Int |  |
| schedule_budget | String |  |
| schedule_name | String |  |
| start_date | Instant |  |

### exchange

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String |  |

### creative_custom_identifier

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| creative_id | Int | PK, FK |
| identifier_value | String |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| order_id | Int | FK |
| billing_method_type | String |  |
| budget_distributor_enabled | Boolean |  |
| budget_type | String |  |
| channel_type | String |  |
| completion_threshold | Long |  |
| flighting_enabled | Boolean |  |
| goal_mode_type | String |  |
| goal_type | String |  |
| margin_type | String |  |
| media_type | String |  |
| name | String |  |
| objective | String |  |
| pacing_mode_type | String |  |
| package_language | String |  |
| status | String |  |
| supply_type | String |  |

### site_list_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| updated_at | Instant | PK |
| account_id | Int | FK |
| seat_id | Int | FK |
| is_shared | Boolean |  |
| name | String |  |
| status | String |  |
| type | String |  |

### user_group_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| user_group_id | Int | PK, FK |
| lower_bound | Int |  |
| name | String |  |
| traffic_percent | Int |  |
| upper_bound | Int |  |

### audience_mail_domain_all_categories

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| category | String |  |

### audience_profile_device

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| name | String | PK |
| count | Long |  |
| unique_count | Long |  |

### contextual_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Int | PK |
| id | Int | PK |
| contextual_id | Int | PK, FK |
| contextual_updated_at | Instant | PK, FK |

### audience_composite_fees

| Column | Type | Keys |
| --- | --- | --- |
| currency | String | PK |
| fee_media_type | String | PK |
| composite_audience_id | Int | PK, FK |
| fee | Double |  |

### bid_multiplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| line_id | Int | PK, FK |
| is_app_name | Boolean |  |
| multiplier | Double |  |
| target_domain | String |  |
| target_type | String |  |
| target_value_city | String |  |
| target_value_country | String |  |
| target_value_day | String |  |
| target_value_dma_code | String |  |
| target_value_hour | Int |  |
| target_value_id | Int |  |
| target_value_locality | String |  |
| target_value_major_metro_area | String |  |
| target_value_postal_code | String |  |
| target_value_postal_code_prefix | String |  |
| target_value_region | String |  |
| target_value_sub_locality | String |  |
| target_value_text | String |  |

### package_user_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| package_id | Int | PK, FK |
| period_multi_hour | Long |  |
| value_day | Long |  |
| value_hour | Long |  |
| value_minute | Long |  |
| value_month | Long |  |
| value_multi_hour | Long |  |
| value_week | Long |  |

### advertiser_billing_contact

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Int | PK, FK |
| address_line_1 | String |  |
| address_line_2 | String |  |
| address_line_3 | String |  |
| city | String |  |
| country | String |  |
| email | String |  |
| first_name | String |  |
| last_name | String |  |
| legal_mandate_confirmation | String |  |
| postal_code | String |  |
| region | String |  |
| telephone | String |  |
| vat_number | String |  |

### package_household_frequency_cap

| Column | Type | Keys |
| --- | --- | --- |
| package_id | Int | PK, FK |
| enabled | Boolean |  |
| period_multi_hour | Long |  |
| value_day | Long |  |
| value_hour | Long |  |
| value_minute | Long |  |
| value_month | Long |  |
| value_multi_hour | Long |  |
| value_week | Long |  |

## Relationships

- beacon_condition(beacon_id) → beacon_history(id)
- beacon_condition(beacon_updated_at) → beacon_history(id)
- beacon_history(account_id) → advertiser_history(id)
- beacon_history(pixel_id) → pixel(id)
- beacon_history(seat_id) → seat(id)
- campaign_history(account_id) → advertiser_history(id)
- package_schedule(package_id) → package(id)
- ad_countdown_history(ad_id) → ad_history(id)
- ad_countdown_history(ad_updated_at) → ad_history(id)
- advertiser_contact(account_id) → advertiser_history(id)
- creative_details_media(creative_id) → creative_history(id)
- audience_poi_targeting_rule_chain(audience_poi_id) → audience_poi(id)
- deal_account(deal_id) → deal(id)
- deal_account(account_id) → advertiser_history(id)
- audience_poi(account_id) → advertiser_history(id)
- audience_poi(seat_id) → seat(id)
- contextual_category_by_taxonomy_type(parent_category_id) → contextual_category_by_taxonomy_type(id)
- audience_ip_address_history(audience_ip_address_id) → audience_ip_address(id)
- audience_srt_included_keyword(audience_srt_id) → audience_srt(id)
- deal(exchange_id) → exchange(id)
- deal(account_group_id) → account_group(id)
- creative_impression_tracking(creative_id) → creative_history(id)
- audience_poi_targeting_rule_gid(audience_poi_id) → audience_poi(id)
- targeting_ab_testing(line_id) → line(id)
- targeting_ab_testing(user_group_id) → user_group(id)
- creative_details(creative_id) → creative_history(id)
- line_fee_list(line_id) → line(id)
- creative_expand_direction(creative_id) → creative_history(id)
- ad_schedule_history(ad_id) → ad_history(id)
- ad_schedule_history(ad_updated_at) → ad_history(id)
- audience_mail_event(account_id) → advertiser_history(id)
- audience_mail_event(seat_id) → seat(id)
- audience_mail_event_time_attribute(audience_mail_event_id) → audience_mail_event(id)
- targeting_frequency_capping(line_id) → line(id)
- creative_companion_banner(creative_id) → creative_history(id)
- targeting_demographic(line_id) → line(id)
- targeting_segment(line_id) → line(id)
- audience_mail_domain(seat_id) → seat(id)
- audience_mail_domain(account_id) → advertiser_history(id)
- audience_email_address(account_id) → advertiser_history(id)
- targeting_deal(line_id) → line(id)
- targeting_deal(exchange_id) → exchange(id)
- targeting_deal(exchange_deal_id) → deal(id)
- beacon_instrumentation_code(beacon_id) → beacon_history(id)
- beacon_instrumentation_code(pixel_id) → pixel(id)
- contextual_history(account_id) → advertiser_history(id)
- contextual_history(seat_id) → seat(id)
- audience_email_address_history(audience_email_address_id) → audience_email_address(id)
- targeting_weather_temperature(line_id) → line(id)
- pixel(account_id) → advertiser_history(id)
- targeting_dooh_screen_owner(line_id) → line(id)
- audience_mail_domain_excluded_domains(audience_mail_domain) → audience_mail_domain(id)
- audience_srt(seat_id) → seat(id)
- audience_srt(account_id) → advertiser_history(id)
- audience_poi_targeting_rule_woeid(audience_poi_id) → audience_poi(id)
- targeting_weather_humidity(line_id) → line(id)
- targeting_type(line_id) → line(id)
- ad_history(line_id) → line(id)
- ad_history(creative_id) → creative_history(id)
- creative_history(account_id) → advertiser_history(id)
- line_conversion_list(line_id) → line(id)
- creative_adx_categories(creative_id) → creative_history(id)
- audience_mail_event_text_attribute(audience_mail_event_id) → audience_mail_event(id)
- targeting_geo(line_id) → line(id)
- targeting_publisher(line_id) → line(id)
- audience_conversion_rule(account_id) → advertiser_history(id)
- audience_poi_custom_date_range(audience_poi_id) → audience_poi(id)
- audience_composite_exclude_segment(composite_audience_id) → audience_composite_list(id)
- audience_mail_domain_categories(id) → audience_mail_domain_all_categories(id)
- audience_mail_domain_categories(audience_mail_domain_id) → audience_mail_domain(id)
- audience_lookalike_country(audience_lookalike_id) → audience_lookalike(id)
- audience_composite_include_segment(composite_audience_id) → audience_composite_list(id)
- line(order_id) → campaign_history(id)
- line(package_id) → package(id)
- order_frequency_cap(order_id) → campaign_history(id)
- order_frequency_cap(campaign_updated_at) → campaign_history(id)
- advertiser_history(seat_id) → seat(id)
- audience_lookalike(account_id) → advertiser_history(id)
- audience_srt_excluded_keyword(audience_srt_id) → audience_srt(id)
- targeting_day_parting(line_id) → line(id)
- pixel_codes(pixel_id) → pixel(id)
- deal_account_group(deal_id) → deal(id)
- deal_account_group(account_group_id) → account_group(id)
- audience_device_id_history(audience_device_id) → audience_device_id(id)
- targeting_contextuals_history(line_id) → line(id)
- targeting_contextuals_history(account_id) → advertiser_history(id)
- audience_composite_list(account_id) → advertiser_history(id)
- audience_composite_list(seat_id) → seat(id)
- audience_ip_address(account_id) → advertiser_history(id)
- audience_device_id(account_id) → advertiser_history(id)
- targeting_native_lists(line_id) → line(id)
- bid_multiplier_cap(line_id) → line(id)
- line_schedule(line_id) → line(id)
- audience_poi_location_breadcrumb(audience_poi_location_id) → audience_poi_location(id)
- creative_user_interaction(creative_id) → creative_history(id)
- user_group(account_id) → advertiser_history(id)
- account_group(seat_id) → seat(id)
- audience_poi_targeting_rule_category(audience_poi_id) → audience_poi(id)
- site_list_item(site_list_id) → site_list_history(id)
- site_list_item(site_list_updated_at) → site_list_history(id)
- audience_mail_domain_domains(audience_mail_domain_id) → audience_mail_domain(id)
- targeting_site_list(line_id) → line(id)
- targeting_dooh_venue_type(line_id) → line(id)
- budget_schedule_history(campaign_id) → campaign_history(id)
- budget_schedule_history(campaign_updated_at) → campaign_history(id)
- creative_custom_identifier(creative_id) → creative_history(id)
- package(order_id) → campaign_history(id)
- site_list_history(account_id) → advertiser_history(id)
- site_list_history(seat_id) → seat(id)
- user_group_entity(user_group_id) → user_group(id)
- contextual_category(contextual_id) → contextual_history(id)
- contextual_category(contextual_updated_at) → contextual_history(id)
- audience_composite_fees(composite_audience_id) → audience_composite_list(id)
- bid_multiplier(line_id) → line(id)
- package_user_frequency_cap(package_id) → package(id)
- advertiser_billing_contact(account_id) → advertiser_history(id)
- package_household_frequency_cap(package_id) → package(id)