# Smadex schema ERD

Table and field reference for the Fivetran Smadex connector.

## Table & Field Reference

### line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| bidding_status | Unknown |  |
| list_type | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### line_limit

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK, FK |
| budget_daily | Unknown |  |
| budget_hourly | Unknown |  |
| budget_total | Unknown |  |
| clicks_daily | Unknown |  |
| clicks_hourly | Unknown |  |
| clicks_total | Unknown |  |
| conversions_daily | Unknown |  |
| conversions_hourly | Unknown |  |
| conversions_total | Unknown |  |
| impressions_daily | Unknown |  |
| impressions_hourly | Unknown |  |
| impressions_total | Unknown |  |

### line_test

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ab_test_id | Unknown | PK, FK |
| line_id | Unknown |  |
| option_volume | Unknown |  |
| test_id | Unknown |  |

### ab_test

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### lines_bulk

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| name | Unknown |  |
| optimization_goal | Unknown |  |

### line_core

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_id | Unknown | FK |
| adops_manager_id | Unknown |  |
| adops_manager_name | Unknown |  |
| agency_id | Unknown |  |
| agency_name | Unknown |  |
| app_bundle | Unknown |  |
| audit_status | Unknown |  |
| category | Unknown |  |
| domain | Unknown |  |
| effective_landing_url | Unknown |  |
| label_1 | Unknown |  |
| label_2 | Unknown |  |
| label_3 | Unknown |  |
| name | Unknown |  |
| schedule_end_date | Unknown |  |
| schedule_start_date | Unknown |  |
| status | Unknown |  |
| tracking_group | Unknown |  |

### audience

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| audience_type | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| created_at | Unknown |  |
| dmp | Unknown |  |
| dmp_id | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| number_of_users | Unknown |  |
| os | Unknown |  |
| price | Unknown |  |
| score | Unknown |  |
| status | Unknown |  |
| type_code | Unknown |  |
| type_description | Unknown |  |
| type_name | Unknown |  |
| updated_at | Unknown |  |

### line_geo_targeting

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK, FK |
| cities_allow_list | Json |  |
| cities_deny_list | Json |  |
| countries | Json |  |
| enhanced_geo_accuracy | Unknown |  |
| precision | Unknown |  |
| radius | Unknown |  |

### line_algorithm

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK, FK |
| bidding_algorithm_event_group | Unknown |  |
| bidding_algorithm_objective | Unknown |  |
| bidding_algorithm_objective_price | Unknown |  |
| filter_algorithm | Json |  |

### line_daypart

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| line_id | Unknown | PK, FK |
| day | Unknown |  |
| hour_end | Unknown |  |
| hour_start | Unknown |  |
| min_end | Unknown |  |
| min_start | Unknown |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| account_name | Unknown |  |
| created_at | Unknown |  |
| is_exclusive | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### permission

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| entity_id | Unknown |  |
| headless | Unknown |  |
| mfa_enabled | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| folder_id | Unknown | FK |
| attribute | Json |  |
| audit_status | String |  |
| click_tracking | Unknown |  |
| click_url | Unknown |  |
| cta | Unknown |  |
| cta_text | Unknown |  |
| description | Unknown |  |
| designed_by_smadex | Unknown |  |
| duration | Unknown |  |
| endcard_cta_text | Unknown |  |
| endcard_has_cta | Unknown |  |
| endcard_is_last_frame | Unknown |  |
| endcard_is_tricky | Unknown |  |
| endcard_type | Unknown |  |
| format | Unknown |  |
| has_cta | Unknown |  |
| icon | Unknown |  |
| icon_height | Unknown |  |
| icon_weight | Unknown |  |
| icon_width | Unknown |  |
| image | Unknown |  |
| image_height | Unknown |  |
| image_name | String |  |
| image_width | Unknown |  |
| impression_pixel | Json |  |
| is_ssl | Unknown |  |
| label | Json |  |
| lookalike_identifier | Unknown |  |
| name | Unknown |  |
| original_creative_id | Unknown |  |
| rating | Unknown |  |
| rewarded | Unknown |  |
| short_description | Unknown |  |
| size | Unknown |  |
| sponsored | Unknown |  |
| ssl_compliant | Unknown |  |
| status | Unknown |  |
| style | Unknown |  |
| tags | Unknown |  |
| theme | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### line_publisher_scan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| line_id | Unknown | PK, FK |
| attribution | Unknown |  |
| budget | Unknown |  |
| click | Unknown |  |
| enabled | Unknown |  |
| event | Unknown |  |
| impression | Unknown |  |
| min_event | Unknown |  |
| should_reset | Unknown |  |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| all_creatives_paused | Unknown |  |
| bidding_status | Unknown |  |
| expires_at | Unknown |  |
| name | Unknown |  |
| number_of_creatives | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| week_day_friday | Unknown |  |
| week_day_monday | Unknown |  |
| week_day_saturday | Unknown |  |
| week_day_sunday | Unknown |  |
| week_day_thursday | Unknown |  |
| week_day_tuesday | Unknown |  |
| week_day_wednesday | Unknown |  |

