|
id
|
int(11)
|
|
|
|
|
store_id
|
int(11)
|
|
|
|
|
order_number
|
int(11)
|
|
|
|
|
customer_name
|
varchar(150)
|
|
|
|
|
customer_phone
|
varchar(60)
|
|
|
|
|
delivery_type
|
enum
|
-- |
|
|
|
payment_type
|
enum
|
-- |
|
|
|
address
|
varchar(255)
|
|
|
|
|
city
|
varchar(120)
|
|
|
|
|
postal_code
|
varchar(30)
|
|
|
|
|
notes
|
text
|
|
|
|
|
subtotal
|
decimal(12,2)
|
|
|
|
|
shipping
|
decimal(12,2)
|
|
|
0.00
|
|
total
|
decimal(12,2)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
payment_confirmed
|
tinyint(1)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|