{"base":"logiciel","cols":{"adresses_chantier":[["id","bigint unsigned","NO","PRI"],["devis_id","bigint unsigned","YES","UNI"],["commande_id","bigint unsigned","YES","UNI"],["adresse","varchar(191)","YES",""],["adresse2","varchar(191)","YES",""],["code_postal","varchar(20)","YES",""],["ville","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"cache":[["key","varchar(191)","NO","PRI"],["value","mediumtext","NO",""],["expiration","int","NO",""]],"cache_locks":[["key","varchar(191)","NO","PRI"],["owner","varchar(191)","NO",""],["expiration","int","NO",""]],"categories":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"commande_decoupe":[["id","bigint unsigned","NO","PRI"],["commande_id","bigint unsigned","NO","MUL"],["decoupe_id","bigint unsigned","YES","MUL"],["date_envoi","date","YES",""],["etat","tinyint unsigned","YES",""],["date_reception","date","YES",""],["laseriste","tinyint unsigned","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"commande_decoupe_document":[["commande_decoupe_id","bigint unsigned","YES","MUL"],["document_id","bigint unsigned","YES","MUL"]],"commande_decoupe_observation":[["commande_decoupe_id","bigint unsigned","YES","MUL"],["observation_id","bigint unsigned","YES","MUL"]],"commande_observation":[["commande_id","bigint unsigned","YES","MUL"],["observation_id","bigint unsigned","YES","MUL"]],"commandes":[["id","bigint unsigned","NO","PRI"],["devis_id","bigint unsigned","YES","MUL"],["client_id","bigint unsigned","YES","MUL"],["type_id","bigint unsigned","YES","MUL"],["modele","varchar(100)","YES","MUL"],["couleur","varchar(100)","YES","MUL"],["finition","tinyint unsigned","YES",""],["longueur","int","YES",""],["hauteur","int","YES",""],["largeur","int","YES",""],["quantite","int","YES",""],["url","varchar(500)","YES",""],["prix_usine","decimal(10,2)","YES",""],["maj_plan","tinyint(1)","YES",""],["cintrage","tinyint(1)","YES",""],["decoupe","tinyint(1)","YES",""],["accessoire","tinyint(1)","YES",""],["maconnerie","tinyint(1)","YES",""],["negoce","tinyint(1)","YES",""],["incomplet","tinyint(1)","YES",""],["date_accueil","date","YES",""],["date_etude","date","YES",""],["date_cotes_ok","date","YES",""],["date_visuel_ok","date","YES",""],["validateur_visuel","tinyint unsigned","YES",""],["lancee_le","date","YES",""],["date_laq_envoi","date","YES",""],["date_laq_recep","date","YES",""],["date_entrepot","date","YES",""],["date_pose","date","YES",""],["etat","tinyint unsigned","YES",""],["priorite","tinyint unsigned","YES",""],["statut","tinyint unsigned","YES",""],["laqueur","tinyint unsigned","YES",""],["usine","tinyint unsigned","YES",""],["destination","tinyint unsigned","YES",""],["platine","tinyint unsigned","YES",""],["created_at","datetime","YES",""],["updated_at","datetime","YES",""],["deleted_at","timestamp","YES",""]],"dates_bloques":[["id","bigint unsigned","NO","PRI"],["date_debut","date","NO",""],["date_fin","date","YES",""],["description","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"decoupes":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["type","tinyint unsigned","NO",""],["image","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""],["deleted_at","timestamp","YES",""]],"devis_planning":[["devis_id","bigint unsigned","NO","MUL"],["planning_id","bigint unsigned","NO","MUL"]],"document_rapport":[["document_id","bigint unsigned","YES","MUL"],["rapport_id","bigint unsigned","YES","MUL"]],"document_rapport_chantier":[["document_id","bigint unsigned","YES","MUL"],["rapport_chantier_id","bigint unsigned","YES","MUL"]],"documents":[["id","bigint unsigned","NO","PRI"],["description","longtext","YES",""],["url","longtext","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"equipes":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["type","varchar(191)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"etiquette_photo":[["etiquette_id","bigint unsigned","NO","PRI"],["photo_id","bigint unsigned","NO","PRI"]],"etiquettes":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"failed_jobs":[["id","bigint unsigned","NO","PRI"],["uuid","varchar(191)","NO","UNI"],["connection","text","NO",""],["queue","text","NO",""],["payload","longtext","NO",""],["exception","longtext","NO",""],["failed_at","timestamp","NO",""]],"fiche_intervention_lignes":[["id","bigint unsigned","NO","PRI"],["fiche_intervention_id","bigint unsigned","NO","MUL"],["produit_id","int unsigned","YES",""],["code","varchar(191)","YES",""],["libelle","varchar(191)","NO",""],["prix_unitaire_ht","decimal(10,2)","NO",""],["quantite","smallint unsigned","NO",""],["ordre","smallint unsigned","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"fiches_intervention":[["id","bigint unsigned","NO","PRI"],["intervention_id","bigint unsigned","NO","MUL"],["user_id","bigint unsigned","NO","MUL"],["date_intervention","date","NO",""],["client_nom","varchar(191)","YES",""],["client_adresse","varchar(191)","YES",""],["client_code_postal","varchar(10)","YES",""],["client_ville","varchar(191)","YES",""],["observations","text","YES",""],["main_oeuvre","decimal(10,2)","NO",""],["distance_km","smallint unsigned","YES",""],["taux_tva","tinyint unsigned","NO",""],["mode_reglement","tinyint unsigned","YES",""],["total_ht","decimal(10,2)","NO",""],["total_tva","decimal(10,2)","NO",""],["total_ttc","decimal(10,2)","NO",""],["signee_le","timestamp","YES",""],["signature_document_id","bigint unsigned","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"fournisseurs":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"gestan_clients":[["id","bigint unsigned","NO","PRI"],["raison_sociale","varchar(191)","YES",""],["nom","varchar(191)","YES",""],["prenom","varchar(191)","YES",""],["adresse1","varchar(191)","YES",""],["adresse2","varchar(191)","YES",""],["code_postal","varchar(20)","YES",""],["ville","varchar(191)","YES",""],["tel","varchar(40)","YES",""],["email","varchar(191)","YES",""],["inconnu","tinyint(1)","NO",""],["synced_at","timestamp","YES",""]],"gestan_devis":[["id","bigint unsigned","NO","PRI"],["client_id","bigint unsigned","YES","MUL"],["raison_sociale","varchar(191)","YES",""],["adresse1","varchar(191)","YES",""],["adresse2","varchar(191)","YES",""],["code_postal","varchar(20)","YES",""],["ville","varchar(191)","YES",""],["nature","text","YES",""],["reference","varchar(191)","YES",""],["responsable","varchar(191)","YES",""],["inconnu","tinyint(1)","NO",""],["synced_at","timestamp","YES",""]],"gestan_interventions":[["id","bigint unsigned","NO","PRI"],["libelle","varchar(191)","YES",""],["secteur","varchar(191)","YES",""],["adresse","varchar(191)","YES",""],["code_postal","varchar(20)","YES",""],["ville","varchar(191)","YES",""],["inconnu","tinyint(1)","NO",""],["synced_at","timestamp","YES",""]],"intervention_clotures":[["id","bigint unsigned","NO","PRI"],["intervention_id","bigint unsigned","NO","UNI"],["statut","tinyint unsigned","NO","MUL"],["terminee_par","bigint unsigned","YES","MUL"],["terminee_le","timestamp","YES",""],["reouverte_par","bigint unsigned","YES","MUL"],["reouverte_le","timestamp","YES",""],["sync_status","varchar(191)","NO",""],["sync_attempts","int unsigned","NO",""],["sync_last_error","text","YES",""],["next_sync_at","timestamp","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"intervention_document":[["intervention_id","bigint unsigned","YES","MUL"],["document_id","bigint unsigned","YES","MUL"]],"intervention_planning":[["intervention_id","bigint unsigned","NO","MUL"],["planning_id","bigint unsigned","NO","MUL"]],"intervention_user":[["intervention_id","bigint unsigned","YES","MUL"],["user_id","bigint unsigned","YES","MUL"]],"job_batches":[["id","varchar(191)","NO","PRI"],["name","varchar(191)","NO",""],["total_jobs","int","NO",""],["pending_jobs","int","NO",""],["failed_jobs","int","NO",""],["failed_job_ids","longtext","NO",""],["options","mediumtext","YES",""],["cancelled_at","int","YES",""],["created_at","int","NO",""],["finished_at","int","YES",""]],"jobs":[["id","bigint unsigned","NO","PRI"],["queue","varchar(191)","NO","MUL"],["payload","longtext","NO",""],["attempts","tinyint unsigned","NO",""],["reserved_at","int unsigned","YES",""],["available_at","int unsigned","NO",""],["created_at","int unsigned","NO",""]],"laquages":[["id","bigint unsigned","NO","PRI"],["commande_id","bigint unsigned","NO","MUL"],["passage","tinyint unsigned","NO",""],["laqueur","tinyint unsigned","YES",""],["date_envoi","date","YES",""],["date_retour","date","YES",""],["fautif","tinyint unsigned","YES",""],["raison","longtext","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"logs":[["id","bigint unsigned","NO","PRI"],["user_id","bigint unsigned","NO","MUL"],["action","varchar(191)","NO",""],["loggable_type","varchar(191)","NO","MUL"],["loggable_id","bigint unsigned","NO",""],["old_values","json","YES",""],["new_values","json","YES",""],["lot","char(36)","YES","MUL"],["annule_par","char(36)","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"migrations":[["id","int unsigned","NO","PRI"],["migration","varchar(191)","NO",""],["batch","int","NO",""]],"model_has_permissions":[["permission_id","bigint unsigned","NO","PRI"],["model_type","varchar(191)","NO","PRI"],["model_id","bigint unsigned","NO","PRI"]],"model_has_roles":[["role_id","bigint unsigned","NO","PRI"],["model_type","varchar(191)","NO","PRI"],["model_id","bigint unsigned","NO","PRI"]],"modele_photo":[["modele_id","bigint unsigned","NO","PRI"],["photo_id","bigint unsigned","NO","PRI"]],"modele_photo_chantier":[["photo_chantier_id","bigint unsigned","NO","PRI"],["modele_id","bigint unsigned","NO","PRI"]],"modele_promotion":[["promotion_id","bigint unsigned","NO","PRI"],["modele_id","bigint unsigned","NO","PRI"]],"modeles":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["ancien_nom","varchar(191)","YES",""],["image","varchar(191)","YES",""],["type_id","bigint unsigned","NO","MUL"],["categorie_id","bigint unsigned","YES","MUL"],["sous_categorie_id","bigint unsigned","YES","MUL"],["prix","decimal(10,2)","NO",""],["marge","decimal(10,2)","NO",""],["logiciel","tinyint(1)","NO",""],["vitrine","tinyint(1)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""],["deleted_at","timestamp","YES",""]],"negoces":[["id","bigint unsigned","NO","PRI"],["modele_id","bigint unsigned","NO","MUL"],["nom","varchar(191)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"notice_dossiers":[["id","bigint unsigned","NO","PRI"],["uuid","char(36)","NO","UNI"],["fournisseur_id","bigint unsigned","NO","MUL"],["parent_id","bigint unsigned","YES","MUL"],["nom","varchar(191)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"notices":[["id","bigint unsigned","NO","PRI"],["fournisseur_id","bigint unsigned","NO","MUL"],["notice_dossier_id","bigint unsigned","YES","MUL"],["source","varchar(700)","NO","UNI"],["titre","varchar(191)","NO",""],["fichier","varchar(191)","NO",""],["empreinte","char(40)","NO","MUL"],["taille","int unsigned","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"notification_reperes":[["cle","varchar(40)","NO","PRI"],["valeur","bigint unsigned","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"notifications":[["id","bigint unsigned","NO","PRI"],["user_id","bigint unsigned","NO","MUL"],["type","varchar(20)","NO",""],["titre","varchar(191)","NO",""],["corps","text","YES",""],["url","varchar(191)","YES",""],["reference_type","varchar(20)","YES",""],["reference_id","bigint unsigned","YES",""],["lu_at","timestamp","YES",""],["envoye_at","timestamp","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"observation_planning":[["observation_id","bigint unsigned","NO","MUL"],["planning_id","bigint unsigned","NO","MUL"]],"observations":[["id","bigint unsigned","NO","PRI"],["type","tinyint unsigned","YES","MUL"],["observation","longtext","NO",""],["user_id","bigint unsigned","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"password_reset_tokens":[["email","varchar(191)","NO","PRI"],["token","varchar(191)","NO",""],["created_at","timestamp","YES",""]],"permissions":[["id","bigint unsigned","NO","PRI"],["name","varchar(125)","NO","MUL"],["guard_name","varchar(125)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"personal_access_tokens":[["id","bigint unsigned","NO","PRI"],["tokenable_type","varchar(191)","NO","MUL"],["tokenable_id","bigint unsigned","NO",""],["name","text","NO",""],["token","varchar(64)","NO","UNI"],["abilities","text","YES",""],["last_used_at","timestamp","YES",""],["expires_at","timestamp","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"photo_chantier_variation":[["photo_chantier_id","bigint unsigned","NO","PRI"],["variation_id","bigint unsigned","NO","PRI"]],"photo_produits":[["id","bigint unsigned","NO","PRI"],["photo_id","bigint unsigned","NO","MUL"],["commande_id","bigint unsigned","YES","MUL"],["type_id","bigint unsigned","YES","MUL"],["modele_id","bigint unsigned","YES","MUL"],["variation_id","bigint unsigned","YES","MUL"],["categorie_id","bigint unsigned","YES","MUL"],["modele","varchar(191)","YES","MUL"],["couleur","varchar(191)","YES","MUL"],["devis_id","bigint unsigned","YES","MUL"],["article","varchar(60)","YES","MUL"],["article_libelle","varchar(191)","YES",""],["ajoute_par","bigint unsigned","YES","MUL"]],"photo_variation":[["photo_id","bigint unsigned","NO","PRI"],["variation_id","bigint unsigned","NO","PRI"]],"photo_versions":[["id","bigint unsigned","NO","PRI"],["photo_id","bigint unsigned","NO","MUL"],["document_id","bigint unsigned","NO","MUL"],["user_id","bigint unsigned","YES","MUL"],["motif","varchar(191)","YES",""],["created_at","timestamp","YES",""]],"photos":[["id","bigint unsigned","NO","PRI"],["document_id","bigint unsigned","NO","UNI"],["version_id","bigint unsigned","YES","MUL"],["lot","varchar(191)","YES","MUL"],["source","varchar(191)","YES","UNI"],["rapport_chantier_id","bigint unsigned","YES","MUL"],["planning_id","bigint unsigned","YES","MUL"],["client_id","bigint unsigned","YES","MUL"],["client_nom","varchar(191)","YES",""],["user_id","bigint unsigned","YES","MUL"],["photographe","varchar(191)","YES",""],["metier","tinyint unsigned","YES","MUL"],["date_chantier","date","YES","MUL"],["prise_le","datetime","YES",""],["code_postal","varchar(20)","YES",""],["ville","varchar(191)","YES","MUL"],["retouchee_digikam","tinyint(1)","NO",""],["video","tinyint(1)","NO","MUL"],["produits_choisis","tinyint(1)","NO",""],["traitee_le","timestamp","YES","MUL"],["traitee_par","bigint unsigned","YES","MUL"],["supprimee_le","timestamp","YES","MUL"],["supprimee_par","bigint unsigned","YES","MUL"],["publiee_le","timestamp","YES","MUL"],["publiee_par","bigint unsigned","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"photos_chantier":[["id","bigint unsigned","NO","PRI"],["empreinte","char(40)","NO","UNI"],["chemin","varchar(191)","NO",""],["miniature","varchar(191)","NO",""],["largeur","smallint unsigned","NO",""],["hauteur","smallint unsigned","NO",""],["source","varchar(191)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"planning_user":[["planning_id","bigint unsigned","NO","MUL"],["user_id","bigint unsigned","NO","MUL"]],"plannings":[["id","bigint unsigned","NO","PRI"],["client_id","bigint unsigned","YES","MUL"],["equipe_id","bigint unsigned","NO","MUL"],["date_debut","datetime","YES",""],["date_fin","datetime","YES",""],["nature","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""],["deleted_at","timestamp","YES",""]],"presences":[["id","bigint unsigned","NO","PRI"],["user_id","bigint unsigned","NO","MUL"],["cle","varchar(191)","NO","MUL"],["ouvert_le","timestamp","NO",""],["vu_le","timestamp","NO",""]],"prix_alu":[["id","bigint unsigned","NO","PRI"],["prix","decimal(10,2)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"produits":[["id","bigint unsigned","NO","PRI"],["type","varchar(191)","NO",""],["categorie","varchar(191)","NO",""],["sous_categorie","varchar(191)","YES",""],["nom","varchar(191)","NO",""],["variation","varchar(191)","YES",""],["image","varchar(191)","YES",""],["vitrine","tinyint(1)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"produits_sav":[["id","bigint unsigned","NO","PRI"],["produit_id","int unsigned","NO","UNI"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"profils":[["id","bigint unsigned","NO","PRI"],["fournisseur_id","bigint unsigned","NO","MUL"],["reference","varchar(191)","YES",""],["image","varchar(191)","YES",""],["description","varchar(191)","YES",""],["longueur_barre","varchar(191)","YES",""],["surface","varchar(191)","YES",""],["poids","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"promotion_variation":[["promotion_id","bigint unsigned","NO","PRI"],["variation_id","bigint unsigned","NO","PRI"]],"promotions":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO",""],["du","date","NO",""],["au","date","NO",""],["taux","tinyint unsigned","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"push_subscriptions":[["id","bigint unsigned","NO","PRI"],["user_id","bigint unsigned","NO","MUL"],["endpoint","text","NO",""],["endpoint_hash","char(64)","NO","UNI"],["public_key","varchar(191)","NO",""],["auth_token","varchar(191)","NO",""],["content_encoding","varchar(20)","NO",""],["user_agent","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"rapport_chantier_articles":[["id","bigint unsigned","NO","PRI"],["rapport_chantier_id","bigint unsigned","NO","MUL"],["article","varchar(30)","NO","MUL"],["libelle","varchar(191)","YES",""],["quantite","decimal(8,2)","YES",""],["sens","tinyint unsigned","YES",""],["facturation","tinyint unsigned","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"rapport_chantiers":[["id","bigint unsigned","NO","PRI"],["planning_id","bigint unsigned","NO","MUL"],["user_id","bigint unsigned","YES","MUL"],["type","tinyint unsigned","NO","MUL"],["date_chantier","date","YES",""],["client_present","tinyint(1)","YES",""],["panneau_pub","tinyint(1)","YES",""],["avancement","tinyint unsigned","YES","MUL"],["commentaires","text","YES",""],["avis_client","tinyint unsigned","YES",""],["telecommandes","smallint unsigned","YES",""],["numero_cle","varchar(191)","YES",""],["certificat_transmetteur","varchar(191)","YES",""],["mini_pelle","tinyint unsigned","YES",""],["peinture_cloture","tinyint unsigned","YES","MUL"],["peinture_cloture_le","date","YES",""],["decoffrage","tinyint unsigned","YES","MUL"],["decoffre_le","date","YES",""],["signataire_nom","varchar(191)","YES",""],["signataire_date","date","YES",""],["signature_document_id","bigint unsigned","YES","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"rapports":[["id","bigint unsigned","NO","PRI"],["intervention_id","bigint unsigned","NO","MUL"],["user_id","bigint unsigned","YES","MUL"],["contenu","json","NO",""],["approuve_par","bigint unsigned","YES","MUL"],["approuve_le","timestamp","YES",""],["corrige_par","bigint unsigned","YES","MUL"],["corrige_le","timestamp","YES",""],["synced_at","timestamp","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"refabrications":[["id","bigint unsigned","NO","PRI"],["commande_id","bigint unsigned","NO","MUL"],["commande_parente_id","bigint unsigned","NO","MUL"],["fautif","tinyint unsigned","YES",""],["raison","longtext","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"responsable_groups":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"responsable_subordonne":[["responsable_id","bigint unsigned","NO","PRI"],["subordonne_id","bigint unsigned","NO","PRI"]],"role_has_permissions":[["permission_id","bigint unsigned","NO","PRI"],["role_id","bigint unsigned","NO","PRI"]],"roles":[["id","bigint unsigned","NO","PRI"],["name","varchar(125)","NO","MUL"],["guard_name","varchar(125)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"scans":[["id","bigint unsigned","NO","PRI"],["user_id","bigint unsigned","NO","MUL"],["commande_id","bigint unsigned","NO","MUL"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"sessions":[["id","varchar(191)","NO","PRI"],["user_id","bigint unsigned","YES","MUL"],["ip_address","varchar(45)","YES",""],["user_agent","text","YES",""],["payload","longtext","NO",""],["last_activity","int","NO","MUL"]],"sous_categories":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"temp_chantiers":[["N_Enr","int","YES",""],["IDRDV","int","NO","PRI"],["D_Debut","datetime","YES",""],["D_Fin","datetime","YES",""],["adresse","varchar(191)","YES",""],["suite","varchar(191)","YES",""],["codepostal","varchar(20)","YES",""],["ville","varchar(191)","YES",""],["IDEmp1","int","YES",""],["IDEmp2","int","YES",""],["IDEmp3","int","YES",""],["IDEmp4","int","YES",""],["Devis1","int","YES",""],["Devis2","int","YES",""],["Devis3","int","YES",""],["O_Rdv","longtext","YES",""],["B_Annulation","tinyint(1)","NO",""],["B_Prevoir","tinyint(1)","NO",""],["IDCONTACT","int","YES",""],["IDEQUIPE","int","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"temp_commandes":[["N_Enr","int","YES",""],["IDCOMMANDE","int","NO","PRI"],["RaisonSociale","varchar(255)","YES",""],["NomClient","varchar(100)","YES",""],["Prenom","varchar(100)","YES",""],["AdresseChantier","varchar(255)","YES",""],["AdresseSuite","varchar(255)","YES",""],["Ville","varchar(100)","YES",""],["CodePostal","varchar(20)","YES",""],["Type","varchar(50)","YES",""],["type_id","varchar(50)","YES",""],["Modele","varchar(50)","YES",""],["Couleur","varchar(100)","YES",""],["couleur_api_id","varchar(50)","YES",""],["decoupe","varchar(50)","YES",""],["decoupe_id","varchar(50)","YES",""],["Finition","varchar(50)","YES",""],["Longueur","int","YES",""],["Hauteur","int","YES",""],["Priorite","varchar(50)","YES",""],["LienPDF","varchar(500)","YES",""],["NDevis","varchar(50)","YES",""],["PrixUsine","decimal(10,2)","YES",""],["NbPoteau","int","YES",""],["HauteurPoteau","decimal(10,2)","YES",""],["PrixPoteau","decimal(10,2)","YES",""],["PrixChapeau","decimal(10,2)","YES",""],["B_Decoupe","tinyint","YES",""],["B_MajPlan","tinyint","YES",""],["B_Cintrage","tinyint","YES",""],["B_Accessoire","tinyint","YES",""],["B_Poteau","tinyint","YES",""],["B_Chapeau","tinyint","YES",""],["B_Maconnerie","tinyint","YES",""],["IDCONTACT","int","YES",""],["O_Accessoire","longtext","YES",""],["O_Commande","longtext","YES",""],["O_Maconnerie","longtext","YES",""],["B_Negoce","tinyint","YES",""],["Quantite","int","YES",""],["Platine","varchar(191)","YES",""],["D_Creation","datetime","YES",""],["Createur","varchar(100)","YES",""],["D_ValidationDevis","date","YES",""],["D_ValidationVisuel","date","YES",""],["D_ReceptionDevis","date","YES",""],["D_VerificationCotes","date","YES",""]],"temp_interventions":[["N_Enr","int","YES",""],["IDINTER","int","YES",""],["D_INTER","datetime","YES",""],["Secteur","varchar(191)","YES",""],["Etat","varchar(191)","YES",""],["Statut","varchar(191)","YES",""],["Tags","varchar(191)","YES",""],["PosGPS","varchar(191)","YES",""],["O_INTER","longtext","YES",""],["Adresse","varchar(191)","YES",""],["IDEMPLOYE","int","YES",""],["IDCONTACT","int","YES",""],["D_PoseInstallation","date","YES",""],["Forfait","varchar(191)","YES",""],["B_Urgent","tinyint(1)","NO",""],["LibGarantie","varchar(191)","YES",""],["PieceJointe","varchar(191)","YES",""],["IdAffectation","int","YES",""],["NumDigicode","varchar(191)","YES",""],["B_SansClient","tinyint(1)","NO",""],["B_MiseEnAttente","tinyint(1)","NO",""],["D_Programme","date","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"temp_process":[["N_Enr","int","YES",""],["IDPROCESS","int","NO","PRI"],["D_Commande","datetime","YES",""],["D_EnvoiDecoupe","date","YES",""],["D_ReceptionDecoupe","date","YES",""],["D_EnvoiLaquage","date","YES",""],["D_ReceptionLaquage","date","YES",""],["D_ReceptionEntrepot","date","YES",""],["D_Termine","date","YES",""],["D_PrevisionReception","date","YES",""],["NbJourRetard","int","YES",""],["Priorite","varchar(50)","YES",""],["Etat","varchar(50)","YES",""],["EtatDecoupe","varchar(50)","YES",""],["OrigineProcess","varchar(100)","YES",""],["ActeurRefab","varchar(100)","YES",""],["Destination","varchar(100)","YES",""],["Laqueur","varchar(100)","YES",""],["Laseriste","varchar(100)","YES",""],["Usine","varchar(100)","YES",""],["ValidationEnvoi","tinyint","YES",""],["B_Incomplet","tinyint","YES",""],["B_Livre","tinyint","YES",""],["B_APoser","tinyint","YES",""],["B_ATerminer","tinyint","YES",""],["B_Termine","tinyint","YES",""],["B_Original","tinyint","YES",""],["O_Process","longtext","YES",""],["O_Decoupe","longtext","YES",""],["O_Incomplet","longtext","YES",""],["IDCOMMANDE","int","YES","MUL"],["IDPARENT","int","YES",""],["D_Modification","datetime","YES",""],["Modificateur","varchar(100)","YES",""],["EtatPanneaux","varchar(50)","YES",""],["D_CommadePanneaux","date","YES",""]],"temp_rapport":[["n_enr","int","YES",""],["IDINTER_CONV","int","YES",""],["D_Inter_Conv","datetime","YES",""],["O_Employe","longtext","YES",""],["Note","int","YES",""],["Duree","varchar(191)","YES",""],["Photo","varchar(191)","YES",""],["IDINTER","int","YES",""],["IDEMPLOYE","int","YES",""],["B_Technicien","tinyint(1)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"temp_users":[["N_ENR","int","YES",""],["IDEMPLOYE","bigint unsigned","NO","PRI"],["Nom","varchar(191)","YES",""],["Prenom","varchar(191)","YES",""],["Telephone","varchar(191)","YES",""],["Mail","varchar(191)","YES",""],["Secteur","varchar(191)","YES",""],["Contract","varchar(191)","YES",""],["D_DebutContrat","date","YES",""],["D_FinContrat","date","YES",""],["B_EnActivite","tinyint(1)","YES",""],["B_ChefEquipe","tinyint(1)","YES",""],["Poste","varchar(191)","YES",""],["Login","varchar(191)","YES",""],["MotDePasse","varchar(191)","YES",""],["Permission","int","YES",""],["Photo","varchar(191)","YES",""],["Memo","text","YES",""],["IDRESPONSABLE","int","YES",""],["NomPrenom","varchar(191)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"types":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO","UNI"],["logiciel","tinyint(1)","NO",""],["vitrine","tinyint(1)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""]],"users":[["id","bigint unsigned","NO","PRI"],["nom","varchar(191)","NO",""],["prenom","varchar(191)","NO",""],["email","varchar(191)","YES",""],["email_verified_at","timestamp","YES",""],["password","varchar(191)","NO",""],["tel","varchar(191)","YES",""],["image","varchar(191)","YES",""],["secteur","varchar(191)","YES",""],["poste","varchar(191)","YES",""],["responsable_group_id","bigint unsigned","YES","MUL"],["contrat","varchar(191)","YES",""],["actif","tinyint(1)","NO",""],["chantier","tinyint(1)","NO",""],["aide_vue_le","timestamp","YES",""],["remember_token","varchar(100)","YES",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""],["deleted_at","timestamp","YES",""]],"variations":[["id","bigint unsigned","NO","PRI"],["modele_id","bigint unsigned","NO","MUL"],["nom","varchar(191)","NO",""],["ancien_nom","varchar(191)","YES",""],["image","varchar(191)","YES",""],["prix","decimal(10,2)","NO",""],["marge","decimal(10,2)","NO",""],["created_at","timestamp","YES",""],["updated_at","timestamp","YES",""],["deleted_at","timestamp","YES",""]]},"fks":[["adresses_chantier","commande_id","commandes","id"],["commande_decoupe","commande_id","commandes","id"],["commande_decoupe","decoupe_id","decoupes","id"],["commande_decoupe_document","commande_decoupe_id","commande_decoupe","id"],["commande_decoupe_document","document_id","documents","id"],["commande_decoupe_observation","commande_decoupe_id","commande_decoupe","id"],["commande_decoupe_observation","observation_id","observations","id"],["commande_observation","commande_id","commandes","id"],["commande_observation","observation_id","observations","id"],["commandes","type_id","types","id"],["devis_planning","planning_id","plannings","id"],["document_rapport","document_id","documents","id"],["document_rapport","rapport_id","rapports","id"],["document_rapport_chantier","document_id","documents","id"],["document_rapport_chantier","rapport_chantier_id","rapport_chantiers","id"],["etiquette_photo","etiquette_id","etiquettes","id"],["etiquette_photo","photo_id","photos","id"],["fiche_intervention_lignes","fiche_intervention_id","fiches_intervention","id"],["fiches_intervention","signature_document_id","documents","id"],["fiches_intervention","user_id","users","id"],["intervention_document","document_id","documents","id"],["intervention_planning","planning_id","plannings","id"],["intervention_user","user_id","users","id"],["laquages","commande_id","commandes","id"],["model_has_permissions","permission_id","permissions","id"],["model_has_roles","role_id","roles","id"],["modele_photo","modele_id","modeles","id"],["modele_photo","photo_id","photos","id"],["modele_photo_chantier","modele_id","modeles","id"],["modele_photo_chantier","photo_chantier_id","photos_chantier","id"],["modele_promotion","modele_id","modeles","id"],["modele_promotion","promotion_id","promotions","id"],["modeles","categorie_id","categories","id"],["modeles","sous_categorie_id","sous_categories","id"],["modeles","type_id","types","id"],["negoces","modele_id","modeles","id"],["notice_dossiers","fournisseur_id","fournisseurs","id"],["notice_dossiers","parent_id","notice_dossiers","id"],["notices","fournisseur_id","fournisseurs","id"],["notices","notice_dossier_id","notice_dossiers","id"],["notifications","user_id","users","id"],["observation_planning","observation_id","observations","id"],["observation_planning","planning_id","plannings","id"],["observations","user_id","users","id"],["photo_chantier_variation","photo_chantier_id","photos_chantier","id"],["photo_chantier_variation","variation_id","variations","id"],["photo_produits","ajoute_par","users","id"],["photo_produits","categorie_id","categories","id"],["photo_produits","commande_id","commandes","id"],["photo_produits","modele_id","modeles","id"],["photo_produits","photo_id","photos","id"],["photo_produits","type_id","types","id"],["photo_produits","variation_id","variations","id"],["photo_variation","photo_id","photos","id"],["photo_variation","variation_id","variations","id"],["photo_versions","document_id","documents","id"],["photo_versions","photo_id","photos","id"],["photo_versions","user_id","users","id"],["photos","document_id","documents","id"],["photos","planning_id","plannings","id"],["photos","publiee_par","users","id"],["photos","rapport_chantier_id","rapport_chantiers","id"],["photos","supprimee_par","users","id"],["photos","traitee_par","users","id"],["photos","user_id","users","id"],["photos","version_id","photo_versions","id"],["planning_user","planning_id","plannings","id"],["planning_user","user_id","users","id"],["plannings","equipe_id","equipes","id"],["presences","user_id","users","id"],["profils","fournisseur_id","fournisseurs","id"],["promotion_variation","promotion_id","promotions","id"],["promotion_variation","variation_id","variations","id"],["push_subscriptions","user_id","users","id"],["rapport_chantier_articles","rapport_chantier_id","rapport_chantiers","id"],["rapport_chantiers","planning_id","plannings","id"],["rapport_chantiers","signature_document_id","documents","id"],["rapport_chantiers","user_id","users","id"],["rapports","user_id","users","id"],["refabrications","commande_id","commandes","id"],["refabrications","commande_parente_id","commandes","id"],["responsable_subordonne","responsable_id","users","id"],["responsable_subordonne","subordonne_id","users","id"],["role_has_permissions","permission_id","permissions","id"],["role_has_permissions","role_id","roles","id"],["scans","commande_id","commandes","id"],["scans","user_id","users","id"],["users","responsable_group_id","responsable_groups","id"],["variations","modele_id","modeles","id"]]}