| id |
int(10)
|
|
|
|
| order_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(10)
|
|
|
|
| source |
enum('online', 'app', 'pos')
|
utf8mb4_unicode_ci
|
|
|
| customer_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| address |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
enum('cod', 'kuraimi', 'cash')
|
utf8mb4_unicode_ci
|
|
|
| transfer_bank |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| payment_status |
enum('unpaid', 'pending', 'paid', 'refunded')
|
utf8mb4_unicode_ci
|
|
|
| payment_receipt |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('pending', 'processing', 'shipped', 'completed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| discount |
decimal(12,2)
|
|
|
|
| shipping |
decimal(12,2)
|
|
|
|
| total |
decimal(12,2)
|
|
|
|
| returned_total |
decimal(12,2)
|
|
|
|
| coupon_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| admin_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
