UpPromote
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 |