jmeeuynz_digitalso
Tables affiliate_earnings
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| referrer_id | int | NULL | ||
| order_id | int | NULL | ||
| product_id | int | NULL | ||
| seller_id | int | NULL | ||
| commission_rate | tinyint | NULL | ||
| earned_amount | bigint | NULL | ||
| currency | varchar(20) | USD | ||
| exchange_rate | double | 1 | ||
| created_at | timestamp | CURRENT_TIMESTAMP |