### fixed_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| user_event | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| advertiser_domain | Unknown |  |
| alternate_domain | Unknown |  |
| app_bundle | Unknown |  |
| area_id | Unknown |  |
| budget_daily_cap | Unknown |  |
| budget_delivered | Unknown |  |
| budget_hourly_cap | Unknown |  |
| budget_total_cap | Unknown |  |
| campaign_manager_id | Unknown |  |
| category | Unknown |  |
| created_at | Unknown |  |
| expires_at | Unknown |  |
| goal | Unknown |  |
| goal_description | Unknown |  |
| goal_event_name | Unknown |  |
| label_1 | Unknown |  |
| label_2 | Unknown |  |
| landing_url | Unknown |  |
| limit_conversation_action | Unknown |  |
| limit_daily_max_conversation | Unknown |  |
| limit_daily_spent_conversation | Unknown |  |
| name | Unknown |  |
| numeric_goal | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| training_enabled | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### exchange

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| admin_email | Unknown |  |
| auction_type | Unknown |  |
| bid_below_pf | Unknown |  |
| bidloss_active | Unknown |  |
| capability | Unknown |  |
| consent_policy | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| display_name | Unknown |  |
| financial_entity_id | Unknown |  |
| group_name | Unknown |  |
| is_active | Unknown |  |
| logo | Unknown |  |
| price_floor | Unknown |  |
| s_2_s | Unknown |  |
| skoverlay_supported | Unknown |  |
| updated_at | Unknown |  |
| visible | Unknown |  |
| win_url_beacon | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| description | Unknown |  |
| id | Unknown |  |
| lang | Unknown |  |
| name | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agency_id | Unknown |  |
| agency_name | Unknown |  |
| campaign_count | Unknown |  |
| created_at | Unknown |  |
| currency_tag | Unknown |  |
| enforce | Unknown |  |
| name | Unknown |  |
| organization | Unknown |  |
| revenue | Unknown |  |
| top_up | Unknown |  |
| unlimited | Unknown |  |

### line_targeting_device_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| line_id | Unknown | PK, FK |
| os_name | Unknown |  |
| type | Unknown |  |

