jmeeuynz_digitalso
Tables orders
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| order_number | bigint | NULL | MUL | |
| buyer_id | int | NULL | MUL | |
| buyer_type | varchar(20) | NULL | ||
| price_subtotal | varchar(50) | NULL | ||
| price_vat | bigint | NULL | ||
| price_shipping | varchar(50) | NULL | ||
| price_total | varchar(50) | NULL | ||
| price_currency | varchar(50) | NULL | ||
| coupon_code | varchar(255) | NULL | ||
| coupon_products | text | NULL | ||
| coupon_discount | bigint | NULL | ||
| coupon_discount_rate | smallint | NULL | ||
| coupon_seller_id | int | NULL | ||
| status | tinyint(1) | NULL | MUL | |
| transaction_fee_rate | double | NULL | ||
| transaction_fee | bigint | NULL | ||
| global_taxes_data | text | NULL | ||
| payment_method | varchar(50) | NULL | ||
| payment_status | varchar(50) | NULL | ||
| shipping | text | NULL | ||
| affiliate_data | text | NULL | ||
| updated_at | timestamp | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |