# Awin schema ERD

Table and field reference for the Fivetran Awin connector.

## Table & Field Reference

### reports_aggregated_by_campaign

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | PK, FK |
| publisher_id | Unknown | FK |
| campaign | Unknown |  |
| commission_amount_approved | Unknown |  |
| commission_amount_bonus | Unknown |  |
| commission_amount_declined | Unknown |  |
| commission_amount_pending | Unknown |  |
| commission_amount_total | Unknown |  |
| date | Unknown |  |
| end_date | Unknown |  |
| publisher_name | Unknown |  |
| quantity_approved | Unknown |  |
| quantity_bonus | Unknown |  |
| quantity_click | Unknown |  |
| quantity_declined | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_total | Unknown |  |
| sale_amount_approved | Unknown |  |
| sale_amount_bonus | Unknown |  |
| sale_amount_declined | Unknown |  |
| sale_amount_pending | Unknown |  |
| sale_amount_total | Unknown |  |
| start_date | Unknown |  |

### reports_aggregated_by_creative

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | FK |
| publisher_id | Unknown | FK |
| advertiser_name | Unknown |  |
| bonus_commission | Unknown |  |
| bonus_number | Unknown |  |
| bonus_value | Unknown |  |
| click | Unknown |  |
| confirmed_commission | Unknown |  |
| confirmed_number | Unknown |  |
| confirmed_value | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| currency | Unknown |  |
| declined_commission | Unknown |  |
| declined_number | Unknown |  |
| declined_value | Unknown |  |
| impression | Unknown |  |
| pending_commission | Unknown |  |
| pending_number | Unknown |  |
| pending_value | Unknown |  |
| publisher_name | Unknown |  |
| region | Unknown |  |
| tag_name | Unknown |  |
| total_commission | Unknown |  |
| total_number | Unknown |  |
| total_value | Unknown |  |

### publisher_transaction_query

| Column | Type | Keys |
| --- | --- | --- |
| enquiry_id | Unknown | PK |
| publisher_id | Unknown | PK, FK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| click_ref | Unknown |  |
| commission_amount | Unknown |  |
| commission_currency | Unknown |  |
| decline_reason | Unknown |  |
| description | Unknown |  |
| enquiry_date | Unknown |  |
| enquiry_status | Unknown |  |
| enquiry_type | Unknown |  |
| order_ref | Unknown |  |
| sale_amount | Unknown |  |
| sale_currency | Unknown |  |
| transaction_date | Unknown |  |
| validation_date | Unknown |  |

### reports_aggregated_by_publisher

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown | FK |
| publisher_id | Unknown | FK |
| advertiser_name | Unknown |  |
| bonus_commission | Unknown |  |
| bonus_number | Unknown |  |
| bonus_value | Unknown |  |
| click | Unknown |  |
| confirmed_commission | Unknown |  |
| confirmed_number | Unknown |  |
| confirmed_value | Unknown |  |
| currency | Unknown |  |
| declined_commission | Unknown |  |
| declined_number | Unknown |  |
| declined_value | Unknown |  |
| impression | Unknown |  |
| pending_commission | Unknown |  |
| pending_number | Unknown |  |
| pending_value | Unknown |  |
| publisher_name | Unknown |  |
| region | Unknown |  |
| tags | Json |  |
| total_commission | Unknown |  |
| total_number | Unknown |  |
| total_value | Unknown |  |

### publisher_tracked_part

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| publisher_transaction_id | Unknown | PK, FK |
| publisher_transaction_part_commission_group_id | Unknown | PK, FK |
| amount | Unknown |  |
| code | Unknown |  |
| currency | Unknown |  |

### publisher_transaction_part

| Column | Type | Keys |
| --- | --- | --- |
| commission_group_id | Unknown | PK |
| publisher_transaction_id | Unknown | PK, FK |
| amount | Unknown |  |
| commission_amount | Unknown |  |
| commission_group_code | Unknown |  |
| commission_group_name | Unknown |  |

### publisher_custom_parameter

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| publisher_transaction_id | Unknown | PK, FK |
| value | Unknown |  |

### publisher_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| publisher_id | Unknown | FK |
| advertiser_country | Unknown |  |
| amend_reason | Unknown |  |
| amended | Unknown |  |
| campaign | Unknown |  |
| click_date | Unknown |  |
| click_device | Unknown |  |
| commission_amount | Unknown |  |
| commission_currency | Unknown |  |
| commission_sharing_publisher_id | Unknown |  |
| commission_sharing_selected_rate_publisher_id | Unknown |  |
| commission_status | Unknown |  |
| customer_country | Unknown |  |
| decline_reason | Unknown |  |
| ip_hash | Unknown |  |
| lapse_time | Unknown |  |
| old_commission_amount | Unknown |  |
| old_sale_amount | Unknown |  |
| order_ref | Unknown |  |
| original_sale_amount | Unknown |  |
| paid_to_publisher | Unknown |  |
| payment_id | Unknown |  |
| publisher_url | Unknown |  |
| sale_amount | Unknown |  |
| sale_currency | Unknown |  |
| site_name | Unknown |  |
| transaction_date | Unknown |  |
| transaction_device | Unknown |  |
| transaction_query_id | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| validation_date | Unknown |  |
| voucher_code | Unknown |  |
| voucher_code_used | Unknown |  |
| custom_** |  |  |

