# UpPromote schema ERD

Table and field reference for the Fivetran UpPromote connector.

## Table & Field Reference

### referral

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| commission | Unknown |  |
| commission_adjustment | Unknown |  |
| commission_amount | Unknown |  |
| commission_type | Unknown |  |
| created_at | Unknown |  |
| customer_id | Unknown |  |
| order_id | Unknown |  |
| order_number | Unknown |  |
| quantity | Unknown |  |
| refund_id | Unknown |  |
| status | Unknown |  |
| total_sales | Unknown |  |
| tracking_type | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_id | Unknown | FK |
| coupon | Unknown |  |
| created_timestamp | Unknown |  |
| description | Unknown |  |

### paid_payment_history

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | Unknown | PK |
| affiliate_id | Unknown | FK |
| payment_method | Unknown |  |
| processed_at | Instant |  |
| status | Unknown |  |
| total_processed | Unknown |  |

### program_commission_advanced

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| program_id | Unknown | PK, FK |
| commission | Unknown |  |
| condition | Unknown |  |
| level | Unknown |  |

### program

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| commission_amount | Unknown |  |
| commission_type | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| exclude_product_tax | Unknown |  |
| exclude_self_referral | Unknown |  |
| exclude_shipping | Unknown |  |
| exclude_shipping_tax | Unknown |  |
| exclude_tip | Unknown |  |
| is_default | Unknown |  |
| lifetime_commission_disconnect_day | Unknown |  |
| lifetime_commission_first_commission_amount | Unknown |  |
| lifetime_commission_first_commission_type | Unknown |  |
| name | Unknown |  |
| new_customer_commission_amount | Unknown |  |
| new_customer_commission_type | Unknown |  |
| payment_default | Unknown |  |
| payment_methods | Json |  |
| rule | Unknown |  |
| special_coupon_commission_amount | Unknown |  |
| special_coupon_commission_type | Unknown |  |
| status | Unknown |  |

### affiliate_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| affiliate_id | Unknown | PK, FK |
| key | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### affiliate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| program_id | Unknown | FK |
| address | Unknown |  |
| affiliate_link | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_at_timestamp | Unknown |  |
| email | Unknown |  |
| email_verified | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| instagram | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| program_name | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| twitter | Unknown |  |
| youtube | Unknown |  |
| zip_code | Unknown |  |

## Relationships

- referral(affiliate_id) → affiliate(id)
- coupon(affiliate_id) → affiliate(id)
- paid_payment_history(affiliate_id) → affiliate(id)
- program_commission_advanced(program_id) → program(id)
- affiliate_custom_field(affiliate_id) → affiliate(id)
- affiliate(program_id) → program(id)