{"data":[{"nom_table":"acompte","file_count":0},{"nom_table":"avis_client","file_count":0},{"nom_table":"conversation","file_count":0},{"nom_table":"etat","file_count":0},{"nom_table":"genre","file_count":0},{"nom_table":"image_vehicule","file_count":0},{"nom_table":"location","file_count":0},{"nom_table":"log","file_count":0},{"nom_table":"marque","file_count":0},{"nom_table":"mode_paiement","file_count":0},{"nom_table":"option_incluse","file_count":0},{"nom_table":"option_vehicule","file_count":0},{"nom_table":"privilege","file_count":0},{"nom_table":"type_boite_vitesse","file_count":0},{"nom_table":"type_carburant","file_count":0},{"nom_table":"type_vehicule","file_count":0},{"nom_table":"utilisateur","file_count":0},{"nom_table":"vehicule","file_count":0}],"nom_base_de_donnees":"ammo1331_Elitecars","connexion":true,"username":"ammo1331_c0Elite","table_v1":{"projectName":"projet1.angular","decription":"Fichier de configuration de Taf","taf_base_url":"https:\/\/www.elitecars.jant.tech\/","les_modules":[{"module":"home","les_tables":[{"table":"acompte","description":["id_acompte","id_mode_paiement","id_location","date","montant","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"avis_client","description":["id_avis_client","id_utilisateur","id_location","note","commentaire","date_avis","approuve","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"conversation","description":["id_conversation","id_emetteur","id_receveur","message","date_heure","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"etat","description":["id_etat","nom_etat","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"genre","description":["id_genre","nom_genre","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"image_vehicule","description":["id_image_vehicule","id_vehicule","image","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"location","description":["id_location","id_utilisateur","id_vehicule","id_etat","date_debut","date_fin","heure_debut","heure_fin","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"log","description":["id_log","id_utilisateur","action","ip","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"marque","description":["id_marque","nom_marque","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"mode_paiement","description":["id_mode_paiement","nom","description","logo","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"option_incluse","description":["id_option_incluse","nom_option_incluse","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"option_vehicule","description":["id_option_vehicule","id_option_incluse","id_vehicule","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"privilege","description":["id_privilege","nom_privilege","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"type_boite_vitesse","description":["id_type_boite_vitesse","nom_type_boite_vitesse","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"type_carburant","description":["id_type_carburant","nom_type_carburant","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"type_vehicule","description":["id_type_vehicule","nom_type_vehicule","description","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"utilisateur","description":["id_utilisateur","id_privilege","id_genre","nom","prenom","email","adresse","type_piece","image_recto","image_verso","telephone","password","photo_profil","date_naissance","statut","created_at","updated_at"],"les_types":["add","edit","list","details"]},{"table":"vehicule","description":["id_vehicule","id_utilisateur","id_type_vehicule","id_marque","id_type_boite_vitesse","id_type_carburant","nom_vehicule","prix_journalier_sans_chauffeur","prix_journalier_avec_chauffeur","description","nombre_passager","nombre_porte","visible","created_at","updated_at"],"les_types":["add","edit","list","details"]}]},{"module":"public","les_tables":[{"table":"login","description":["login","pwd"],"les_types":["login"]}]}]},"api_service":"\n                import { HttpClient, HttpHeaders } from '@angular\/common\/http';\n                import { Injectable } from '@angular\/core';\n                import { Router } from '@angular\/router';\n                import { JwtHelperService } from '@auth0\/angular-jwt';\n                import * as moment from 'moment';\n\n\n                @Injectable({\n                providedIn: 'root'\n                })\n                export class ApiService {\n                local_storage_prefixe = \"prefix.\";\n                taf_base_url = \"https:\/\/www.elitecars.jant.tech\/\";\n\n\n                network: any = {\n                    token: undefined,\n                    status: true,\n                    message: \"Aucun probl\u00e9me d\u00e9tect\u00e9\",\n                }\n                token: any = {\n                    token_key: null,\n                    token_decoded: null,\n                    user_connected: null,\n                    is_expired: null,\n                    date_expiration: null\n                }\n\n                constructor(private http: HttpClient, private route: Router) { }\n                \/\/ sauvegardes\n                async get_from_local_storage(key: string): Promise<any> {\n                    let res: any = await localStorage.getItem(this.local_storage_prefixe + key);\n                    return JSON.parse(res)\n                }\n                async save_on_local_storage(key: string, value: any): Promise<void> {\n                    await localStorage.setItem(this.local_storage_prefixe + key, JSON.stringify(value));\n                }\n                async delete_from_local_storage(key: string) {\n                    await localStorage.setItem(this.local_storage_prefixe + key, 'null');\n                }\n\n                async get_token() {\n                    \/\/le token n'est pas encore charg\u00e9\n                    if (this.network.token == undefined) {\n                    this.network.token = await this.get_from_local_storage(\"token\")\n                    if (this.network.token != undefined && this.network.token != null) {\/\/ token existant\n                        this.update_data_from_token()\/\/ mise a jour du token\n                    }\n                    } else {\/\/ token d\u00e8ja charg\u00e9\n                    this.update_data_from_token()\/\/ mise a jour du token\n                    }\n                    return this.network.token\n                }\n                \/\/les requetes http\n                async taf_get(path: string, on_success: Function, on_error: Function) {\n                    let api_url = this.taf_base_url + path;\n                    const httpOptions = {\n                    headers: new HttpHeaders({\n                        Authorization: \"Bearer \" + await this.get_token(),\n                    })\n                    };\n\n                    this.http.get(api_url, httpOptions).subscribe(\n                    (reponse: any) => {\/\/ on success\n                        on_success(reponse)\n                    },\n                    (error: any) => {\/\/ on error\n                        this.on_taf_get_error(error, on_error)\n                    }\n                    )\n                }\n                on_taf_get_error(error: any, on_error: Function) {\n                    this.network.status = false;\n                    this.network.message = error\n                    alert(\"Merci de v\u00e9rifier votre connexion\")\n                    on_error(error)\n                }\n                async taf_post(path: string, data_to_send: any, on_success: Function, on_error: Function) {\n                    let api_url = this.taf_base_url + path;\n                    const httpOptions = {\n                    headers: new HttpHeaders({\n                        Authorization: \"Bearer \" + await this.get_token(),\n                    })\n                    };\n                    this.http.post(api_url, data_to_send, httpOptions).subscribe(\n                    (reponse: any) => {\/\/ on success\n                        on_success(reponse)\n                    },\n                    (error: any) => {\/\/ on error\n                        this.on_taf_post_error(error, on_error)\n                    }\n                    )\n                }\n                on_taf_post_error(error: any, on_error: any) {\n                    this.network.status = false;\n                    this.network.message = error\n                    alert(\"Merci de v\u00e9rifier votre connexion\")\n                    on_error(error)\n                }\n                async update_data_from_token() {\n                    let token_key = await this.get_from_local_storage(\"token\")\n                    const helper = new JwtHelperService();\n                    const decodedToken = helper.decodeToken(token_key);\n                    const expirationDate = helper.getTokenExpirationDate(token_key);\n                    const isExpired = helper.isTokenExpired(token_key);\n\n                    this.token = {\n                    token_key: token_key,\n                    token_decoded: decodedToken,\n                    user_connected: decodedToken.taf_data,\n                    is_expired: isExpired,\n                    date_expiration: expirationDate\n                    }\n                    if (this.token.is_expired) {\n                    this.on_token_expire()\n                    }\n                }\n                on_token_expire() {\n                    alert(\"Votre session s'est expir\u00e9! Veuillez vous connecter \u00e0 nouveau\")\n                    this.delete_from_local_storage(\"token\")\n                    this.route.navigate(['\/public\/login'])\n                }\n                format_date(date_string: string) {\n                    return {\n                    full: moment(date_string).locale(\"fr\").format(\"dddd Do MMMM YYYY\"),\/\/ 27 f\u00e9vrier 2023 \n                    jma: moment(date_string).locale(\"fr\").format(\"Do MMMM YYYY\"),\/\/ jeudi ...\n                    jma2: moment(date_string).locale(\"fr\").format(\"DD-MM-YYYY\"),\/\/ 01-11-2023\n                    jma3: moment(date_string).locale(\"fr\").format(\"YYYY-MM-DD\"),\/\/ 2023-10-21\n                    full_datetime: moment(date_string).locale(\"fr\").format(\"dddd Do MMMM YYYY \u00e0 HH:mm\"),\/\/ 27 f\u00e9vrier 2023 \n                    }\n                }\n                format_current_date() {\n                    return {\n                    full: moment().locale(\"fr\").format(\"dddd Do MMMM YYYY\"),\/\/ 27 f\u00e9vrier 2023 \n                    jma: moment().locale(\"fr\").format(\"Do MMMM YYYY\"),\/\/ jeudi ...\n                    jma2: moment().locale(\"fr\").format(\"DD-MM-YYYY\"),\/\/ 01-11-2023\n                    full_datetime: moment().locale(\"fr\").format(\"dddd Do MMMM YYYY \u00e0 HH:mm\"),\/\/ 27 f\u00e9vrier 2023 \n                    }\n                }\n                custom_menu() {\n                    let id_privilege = parseInt(this.token.token_decoded.taf_data.id_privilege) \/\/2\n                    console.log(\"id_privilege= \", id_privilege)\n\n\n                    this.menu = this.full_menu.filter((un_menu: any) => {\n                    un_menu.items = un_menu.items.filter((un_item: any) => { return un_item.privileges.indexOf(id_privilege) != -1 })\n\n                    return un_menu.items.length > 0\n                    })\n                }\n                has_acces(route: string) {\n\n                }\n                }","table_v2":{"projectName":"projet1.angular","decription":"Fichier de configuration de Taf","taf_base_url":"https:\/\/www.elitecars.jant.tech\/","les_modules":[{"module":"home","les_tables":[{"table":"acompte","description":["id_acompte","id_mode_paiement","id_location","date","montant","created_at","updated_at"],"table_descriptions":{"table_name":"acompte","cle_primaire":{"Field":"id_acompte","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location"],"les_referenced_table":["mode_paiement","location"],"les_colonnes":[{"Field":"id_acompte","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_mode_paiement de la table mode_paiement","table":{"TABLE_NAME":"acompte","COLUMN_NAME":"id_mode_paiement","REFERENCED_TABLE_NAME":"mode_paiement","REFERENCED_COLUMN_NAME":"id_mode_paiement"},"table_existant":false,"referenced_table":{"table_name":"mode_paiement","cle_primaire":{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"logo","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_location de la table location","table":{"TABLE_NAME":"acompte","COLUMN_NAME":"id_location","REFERENCED_TABLE_NAME":"location","REFERENCED_COLUMN_NAME":"id_location"},"table_existant":false,"referenced_table":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","etat"],"les_referenced_table":["utilisateur","vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"montant","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"avis_client","description":["id_avis_client","id_utilisateur","id_location","note","commentaire","date_avis","approuve","created_at","updated_at"],"table_descriptions":{"table_name":"avis_client","cle_primaire":{"Field":"id_avis_client","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location"],"les_referenced_table":["utilisateur","location"],"les_colonnes":[{"Field":"id_avis_client","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"avis_client","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_location de la table location","table":{"TABLE_NAME":"avis_client","COLUMN_NAME":"id_location","REFERENCED_TABLE_NAME":"location","REFERENCED_COLUMN_NAME":"id_location"},"table_existant":false,"referenced_table":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","etat"],"les_referenced_table":["vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"note","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"commentaire","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_avis","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"approuve","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"conversation","description":["id_conversation","id_emetteur","id_receveur","message","date_heure","created_at","updated_at"],"table_descriptions":{"table_name":"conversation","cle_primaire":{"Field":"id_conversation","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur"],"les_referenced_table":["utilisateur"],"les_colonnes":[{"Field":"id_conversation","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_emetteur","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"conversation","COLUMN_NAME":"id_emetteur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_receveur","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"conversation","COLUMN_NAME":"id_receveur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"message","Type":"text","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_heure","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"etat","description":["id_etat","nom_etat","created_at","updated_at"],"table_descriptions":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"genre","description":["id_genre","nom_genre","description","created_at","updated_at"],"table_descriptions":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"image_vehicule","description":["id_image_vehicule","id_vehicule","image","created_at","updated_at"],"table_descriptions":{"table_name":"image_vehicule","cle_primaire":{"Field":"id_image_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule"],"les_referenced_table":["vehicule"],"les_colonnes":[{"Field":"id_image_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"image_vehicule","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"image","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"location","description":["id_location","id_utilisateur","id_vehicule","id_etat","date_debut","date_fin","heure_debut","heure_fin","created_at","updated_at"],"table_descriptions":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","etat"],"les_referenced_table":["utilisateur","vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"log","description":["id_log","id_utilisateur","action","ip","created_at","updated_at"],"table_descriptions":{"table_name":"log","cle_primaire":{"Field":"id_log","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur"],"les_referenced_table":["utilisateur"],"les_colonnes":[{"Field":"id_log","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"log","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"action","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"ip","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"marque","description":["id_marque","nom_marque","description","created_at","updated_at"],"table_descriptions":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"mode_paiement","description":["id_mode_paiement","nom","description","logo","created_at","updated_at"],"table_descriptions":{"table_name":"mode_paiement","cle_primaire":{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["mode_paiement"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"logo","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"option_incluse","description":["id_option_incluse","nom_option_incluse","description","created_at","updated_at"],"table_descriptions":{"table_name":"option_incluse","cle_primaire":{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_incluse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_option_incluse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"option_vehicule","description":["id_option_vehicule","id_option_incluse","id_vehicule","created_at","updated_at"],"table_descriptions":{"table_name":"option_vehicule","cle_primaire":{"Field":"id_option_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule"],"les_referenced_table":["option_incluse","vehicule"],"les_colonnes":[{"Field":"id_option_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_option_incluse de la table option_incluse","table":{"TABLE_NAME":"option_vehicule","COLUMN_NAME":"id_option_incluse","REFERENCED_TABLE_NAME":"option_incluse","REFERENCED_COLUMN_NAME":"id_option_incluse"},"table_existant":false,"referenced_table":{"table_name":"option_incluse","cle_primaire":{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_option_incluse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"option_vehicule","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"privilege","description":["id_privilege","nom_privilege","description","created_at","updated_at"],"table_descriptions":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_boite_vitesse","description":["id_type_boite_vitesse","nom_type_boite_vitesse","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_carburant","description":["id_type_carburant","nom_type_carburant","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_vehicule","description":["id_type_vehicule","nom_type_vehicule","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"utilisateur","description":["id_utilisateur","id_privilege","id_genre","nom","prenom","email","adresse","type_piece","image_recto","image_verso","telephone","password","photo_profil","date_naissance","statut","created_at","updated_at"],"table_descriptions":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"vehicule","description":["id_vehicule","id_utilisateur","id_type_vehicule","id_marque","id_type_boite_vitesse","id_type_carburant","nom_vehicule","prix_journalier_sans_chauffeur","prix_journalier_avec_chauffeur","description","nombre_passager","nombre_porte","visible","created_at","updated_at"],"table_descriptions":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]}]},{"module":"public","les_tables":[{"table":"login","description":["login","pwd"],"les_types":["login"]}]}]},"tables":[{"table":"acompte","description":["id_acompte","id_mode_paiement","id_location","date","montant","created_at","updated_at"],"table_descriptions":{"table_name":"acompte","cle_primaire":{"Field":"id_acompte","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location"],"les_referenced_table":["mode_paiement","location"],"les_colonnes":[{"Field":"id_acompte","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_mode_paiement de la table mode_paiement","table":{"TABLE_NAME":"acompte","COLUMN_NAME":"id_mode_paiement","REFERENCED_TABLE_NAME":"mode_paiement","REFERENCED_COLUMN_NAME":"id_mode_paiement"},"table_existant":false,"referenced_table":{"table_name":"mode_paiement","cle_primaire":{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"logo","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_location de la table location","table":{"TABLE_NAME":"acompte","COLUMN_NAME":"id_location","REFERENCED_TABLE_NAME":"location","REFERENCED_COLUMN_NAME":"id_location"},"table_existant":false,"referenced_table":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","etat"],"les_referenced_table":["utilisateur","vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["acompte","mode_paiement","location","utilisateur","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"montant","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"avis_client","description":["id_avis_client","id_utilisateur","id_location","note","commentaire","date_avis","approuve","created_at","updated_at"],"table_descriptions":{"table_name":"avis_client","cle_primaire":{"Field":"id_avis_client","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location"],"les_referenced_table":["utilisateur","location"],"les_colonnes":[{"Field":"id_avis_client","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"avis_client","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_location de la table location","table":{"TABLE_NAME":"avis_client","COLUMN_NAME":"id_location","REFERENCED_TABLE_NAME":"location","REFERENCED_COLUMN_NAME":"id_location"},"table_existant":false,"referenced_table":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","etat"],"les_referenced_table":["vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["avis_client","utilisateur","location","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"note","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"commentaire","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_avis","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"approuve","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"conversation","description":["id_conversation","id_emetteur","id_receveur","message","date_heure","created_at","updated_at"],"table_descriptions":{"table_name":"conversation","cle_primaire":{"Field":"id_conversation","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur"],"les_referenced_table":["utilisateur"],"les_colonnes":[{"Field":"id_conversation","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_emetteur","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"conversation","COLUMN_NAME":"id_emetteur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["conversation","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_receveur","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"conversation","COLUMN_NAME":"id_receveur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"message","Type":"text","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_heure","Type":"datetime","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"etat","description":["id_etat","nom_etat","created_at","updated_at"],"table_descriptions":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"genre","description":["id_genre","nom_genre","description","created_at","updated_at"],"table_descriptions":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"image_vehicule","description":["id_image_vehicule","id_vehicule","image","created_at","updated_at"],"table_descriptions":{"table_name":"image_vehicule","cle_primaire":{"Field":"id_image_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule"],"les_referenced_table":["vehicule"],"les_colonnes":[{"Field":"id_image_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"image_vehicule","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["image_vehicule","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"image","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"location","description":["id_location","id_utilisateur","id_vehicule","id_etat","date_debut","date_fin","heure_debut","heure_fin","created_at","updated_at"],"table_descriptions":{"table_name":"location","cle_primaire":{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","etat"],"les_referenced_table":["utilisateur","vehicule","etat"],"les_colonnes":[{"Field":"id_location","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":true},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_etat de la table etat","table":{"TABLE_NAME":"location","COLUMN_NAME":"id_etat","REFERENCED_TABLE_NAME":"etat","REFERENCED_COLUMN_NAME":"id_etat"},"table_existant":false,"referenced_table":{"table_name":"etat","cle_primaire":{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["location","utilisateur","vehicule","etat"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_etat","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_etat","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"date_debut","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_fin","Type":"date","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_debut","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"heure_fin","Type":"time","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"log","description":["id_log","id_utilisateur","action","ip","created_at","updated_at"],"table_descriptions":{"table_name":"log","cle_primaire":{"Field":"id_log","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur"],"les_referenced_table":["utilisateur"],"les_colonnes":[{"Field":"id_log","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"log","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["log","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"action","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"ip","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"marque","description":["id_marque","nom_marque","description","created_at","updated_at"],"table_descriptions":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"mode_paiement","description":["id_mode_paiement","nom","description","logo","created_at","updated_at"],"table_descriptions":{"table_name":"mode_paiement","cle_primaire":{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["mode_paiement"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_mode_paiement","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"logo","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"option_incluse","description":["id_option_incluse","nom_option_incluse","description","created_at","updated_at"],"table_descriptions":{"table_name":"option_incluse","cle_primaire":{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_incluse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_option_incluse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"option_vehicule","description":["id_option_vehicule","id_option_incluse","id_vehicule","created_at","updated_at"],"table_descriptions":{"table_name":"option_vehicule","cle_primaire":{"Field":"id_option_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule"],"les_referenced_table":["option_incluse","vehicule"],"les_colonnes":[{"Field":"id_option_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_option_incluse de la table option_incluse","table":{"TABLE_NAME":"option_vehicule","COLUMN_NAME":"id_option_incluse","REFERENCED_TABLE_NAME":"option_incluse","REFERENCED_COLUMN_NAME":"id_option_incluse"},"table_existant":false,"referenced_table":{"table_name":"option_incluse","cle_primaire":{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_option_incluse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_option_incluse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_vehicule de la table vehicule","table":{"TABLE_NAME":"option_vehicule","COLUMN_NAME":"id_vehicule","REFERENCED_TABLE_NAME":"vehicule","REFERENCED_COLUMN_NAME":"id_vehicule"},"table_existant":false,"referenced_table":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["option_vehicule","option_incluse","vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"privilege","description":["id_privilege","nom_privilege","description","created_at","updated_at"],"table_descriptions":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_boite_vitesse","description":["id_type_boite_vitesse","nom_type_boite_vitesse","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_carburant","description":["id_type_carburant","nom_type_carburant","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"type_vehicule","description":["id_type_vehicule","nom_type_vehicule","description","created_at","updated_at"],"table_descriptions":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"utilisateur","description":["id_utilisateur","id_privilege","id_genre","nom","prenom","email","adresse","type_piece","image_recto","image_verso","telephone","password","photo_profil","date_naissance","statut","created_at","updated_at"],"table_descriptions":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]},{"table":"vehicule","description":["id_vehicule","id_utilisateur","id_type_vehicule","id_marque","id_type_boite_vitesse","id_type_carburant","nom_vehicule","prix_journalier_sans_chauffeur","prix_journalier_avec_chauffeur","description","nombre_passager","nombre_porte","visible","created_at","updated_at"],"table_descriptions":{"table_name":"vehicule","cle_primaire":{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":["utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_colonnes":[{"Field":"id_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_utilisateur de la table utilisateur","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_utilisateur","REFERENCED_TABLE_NAME":"utilisateur","REFERENCED_COLUMN_NAME":"id_utilisateur"},"table_existant":false,"referenced_table":{"table_name":"utilisateur","cle_primaire":{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege","genre"],"les_referenced_table":["privilege","genre"],"les_colonnes":[{"Field":"id_utilisateur","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_privilege de la table privilege","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_privilege","REFERENCED_TABLE_NAME":"privilege","REFERENCED_COLUMN_NAME":"id_privilege"},"table_existant":false,"referenced_table":{"table_name":"privilege","cle_primaire":{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_privilege","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_privilege","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_genre","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_genre de la table genre","table":{"TABLE_NAME":"utilisateur","COLUMN_NAME":"id_genre","REFERENCED_TABLE_NAME":"genre","REFERENCED_COLUMN_NAME":"id_genre"},"table_existant":false,"referenced_table":{"table_name":"genre","cle_primaire":{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","privilege","genre"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_genre","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_genre","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prenom","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"adresse","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"type_piece","Type":"enum('Passeport','Permis de conduire')","Null":"YES","Key":"","Default":"Passeport","Extra":"","explications":""},{"Field":"image_recto","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"image_verso","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"telephone","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"password","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"photo_profil","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"date_naissance","Type":"date","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"statut","Type":"tinyint(1)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_vehicule de la table type_vehicule","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_vehicule","REFERENCED_TABLE_NAME":"type_vehicule","REFERENCED_COLUMN_NAME":"id_type_vehicule"},"table_existant":false,"referenced_table":{"table_name":"type_vehicule","cle_primaire":{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_vehicule","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_vehicule","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_marque de la table marque","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_marque","REFERENCED_TABLE_NAME":"marque","REFERENCED_COLUMN_NAME":"id_marque"},"table_existant":false,"referenced_table":{"table_name":"marque","cle_primaire":{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_marque","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_marque","Type":"varchar(255)","Null":"NO","Key":"UNI","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_boite_vitesse de la table type_boite_vitesse","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_boite_vitesse","REFERENCED_TABLE_NAME":"type_boite_vitesse","REFERENCED_COLUMN_NAME":"id_type_boite_vitesse"},"table_existant":false,"referenced_table":{"table_name":"type_boite_vitesse","cle_primaire":{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_boite_vitesse","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_boite_vitesse","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"id_type_carburant","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":"","explications":"cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id_type_carburant de la table type_carburant","table":{"TABLE_NAME":"vehicule","COLUMN_NAME":"id_type_carburant","REFERENCED_TABLE_NAME":"type_carburant","REFERENCED_COLUMN_NAME":"id_type_carburant"},"table_existant":false,"referenced_table":{"table_name":"type_carburant","cle_primaire":{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},"les_based_table_name":["vehicule","utilisateur","type_vehicule","marque","type_boite_vitesse","type_carburant"],"les_referenced_table":[],"les_colonnes":[{"Field":"id_type_carburant","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment","explications":"cl\u00e9 primaire"},{"Field":"nom_type_carburant","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]}},{"Field":"nom_vehicule","Type":"varchar(255)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_sans_chauffeur","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"prix_journalier_avec_chauffeur","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"description","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_passager","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"nombre_porte","Type":"int(11)","Null":"NO","Key":"","Default":null,"Extra":"","explications":""},{"Field":"visible","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":"","explications":""},{"Field":"created_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"","explications":""},{"Field":"updated_at","Type":"datetime","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()","explications":""}]},"les_types":["add","edit","list","details"]}],"base_url":"https:\/\/www.elitecars.jant.tech\/","docs":[{"langage":"angular.json","contenu":[{"action":"add","les_langages":[{"name":"HTML","disabled":false,"code":{"input":"<!-- ${une_colonne.Field} field avec un contr\u00f4le de validit\u00e9 --><div class=\"form-group col-sm-6\"><label>{{ une_colonne.Field }}<\/label><input class=\"form-control\" type=\"text\" formControlName=\"{{ une_colonne.Field }}\" placeholder=\"{{ une_colonne.Field }}\" [ngClass]=\"{ 'is-invalid': submitted && f[une_colonne.Field].errors }\"\/><div *ngIf=\"submitted && f[une_colonne.Field].errors\" class=\"invalid-feedback\"><div *ngIf=\"f[une_colonne.Field].errors.required\">{{ une_colonne.Field }} est obligatoire<\/div><\/div><\/div>","select":"<!-- ${une_colonne.Field} field avec un contr\u00f4le de validit\u00e9 --><div class=\"form-group col-sm-6\"><label>${une_colonne.Field}<\/label><select class=\"form-select\" formControlName=\"${une_colonne.Field}\" [ngClass]=\"{ 'is-invalid': submitted && f.${une_colonne.Field}.errors }\"><option *ngFor=\"let one_${une_colonne.table.TABLE_NAME} of forms_details.les_${une_colonne.table.TABLE_NAME}\" [value]=\"one_${une_colonne.table.TABLE_NAME}.${une_colonne.Field}\">{{one_${une_colonne.table.TABLE_NAME}.${une_colonne.Field}}}<\/option><\/select><div *ngIf=\"submitted && f.${une_colonne.Field}.errors\" class=\"invalid-feedback\"><div *ngIf=\"f.${une_colonne.Field}.errors.required\">${une_colonne.Field} est obligatoire<\/div><\/div><\/div>","form":"<form [formGroup]=\"reactiveForm_add_${table.table}\" (ngSubmit)=\"onSubmit_add_${table.table}()\" #form_add_${table.table}=\"ngForm\" class=\"row\">${all_colonne}<\/form><!-- vous pouvez valider votre formulaire n'importe o\u00f9 --><div class=\"text-center m-2\"><button type=\"button\" class=\"btn btn-primary m-2\" [disabled]=\"loading_add_${table.table}\" (click)=\"form_add_${table.table}.ngSubmit.emit()\">{{loading_add_${table.table} ? 'En cours ...' : 'Valider'}}<\/button><button class=\"btn btn-secondary m-2\" type=\"reset\" (click)=\"onReset_add_${table.table}()\">Vider<\/button><\/div>"}}]}]},{"langage":"ionic.json","contenu":[{"action":"add","les_langages":[{"name":"HTML","disabled":false,"code":{"input":"<!-- ${une_colonne.Field} field avec un contr\u00f4le de validit\u00e9 --><div class=\"form-group col-sm-6\"><label>{{ une_colonne.Field }}<\/label><input class=\"form-control\" type=\"text\" formControlName=\"{{ une_colonne.Field }}\" placeholder=\"{{ une_colonne.Field }}\" [ngClass]=\"{ 'is-invalid': submitted && f[une_colonne.Field].errors }\"\/><div *ngIf=\"submitted && f[une_colonne.Field].errors\" class=\"invalid-feedback\"><div *ngIf=\"f[une_colonne.Field].errors.required\">{{ une_colonne.Field }} est obligatoire<\/div><\/div><\/div>","select":"<!-- ${une_colonne.Field} field avec un contr\u00f4le de validit\u00e9 --><div class=\"form-group col-sm-6\"><label>${une_colonne.Field}<\/label><select class=\"form-select\" formControlName=\"${une_colonne.Field}\" [ngClass]=\"{ 'is-invalid': submitted && f.${une_colonne.Field}.errors }\"><option *ngFor=\"let one_${une_colonne.table.TABLE_NAME} of forms_details.les_${une_colonne.table.TABLE_NAME}\" [value]=\"one_${une_colonne.table.TABLE_NAME}.${une_colonne.Field}\">{{one_${une_colonne.table.TABLE_NAME}.${une_colonne.Field}}}<\/option><\/select><div *ngIf=\"submitted && f.${une_colonne.Field}.errors\" class=\"invalid-feedback\"><div *ngIf=\"f.${une_colonne.Field}.errors.required\">${une_colonne.Field} est obligatoire<\/div><\/div><\/div>","form":"<form [formGroup]=\"reactiveForm_add_${table.table}\" (ngSubmit)=\"onSubmit_add_${table.table}()\" #form_add_${table.table}=\"ngForm\" class=\"row\">${all_colonne}<\/form><!-- vous pouvez valider votre formulaire n'importe o\u00f9 --><div class=\"text-center m-2\"><button type=\"button\" class=\"btn btn-primary m-2\" [disabled]=\"loading_add_${table.table}\" (click)=\"form_add_${table.table}.ngSubmit.emit()\">{{loading_add_${table.table} ? 'En cours ...' : 'Valider'}}<\/button><button class=\"btn btn-secondary m-2\" type=\"reset\" (click)=\"onReset_add_${table.table}()\">Vider<\/button><\/div>"}}]}]}],"status":true}