jmeeuynz_digitalso
Tables earnings
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| order_number | bigint | NULL | ||
| order_product_id | int | NULL | ||
| user_id | int | NULL | MUL | |
| sale_amount | bigint | NULL | ||
| vat_rate | double | NULL | ||
| vat_amount | bigint | NULL | ||
| commission_rate | tinyint | NULL | ||
| commission | bigint | NULL | ||
| coupon_discount | bigint | NULL | ||
| shipping_cost | bigint | NULL | ||
| earned_amount | bigint | NULL | ||
| affiliate_commission | bigint | NULL | ||
| affiliate_commission_rate | double | NULL | ||
| affiliate_discount | bigint | NULL | ||
| affiliate_discount_rate | double | NULL | ||
| currency | varchar(20) | USD | ||
| exchange_rate | double | 1 | ||
| is_refunded | tinyint(1) | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |