| id |
int(11)
|
|
|
|
| car_plate |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| car_type |
enum('sedan', 'pickup', 'van', 'truck_small', 'truck_large', 'other')
|
utf8mb4_general_ci
|
|
|
| res_car_type |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| vehicle_kind |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| brand |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| model |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| car_year |
year(4)
|
|
|
|
| color |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| fuel_type |
enum('gasoline', 'diesel', 'lpg', 'ngv', 'hybrid', 'ev')
|
utf8mb4_general_ci
|
|
|
| engine_cc |
int(11)
|
|
|
|
| engine_cylinders |
int(11)
|
|
|
|
| horsepower_hp |
int(11)
|
|
|
|
| cargo_width_m |
decimal(5,2)
|
|
|
|
| cargo_length_m |
decimal(5,2)
|
|
|
|
| cargo_height_m |
decimal(5,2)
|
|
|
|
| timing_system |
enum('belt', 'chain', 'gear', 'unknown')
|
utf8mb4_general_ci
|
|
|
| timing_note |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| chassis_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| engine_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| reg_date |
date
|
|
|
|
| reg_date_text |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vehicle_age_years |
int(11)
|
|
|
|
| reg_expire |
date
|
|
|
|
| insurance_co |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| insurance_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| insurance_expire |
date
|
|
|
|
| inspect_expire |
date
|
|
|
|
| last_service_km |
int(11)
|
|
|
|
| last_service_date |
date
|
|
|
|
| next_service_km |
int(11)
|
|
|
|
| next_service_date |
date
|
|
|
|
| current_km |
int(11)
|
|
|
|
| gross_weight_kg |
int(11)
|
|
|
|
| curb_weight_kg |
int(11)
|
|
|
|
| payload_weight_kg |
int(11)
|
|
|
|
| department |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| assigned_driver |
int(11)
|
|
|
|
| remark |
text
|
utf8mb4_general_ci
|
|
|
| status |
enum('active', 'maintenance', 'inactive')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
