|
id
|
int(11)
|
|
|
|
|
tenant_id
|
int(11)
|
|
|
|
|
customer_name
|
varchar(150)
|
|
|
|
|
customer_phone
|
varchar(40)
|
|
|
|
|
customer_address
|
text
|
|
|
|
|
service_type
|
enum
|
-- |
|
delivery
|
|
pickup_time
|
datetime
|
|
|
|
|
customer_ip
|
varchar(45)
|
|
|
|
|
payment_method
|
varchar(40)
|
|
|
|
|
cash_given
|
decimal(10,2)
|
|
|
|
|
card_commission_amount
|
decimal(10,2)
|
|
|
0.00
|
|
subtotal
|
decimal(10,2)
|
|
|
|
|
shipping_cost
|
decimal(10,2)
|
|
|
0.00
|
|
total_amount
|
decimal(10,2)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
whatsapp_url
|
text
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|