| id |
int(10)
|
|
|
|
| order_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(10)
|
|
|
|
| email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| subtotal |
decimal(10,2)
|
|
|
|
| discount |
decimal(10,2)
|
|
|
|
| coupon_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| total |
decimal(10,2)
|
|
|
|
| currency |
varchar(3)
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| payment_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| payment_url |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| payment_status |
enum('pending', 'completed', 'failed', 'refunded')
|
utf8mb4_unicode_ci
|
|
|
| order_status |
enum('pending', 'processing', 'completed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| admin_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| user_agent |
text
|
utf8mb4_unicode_ci
|
|
|
| completed_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|