### line_device_targeting

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK, FK |
| ad_positions | Json |  |
| browsers | Json |  |
| carrier_allow_list | Json |  |
| carrier_deny_list | Json |  |
| connection_type | Unknown |  |
| device_model_allow_list | Json |  |
| device_model_deny_list | Json |  |
| frequency_capping_campaign_mode | Unknown |  |
| frequency_capping_deterministic_mode | Json |  |
| frequency_capping_hits | Unknown |  |
| frequency_capping_mode | Unknown |  |
| frequency_capping_period | Unknown |  |
| frequency_capping_probabilistic_mode | Json |  |
| interstitial | Unknown |  |
| languages | Json |  |
| line_request_filter_asset_type | Unknown |  |
| line_request_filter_device_id_restriction | Unknown |  |
| os_version_ranges | Json |  |
| placement_ids | Json |  |
| rewarded | Unknown |  |
| skad_network | Unknown |  |
| skad_versions | Json |  |
| skad_vta_mandatory | Unknown |  |
| skippability_non_skippable | Unknown |  |
| skippability_skippable | Unknown |  |
| skippability_unknown | Unknown |  |
| traffic_type | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| campaign_id | Unknown | FK |
| creative_id | Unknown | FK |
| line_id | Unknown | FK |
| account_name | Unknown |  |
| ad_campaign_id | Unknown |  |
| ad_campaign_name | Unknown |  |
| advertiser_bundle | Unknown |  |
| advertiser_domain | Unknown |  |
| agency_id | Unknown |  |
| agency_name | Unknown |  |
| buys | Unknown |  |
| buys_rate | Unknown |  |
| clicks | Unknown |  |
| completed_views | Unknown |  |
| completed_views_rate | Unknown |  |
| country | Unknown |  |
| cp_buys | Unknown |  |
| cp_completed_views | Unknown |  |
| cp_first_quartile_views | Unknown |  |
| cp_funnel_step_1 | Unknown |  |
| cp_funnel_step_2 | Unknown |  |
| cp_funnel_step_3 | Unknown |  |
| cp_installs | Unknown |  |
| cp_landings | Unknown |  |
| cp_mid_point_views | Unknown |  |
| cp_other_conversions | Unknown |  |
| cp_registrations | Unknown |  |
| cp_skips | Unknown |  |
| cp_subscriptions | Unknown |  |
| cp_third_quartile_views | Unknown |  |
| cp_views | Unknown |  |
| cpc | Unknown |  |
| cpm | Unknown |  |
| creative_name | Unknown |  |
| creative_url | Unknown |  |
| ctr | Unknown |  |
| currency | Unknown |  |
| date_time | Unknown |  |
| device_os | Unknown |  |
| exchange_name | Unknown |  |
| first_quartile_views | Unknown |  |
| first_quartile_views_rate | Unknown |  |
| funnel_step_1 | Unknown |  |
| funnel_step_1_rate | Unknown |  |
| funnel_step_2 | Unknown |  |
| funnel_step_2_rate | Unknown |  |
| funnel_step_3 | Unknown |  |
| funnel_step_3_rate | Unknown |  |
| impressions | Unknown |  |
| installs | Unknown |  |
| installs_rate | Unknown |  |
| inventory_bundle | Unknown |  |
| inventory_domain | Unknown |  |
| inventory_id | Unknown |  |
| inventory_key | Unknown |  |
| inventory_name | Unknown |  |
| landings | Unknown |  |
| landings_rate | Unknown |  |
| media_spend | Unknown |  |
| mid_point_views | Unknown |  |
| mid_point_views_rate | Unknown |  |
| other_conversions | Unknown |  |
| other_conversions_rate | Unknown |  |
| registrations | Unknown |  |
| registrations_rate | Unknown |  |
| skips_rate | Unknown |  |
| subscriptions | Unknown |  |
| subscriptions_rate | Unknown |  |
| third_party_spend | Unknown |  |
| third_quartile_views | Unknown |  |
| third_quartile_views_rate | Unknown |  |
| total_spend | Unknown |  |
| views | Unknown |  |
| views_rate | Unknown |  |

## Relationships

- line(campaign_id) → campaign(id)
- line(list_id) → list(id)
- line_limit(line_id) → line(id)
- line_test(ab_test_id) → ab_test(id)
- ab_test(account_id) → account(id)
- lines_bulk(campaign_id) → campaign(id)
- line_core(id) → line(id)
- line_core(account_id) → account(id)
- audience(account_id) → account(id)
- line_geo_targeting(line_id) → line(id)
- line_algorithm(line_id) → line(id)
- line_daypart(line_id) → line(id)
- list(account_id) → account(id)
- permission(users_id) → users(id)
- creative(folder_id) → folder(id)
- creative(account_id) → account(id)
- line_publisher_scan(line_id) → line(id)
- folder(account_id) → account(id)
- fixed_event(campaign_id) → campaign(id)
- campaign(account_id) → account(id)
- line_targeting_device_list(line_id) → line_device_targeting(line_id)
- line_device_targeting(line_id) → line(id)
- report(line_id) → line(id)
- report(creative_id) → creative(id)
- report(account_id) → account(id)
- report(campaign_id) → campaign(id)