# Ascend by Partnerize schema ERD

Table and field reference for the Fivetran Ascend by Partnerize connector.

## Table & Field Reference

### creative_performance_resource

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| id | Unknown | PK |
| affiliate_usage | Unknown |  |
| click_through_rate | Unknown |  |
| clicks | Unknown |  |
| commission | Unknown |  |
| earnings_per_click | Unknown |  |
| end_date | Unknown |  |
| impressions | Unknown |  |
| items | Unknown |  |
| name | Unknown |  |
| sales | Unknown |  |
| start_date | Unknown |  |
| transactions | Unknown |  |
| type | Unknown |  |

### transaction_history_resource_debit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commission | Unknown |  |
| company | Unknown |  |
| end_date | Unknown |  |
| item_id | Unknown |  |
| link_type | Unknown |  |
| order_id | Unknown |  |
| process_date | Unknown |  |
| publisher | Unknown |  |
| publisher_commission | Unknown |  |
| publisher_id | Unknown |  |
| publisher_type | Unknown |  |
| revision | Unknown |  |
| sale_amount | Unknown |  |
| sale_date | Unknown |  |
| site_commission | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| transaction_id | Unknown |  |
| transaction_type | Unknown |  |
| website_url | Unknown |  |

### transaction_history_resource_credit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commission | Unknown |  |
| company | Unknown |  |
| end_date | Unknown |  |
| item_id | Unknown |  |
| link_type | Unknown |  |
| order_id | Unknown |  |
| process_date | Unknown |  |
| publisher | Unknown |  |
| publisher_commission | Unknown |  |
| publisher_id | Unknown |  |
| publisher_type | Unknown |  |
| revision | Unknown |  |
| sale_amount | Unknown |  |
| sale_date | Unknown |  |
| site_commission | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| transaction_id | Unknown |  |
| transaction_type | Unknown |  |
| website_url | Unknown |  |

### transaction_details_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| click_date | Unknown |  |
| click_id | Unknown |  |
| commission | Unknown |  |
| commission_publisher | Unknown |  |
| commission_site | Unknown |  |
| company | Unknown |  |
| coupons | Unknown |  |
| creative_id | Unknown |  |
| device_type | Unknown |  |
| end_date | Unknown |  |
| link_type | Unknown |  |
| new_to_file | Unknown |  |
| order_id | Unknown |  |
| publisher | Unknown |  |
| publisher_id | Unknown |  |
| publisher_referral_url | Unknown |  |
| publisher_type | Unknown |  |
| referrer_url | Unknown |  |
| sale_amount | Unknown |  |
| sale_date | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### creative_performance_publisher_resource

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Unknown | PK |
| date | Unknown | PK |
| publisher_id | Unknown | PK |
| click_through_rate | Unknown |  |
| clicks | Unknown |  |
| commission | Unknown |  |
| creative_name | Unknown |  |
| creative_type | Unknown |  |
| earnings_per_click | Unknown |  |
| end_date | Unknown |  |
| impressions | Unknown |  |
| publisher | Unknown |  |
| sales | Unknown |  |
| start_date | Unknown |  |
| transactions | Unknown |  |