# ironSource schema ERD

Table and field reference for the Fivetran ironSource connector.

## Table & Field Reference

### audience

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bundle_id | Unknown |  |
| description | Unknown |  |
| has_active_campaigns | Unknown |  |
| last_modified | Unknown |  |
| name | Unknown |  |
| platform | Unknown |  |
| type | Unknown |  |

### bidding

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_report_fivetran_id | Unknown | FK |
| application_id | Unknown |  |
| bid | Unknown |  |
| country | Unknown |  |

### title

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown |  |
| bundle_id | Unknown |  |
| name | Unknown |  |
| operating_system | Unknown |  |

### creative_asset

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| title_id | Unknown | FK |
| usage_type | Unknown |  |

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title_id | Unknown | FK |
| languages | Unknown |  |
| name | Unknown |  |
| orientation | Unknown |  |
| type | Unknown |  |

### campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_unit_name | Unknown |  |
| application_name | Unknown |  |
| campaign_name | Unknown |  |
| clicks | Unknown |  |
| completions | Unknown |  |
| country | Unknown |  |
| creative_name | Unknown |  |
| date | Unknown |  |
| device_type | Unknown |  |
| id | Unknown |  |
| impressions | Unknown |  |
| os | Unknown |  |
| spend | Unknown |  |
| title_name | Unknown |  |

### application

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_name | Unknown |  |
| app_status | Unknown |  |
| bundle_id | Unknown |  |
| bundle_ref_id | Unknown |  |
| ccpa | Unknown |  |
| coppa | Unknown |  |
| creation_date | Unknown |  |
| icon | Unknown |  |
| network_reporting_api_iron_source | Unknown |  |
| platform | Unknown |  |
| taxonomy | Unknown |  |

### application_advertising_unit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| application_id | Unknown | FK |
| active_network_name | Unknown |  |
| type | Unknown |  |

### placement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_id | Unknown | PK, FK |
| ab_version | Unknown |  |
| ad_delivery | Unknown |  |
| ad_unit | Unknown |  |
| capping_enabled | Unknown |  |
| capping_interval | Unknown |  |
| capping_limit | Unknown |  |
| name | Unknown |  |
| pacing_enabled | Unknown |  |
| pacing_minutes | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title_id | Unknown | FK |
| duration | Unknown |  |
| name | Unknown |  |
| orientation | Unknown |  |
| source | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### mediation_group_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_id | Unknown | PK, FK |
| mediation_group_id | Unknown | PK, FK |
| country | Unknown |  |

### mediation_group_instance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_id | Unknown | PK, FK |
| mediation_group_id | Unknown | PK, FK |
| countries_rate | Json |  |
| group_rate | Unknown |  |
| is_bidder | Unknown |  |
| name | Unknown |  |
| network_name | Unknown |  |

### mediation_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_id | Unknown | PK, FK |
| ab_test | Unknown |  |
| ad_format | Unknown |  |
| floor_price | Unknown |  |
| group_name | Unknown |  |
| mediation_ad_unit_name | Unknown |  |
| mediation_unit_id | Unknown |  |
| position | Unknown |  |
| segments | Json |  |

## Relationships

- bidding(campaign_report_fivetran_id) → campaign_report(_fivetran_id)
- creative_asset(id) → asset(id)
- creative_asset(title_id) → title(id)
- creative_asset(creative_id) → creative(id)
- creative(title_id) → title(id)
- application_advertising_unit(application_id) → application(id)
- placement(application_id) → application(id)
- asset(title_id) → title(id)
- mediation_group_country(application_id) → mediation_group(application_id)
- mediation_group_country(mediation_group_id) → mediation_group(id)
- mediation_group_instance(application_id) → mediation_group(application_id)
- mediation_group_instance(mediation_group_id) → mediation_group(id)
- mediation_group(application_id) → application(id)