### advertiser_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown |  |
| account_type | Unknown |  |
| user_role | Unknown |  |

### sales_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| publisher_id | Unknown | PK, FK |
| sales_region | Unknown |  |

### publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_account_id | Unknown | PK, FK |
| name | Unknown |  |
| primary_region | Unknown |  |
| primary_type | Unknown |  |

### basket_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| category | Unknown |  |
| commission_group_code | Unknown |  |
| product_name | Unknown |  |
| quantity | Unknown |  |
| sku_code | Unknown |  |
| unit_price | Unknown |  |

### tracked_part

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| transaction_part_commission_group_id | Unknown | PK, FK |
| amount | Unknown |  |
| code | Unknown |  |
| currency | Unknown |  |

### transaction_part

| Column | Type | Keys |
| --- | --- | --- |
| commission_group_id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| advertiser_cost | Unknown |  |
| amount | Unknown |  |
| commission_amount | Unknown |  |
| commission_group_code | Unknown |  |
| commission_group_name | Unknown |  |

### custom_parameter

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| value | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| publisher_id | Unknown | FK |
| advertiser_cost_amount | Unknown |  |
| advertiser_cost_currency | Unknown |  |
| advertiser_country | Unknown |  |
| amend_reason | Unknown |  |
| amended | Unknown |  |
| campaign | Unknown |  |
| click_date | Unknown |  |
| click_device | Unknown |  |
| click_ref | Unknown |  |
| commission_amount | Unknown |  |
| commission_currency | Unknown |  |
| commission_sharing_publisher_id | Unknown |  |
| commission_sharing_selected_rate_publisher_id | Unknown |  |
| commission_status | Unknown |  |
| customer_acquisition | Unknown |  |
| customer_country | Unknown |  |
| decline_reason | Unknown |  |
| ip_hash | Unknown |  |
| lapse_time | Unknown |  |
| network_fee_amount | Unknown |  |
| network_fee_currency | Unknown |  |
| old_commission_amount | Unknown |  |
| old_sale_amount | Unknown |  |
| order_ref | Unknown |  |
| original_sale_amount | Unknown |  |
| paid_to_publisher | Unknown |  |
| payment_id | Unknown |  |
| publisher_url | Unknown |  |
| sale_amount | Unknown |  |
| sale_currency | Unknown |  |
| site_name | Unknown |  |
| tracked_amount | Unknown |  |
| tracked_currency | Unknown |  |
| transaction_date | Unknown |  |
| transaction_device | Unknown |  |
| transaction_query_id | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| validation_date | Unknown |  |
| voucher_code | Unknown |  |
| voucher_code_used | Unknown |  |

### publisher_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown |  |
| account_type | Unknown |  |
| user_role | Unknown |  |

## Relationships

- reports_aggregated_by_campaign(publisher_id) → publisher(id)
- reports_aggregated_by_campaign(advertiser_id) → advertiser_account(id)
- reports_aggregated_by_creative(advertiser_id) → advertiser_account(id)
- reports_aggregated_by_creative(publisher_id) → publisher(id)
- publisher_transaction_query(publisher_id) → publisher_account(id)
- reports_aggregated_by_publisher(advertiser_id) → advertiser_account(id)
- reports_aggregated_by_publisher(publisher_id) → publisher(id)
- publisher_tracked_part(publisher_transaction_id) → publisher_transaction_part(publisher_transaction_id)
- publisher_tracked_part(publisher_transaction_part_commission_group_id) → publisher_transaction_part(commission_group_id)
- publisher_transaction_part(publisher_transaction_id) → publisher_transaction(id)
- publisher_custom_parameter(publisher_transaction_id) → publisher_transaction(id)
- publisher_transaction(advertiser_id) → advertiser_account(id)
- publisher_transaction(publisher_id) → publisher_account(id)
- sales_region(publisher_id) → publisher(id)
- publisher(advertiser_account_id) → advertiser_account(id)
- basket_product(transaction_id) → transaction(id)
- tracked_part(transaction_id) → transaction_part(transaction_id)
- tracked_part(transaction_part_commission_group_id) → transaction_part(commission_group_id)
- transaction_part(transaction_id) → transaction(id)
- custom_parameter(transaction_id) → transaction(id)
- transaction(advertiser_id) → advertiser_account(id)
- transaction(publisher_id) → publisher(id)