# Impact Partner schema ERD

Table and field reference for the Fivetran Impact Partner connector.

## Table & Field Reference

### action_update

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action_id | Unknown | PK, FK |
| action_date | Unknown |  |
| action_tracker_id | Unknown |  |
| action_uri | Unknown |  |
| ad_id | Unknown |  |
| campaign_id | Unknown |  |
| catalog_category | Unknown |  |
| catalog_description | Unknown |  |
| catalog_manufacturer | Unknown |  |
| catalog_name | Unknown |  |
| catalog_original_format_category | Unknown |  |
| catalog_sub_category | Unknown |  |
| category | Unknown |  |
| clearing_date | Unknown |  |
| contract_id | Unknown |  |
| currency | Unknown |  |
| default_payout | Unknown |  |
| default_payout_currency | Unknown |  |
| delta_amount | Unknown |  |
| delta_payout | Unknown |  |
| event_code | Unknown |  |
| event_type_id | Unknown |  |
| event_type_name | Unknown |  |
| locking_date | Unknown |  |
| o_id | Unknown |  |
| payout_level | Unknown |  |
| paystub_id | Unknown |  |
| quantity | Unknown |  |
| reporting_state | Unknown |  |
| shared_id | Unknown |  |
| sku | Unknown |  |
| state | Unknown |  |
| state_detail | Unknown |  |
| state_detail_description | Unknown |  |
| sub_category | Unknown |  |
| sub_id_1 | Unknown |  |
| sub_id_2 | Unknown |  |
| sub_id_3 | Unknown |  |
| update_date | Unknown |  |
| uri | Unknown |  |

### catalog_item_promotion

| Column | Type | Keys |
| --- | --- | --- |
| catalog_id | Unknown | PK, FK |
| catalog_item_id | Unknown | PK, FK |
| promotion_id | Unknown | PK, FK |

### catalog_item_advertiser_format_categorogies

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_id | Unknown | PK, FK |
| catalog_item_id | Unknown | PK, FK |
| advertiser_format_categories | Unknown |  |

### catalog_item_color

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_id | Unknown | PK, FK |
| catalog_item_id | Unknown | PK, FK |
| colors | Unknown |  |

### catalog_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| catalog_id | Unknown | PK, FK |
| additional_image_url | Json |  |
| adult | Unknown |  |
| age_group | Unknown |  |
| age_range_max | Unknown |  |
| age_range_min | Unknown |  |
| age_range_unit | Unknown |  |
| asin | Unknown |  |
| bullet | Json |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| catalog_item_id | Unknown |  |
| category | Unknown |  |
| condition | Unknown |  |
| currency | Unknown |  |
| current_price | Unknown |  |
| description | Unknown |  |
| discount_percentage | Unknown |  |
| estimated_ship_date | Unknown |  |
| expiration_date | Unknown |  |
| gender | Unknown |  |
| gtin | Unknown |  |
| gtin_type | Unknown |  |
| image_url | Unknown |  |
| is_parent | Unknown |  |
| item_group_id | Unknown |  |
| label | Json |  |
| launch_date | Unknown |  |
| manufacturer | Unknown |  |
| material | Unknown |  |
| mobile_url | Unknown |  |
| money_1 | Unknown |  |
| money_2 | Unknown |  |
| money_3 | Unknown |  |
| mpn | Unknown |  |
| multi_pack | Unknown |  |
| name | Unknown |  |
| numeric_1 | Unknown |  |
| numeric_2 | Unknown |  |
| numeric_3 | Unknown |  |
| original_format_category | Unknown |  |
| original_format_category_id | Unknown |  |
| original_price | Unknown |  |
| parent_name | Unknown |  |
| parent_sku | Unknown |  |
| pattern | Unknown |  |
| product_bid | Unknown |  |
| shipping_height | Unknown |  |
| shipping_label | Unknown |  |
| shipping_length | Unknown |  |
| shipping_length_unit | Unknown |  |
| shipping_rate | Unknown |  |
| shipping_weight | Unknown |  |
| shipping_weight_unit | Unknown |  |
| shipping_width | Unknown |  |
| size | Unknown |  |
| size_unit | Unknown |  |
| stock_availability | Unknown |  |
| sub_category | Unknown |  |
| text_1 | Unknown |  |
| text_2 | Unknown |  |
| text_3 | Unknown |  |
| uri | Unknown |  |
| url | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |

### catalog_service_area

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_id | Unknown | PK, FK |
| service_area | Unknown |  |

### catalog_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| catalog_id | Unknown | PK, FK |
| location | Unknown |  |

