| id |
int(11)
|
|
|
|
| license |
varchar(50)
|
utf8_general_ci
|
|
|
| citizenid |
varchar(50)
|
utf8_general_ci
|
|
|
| vehicle |
longtext
|
utf8_general_ci
|
|
|
| hash |
varchar(50)
|
utf8_general_ci
|
|
|
| mods |
text
|
utf8mb4_bin
|
|
|
| plate |
varchar(15)
|
utf8_general_ci
|
|
|
| fakeplate |
varchar(50)
|
utf8_general_ci
|
|
|
| garage |
varchar(50)
|
utf8_general_ci
|
|
|
| fuel |
int(11)
|
|
|
|
| engine |
float
|
|
|
|
| body |
float
|
|
|
|
| lambrachip |
varchar(50)
|
utf8_general_ci
|
|
|
| state |
int(11)
|
|
|
|
| depotprice |
int(11)
|
|
|
|
| drivingdistance |
int(50)
|
|
|
|
| status |
text
|
utf8_general_ci
|
|
|
| balance |
int(11)
|
|
|
|
| paymentamount |
int(11)
|
|
|
|
| paymentsleft |
int(11)
|
|
|
|
| financetime |
int(11)
|
|
|
|
| job |
varchar(50)
|
utf8_general_ci
|
|
|
| date |
date
|
|
|
|
| datefinish |
date
|
|
|
|
| model |
varchar(255)
|
utf8_general_ci
|
|
|
| tag |
varchar(50)
|
utf8mb4_bin
|
|
|
| impound_data |
text
|
utf8mb4_bin
|
|
|
| favorite |
int(3)
|
|
|
|
| type |
varchar(50)
|
utf8mb4_bin
|
|
|
| jobVehicle |
varchar(50)
|
utf8mb4_bin
|
|
|
| jobGarage |
varchar(50)
|
utf8mb4_bin
|
|
|
| parking |
varchar(60)
|
utf8_general_ci
|
|
|
| doorcondition |
varchar(255)
|
utf8_general_ci
|
|
|
| windowcondition |
varchar(255)
|
utf8_general_ci
|
|
|
| tyrecondition |
varchar(255)
|
utf8_general_ci
|
|
|
| favourite |
tinyint(1)
|
|
|
|
| impoundTime |
varchar(255)
|
utf8_general_ci
|
|
|
| location |
varchar(255)
|
utf8_general_ci
|
|
|
| reason |
varchar(255)
|
utf8_general_ci
|
|
|
| sharedwith |
longtext
|
utf8_general_ci
|
|
|
| vehiclename |
varchar(23)
|
utf8_general_ci
|
|
|
