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