|
id
|
varchar(36)
|
|
|
|
|
job_card_id
|
varchar(36)
|
|
|
|
|
quotation_id
|
varchar(36)
|
|
|
|
|
vehicle_id
|
varchar(36)
|
|
|
|
|
customer_id
|
varchar(36)
|
|
|
|
|
branch_id
|
varchar(36)
|
|
|
|
|
status
|
varchar(20)
|
|
|
draft
|
|
mileage_out
|
decimal(10,2)
|
|
|
|
|
mileage_in
|
decimal(10,2)
|
|
|
|
|
mileage
|
decimal(10,2)
|
|
|
|
|
inspector_name
|
varchar(255)
|
|
|
|
|
inspection_date
|
date
|
|
|
|
|
remarks
|
text
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|