|
id
|
int(10) unsigned
|
|
|
|
|
quote_id
|
int(10) unsigned
|
|
|
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(50)
|
|
|
|
|
vehicle_id
|
int(10) unsigned
|
|
|
|
|
subtotal
|
decimal(10,2)
|
|
|
0.00
|
|
vat_amount
|
decimal(10,2)
|
|
|
0.00
|
|
total
|
decimal(10,2)
|
|
|
0.00
|
|
profit_amount
|
decimal(10,2)
|
|
|
0.00
|
|
cost_total
|
decimal(10,2)
|
|
|
0.00
|
|
gross_profit
|
decimal(10,2)
|
|
|
0.00
|
|
notes
|
text
|
|
|
|
|
status
|
varchar(30)
|
|
|
confirmed
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|