jmeeuynz_digitalso
Tables order_products
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| order_id | bigint | NULL | MUL | |
| seller_id | int | NULL | MUL | |
| buyer_id | int | NULL | MUL | |
| buyer_type | varchar(20) | NULL | ||
| product_id | int | NULL | MUL | |
| product_type | varchar(20) | physical | ||
| listing_type | varchar(20) | NULL | ||
| product_title | varchar(500) | NULL | ||
| product_slug | varchar(500) | NULL | ||
| product_unit_price | bigint | NULL | ||
| product_quantity | int | NULL | ||
| product_currency | varchar(20) | NULL | ||
| product_vat_rate | double | NULL | ||
| product_vat | bigint | NULL | ||
| product_total_price | bigint | NULL | ||
| variation_option_ids | varchar(255) | NULL | ||
| commission_rate | tinyint | NULL | ||
| order_status | varchar(50) | NULL | ||
| is_approved | tinyint(1) | NULL | ||
| shipping_tracking_number | varchar(255) | NULL | ||
| shipping_tracking_url | varchar(500) | NULL | ||
| shipping_method | varchar(255) | NULL | ||
| seller_shipping_cost | bigint | NULL | ||
| updated_at | timestamp | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |