|
id
|
int(11)
|
|
|
|
|
doc_no
|
varchar(20)
|
|
|
|
|
book_date
|
date
|
|
|
|
|
work_time
|
time
|
|
|
|
|
use_date
|
date
|
|
|
|
|
return_date
|
date
|
|
|
|
|
depart_time
|
time
|
|
|
|
|
return_time
|
time
|
|
|
|
|
car_type
|
varchar(255)
|
|
|
|
|
destination
|
varchar(255)
|
|
|
|
|
map_url
|
varchar(1000)
|
|
|
|
|
contact_name
|
varchar(100)
|
|
|
|
|
job_no
|
varchar(50)
|
|
|
|
|
has_map
|
varchar(10)
|
|
|
|
|
contact_tel
|
varchar(20)
|
|
|
|
|
pickup_location
|
varchar(255)
|
|
|
|
|
pickup_datetime
|
datetime
|
|
|
|
|
has_staff
|
varchar(10)
|
|
|
|
|
staff_data
|
longtext
|
|
|
|
|
job_type
|
varchar(255)
|
|
|
|
|
detail
|
varchar(500)
|
|
|
|
|
detail2
|
varchar(500)
|
|
|
|
|
return_type
|
varchar(50)
|
|
|
|
|
return_location
|
varchar(255)
|
|
|
|
|
car_plate
|
varchar(20)
|
|
|
|
|
vehicle_id
|
int(11)
|
|
|
|
|
driver_name
|
varchar(100)
|
|
|
|
|
requester_sign
|
varchar(100)
|
|
|
|
|
requester_tel
|
varchar(20)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
|