|
id
|
int(11)
|
|
|
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(50)
|
|
|
|
|
customer_location
|
varchar(255)
|
|
|
|
|
customer_address
|
varchar(500)
|
|
|
|
|
delivery_slot
|
varchar(100)
|
|
|
|
|
total
|
decimal(10,2)
|
|
|
0.00
|
|
status
|
enum
|
-- |
|
pending
|
|
note
|
text
|
|
|
|
|
slip_image
|
varchar(255)
|
|
|
|
|
tracking_number
|
varchar(100)
|
|
|
|
|
shipping_provider
|
varchar(50)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|