| id |
int(10)
|
|
|
|
| proprietaire_type |
enum('usine', 'client_externe')
|
utf8mb4_general_ci
|
|
|
| proprietaire_nom |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| proprietaire_prenom |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| proprietaire_societe |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| proprietaire_adresse |
text
|
utf8mb4_general_ci
|
|
|
| proprietaire_commune |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| proprietaire_profession |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| marque |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| modele |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| categorie |
enum('Moto', 'Véhicule particulier', 'Camionnette')
|
utf8mb4_general_ci
|
|
|
| numero_serie_type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| carrosserie |
enum('Berline', 'Break', 'SUV/4*4', 'Fourgon ', 'Pickup', 'Coupé', 'Cabriolet', 'Scooter', 'Cross', 'Utilitaire', 'Sportive')
|
utf8mb4_general_ci
|
|
|
| numero_moteur |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| cylindree |
int(10)
|
|
|
|
| puissance_admin |
int(10)
|
|
|
|
| carburant |
enum('Essence', 'Diesel', 'GPL', 'Électrique', 'Hybride', 'Autre')
|
utf8mb4_general_ci
|
|
|
| places_assises |
tinyint(3)
|
|
|
|
| ptac |
int(10)
|
|
|
|
| poids_vide |
int(10)
|
|
|
|
| charge_utile |
int(10)
|
|
|
|
| immatriculation |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| immat_precedente |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| date_immat_precedente |
date
|
|
|
|
| annee |
year(4)
|
|
|
|
| date_premiere_circulation |
date
|
|
|
|
| date_visite_technique |
date
|
|
|
|
| date_assurance |
date
|
|
|
|
| vin |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| kilometrage |
int(10)
|
|
|
|
| etat |
enum('operationnel', 'en_reparation', 'hs')
|
utf8mb4_general_ci
|
|
|
| photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| date_ajout |
datetime
|
|
|
|
| photo_original_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| photo_mime |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| photo_blob |
longblob
|
|
|
|
| photo_uploaded_at |
datetime
|
|
|
|