### catalog

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown |  |
| advertiser_location | Unknown |  |
| advertiser_name | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| currency | Unknown |  |
| date_last_updated | Unknown |  |
| ftp_locations | Json |  |
| items_uri | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| number_of_item | Unknown |  |
| uri | Unknown |  |

### action

| Column | Type | Keys |
| --- | --- | --- |
| action_tracker_id | Unknown | PK |
| ad_id | Unknown | PK |
| campaign_id | Unknown | PK |
| id | Unknown | PK |
| action_tracker_name | Unknown |  |
| amount | Unknown |  |
| campaign_name | Unknown |  |
| cleared_date | Unknown |  |
| creation_date | Unknown |  |
| currency | Unknown |  |
| customer_area | Unknown |  |
| customer_city | Unknown |  |
| customer_country | Unknown |  |
| customer_region | Unknown |  |
| delta_amount | Unknown |  |
| delta_payout | Unknown |  |
| event_code | Unknown |  |
| event_date | Unknown |  |
| intended_amount | Unknown |  |
| intended_payout | Unknown |  |
| locking_date | Unknown |  |
| order_id | Unknown |  |
| payout | Unknown |  |
| promo_code | Unknown |  |
| referring_date | Unknown |  |
| referring_domain | Unknown |  |
| referring_type | Unknown |  |
| shared_id | Unknown |  |
| state | Unknown |  |
| sub_id_1 | Unknown |  |
| sub_id_2 | Unknown |  |
| sub_id_3 | Unknown |  |
| uri | Unknown |  |

### promotion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown |  |
| advertiser_location | Unknown |  |
| advertiser_name | Unknown |  |
| effective_date | Unknown |  |
| file_id | Unknown |  |
| generic_redemption_code | Unknown |  |
| item_uri | Unknown |  |
| title | Unknown |  |
| uri | Unknown |  |

### user_access_right_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| access_right_role | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| permission | Unknown |  |

### user_access_right

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown |  |
| date_last_updated | Unknown |  |
| first_name | Unknown |  |
| invitee_name | Unknown |  |
| joined_date | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| last_updated_by | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| uri | Unknown |  |
| username | Unknown |  |

### click_brand_related

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| click_id | Unknown | PK, FK |
| ad_campaign | Unknown |  |
| ad_group | Unknown |  |
| channel | Unknown |  |
| keyword | Unknown |  |
| match_type | Unknown |  |

### click_partner_related

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| click_id | Unknown | PK, FK |
| sub_id_1 | Unknown |  |
| sub_id_2 | Unknown |  |
| sub_id_3 | Unknown |  |

### click

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ad_id | Unknown |  |
| ad_name | Unknown |  |
| ad_type | Unknown |  |
| bid_keyword | Unknown |  |
| browser | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| cpc_bid | Unknown |  |
| customer_area | Unknown |  |
| customer_city | Unknown |  |
| customer_country | Unknown |  |
| customer_region | Unknown |  |
| deal_name | Unknown |  |
| deal_scope | Unknown |  |
| deal_type | Unknown |  |
| device_family | Unknown |  |
| device_type | Unknown |  |
| event_date | Unknown |  |
| ip_address | Unknown |  |
| landing_page_url | Unknown |  |
| media_id | Unknown |  |
| media_name | Unknown |  |
| os | Unknown |  |
| payout | Unknown |  |
| product_sku | Unknown |  |
| profile_id | Unknown |  |
| referring_domain | Unknown |  |
| referring_url | Unknown |  |
| search_text | Unknown |  |
| shared_id | Unknown |  |
| traffic_category | Unknown |  |
| traffic_source | Unknown |  |
| unique_click | Unknown |  |

## Relationships

- action_update(action_id) → action(id)
- catalog_item_promotion(promotion_id) → promotion(id)
- catalog_item_promotion(catalog_item_id) → catalog_item(id)
- catalog_item_promotion(catalog_id) → catalog_item(catalog_id)
- catalog_item_advertiser_format_categorogies(catalog_item_id) → catalog_item(id)
- catalog_item_advertiser_format_categorogies(catalog_id) → catalog_item(catalog_id)
- catalog_item_color(catalog_item_id) → catalog_item(id)
- catalog_item_color(catalog_id) → catalog_item(catalog_id)
- catalog_item(catalog_id) → catalog(id)
- catalog_service_area(catalog_id) → catalog(id)
- catalog_location(catalog_id) → catalog(id)
- user_access_right_permission(access_right_role) → user_access_right(role)
- user_access_right_permission(user_id) → user_access_right(user_id)
- user_access_right(user_id) → users(id)
- click_brand_related(click_id) → click(id)
- click_partner_related(click_id) → click(id)