JantTaf est un générateur automatique d'api à partir d'une base de données MYSQL ou PGSQL ou SQLSRV.
Une fois le fichier de configuration (TafConfig.php) personnalisé, grâce à l'api vous pouvez voir toutes les tables de votre base de données et ainsi générer les fichiers nécessaires à la manipulation de ces tables comme la récupération, la suppression, l'ajout et la modification des données.

La(es) table(s) de la base de données ammo1331_cnscl

  1. adresses
  2. adresses_entreprises
  3. commentaire
  4. competences
  5. contacts_responsables
  6. donation
  7. entreprises
  8. experiences
  9. expertises_entreprises
  10. experts
  11. interlocuteurs
  12. likes
  13. log
  14. privileges
  15. realisations
  16. recuperation

Configuration

La configuration repose sur le fichier TafConfig.php. Dans ce fichier vous devez spécifier:
• le type de la base de données
• l'adresse de votre serveur
• le port du SGBD
• le nom de votre base de donnée
• nom d'utilisateur de la base de données
• mot de passe de l'utilisateur de la base de données

NB:
Dans le cadre de Postgres, n'oubliez pas d'activer l'extension au niveau de php.ini (";extension=pdo_pgsql" -> "extension=pdo_pgsql"))

/* Information de connexion à la base de données */ public $database_type = "mysql"; // "mysql" | "pgsql" | "sqlsrv" public $host = "localhost"; // adresse ou ip du serveur public $port = "3306"; // 3306 pour mysql | 5432 pour pgsql | 1433 pour sqlsrv public $database_name = "ma_bd"; // nom de la base de données public $user = "root"; // nom de l'utilisateur de la base de données public $password = ""; // mot de passe de l'utilisateur de la base de données /* informations de connexion à la documentation */ public $documentation_username = "admin"; // nom d'utilisateur pour accéder à la documentation public $documentation_password = "1234"; // mot de passe de l'utilisateur pour accéder à la documentation

Fichier de configuration pour le projet angular

Créez un fichier JSON dans la racine de votre projet Angular nommé taf.config.json avec le contenu suivant :
cliquez ici pour consulter la documentation complete

{ "projectName": "projet1.angular", "decription": "Fichier de configuration de Taf", "taf_base_url": "https:\/\/www.cnscl.jant.tech\/taf\/", "les_modules": [ { "module": "home", "les_tables": [ { "table": "adresses", "description": [ "id", "expert_id", "pays", "continent", "region", "departement", "arrondissement", "commune", "rue_quartier", "numero", "ville", "telephone", "email" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "adresses_entreprises", "description": [ "id", "entreprise_id", "pays", "continent", "region", "departement", "arrondissement", "commune", "rue_quartier", "numero", "ville", "telephone", "email" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "commentaire", "description": [ "id_commentaire", "contenu", "date_commentaire", "id_realisation", "id_utilisateur" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "competences", "description": [ "id", "expert_id", "expertise", "niveau_certification", "niveau_formation", "pays_zone", "diplome_attestation" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "contacts_responsables", "description": [ "id", "entreprise_id", "nom_fonction_responsable", "telephone_responsable", "email_responsable" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "donation", "description": [ "id_donation", "donation_date", "donation_type", "donation_amount", "net_amount", "sender_name", "sender_country" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entreprises", "description": [ "id", "denomination", "sigle", "statut", "autre_statut", "forme_juridique", "date_creation", "domaines_activite" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "experiences", "description": [ "id", "expert_id", "poste", "annee", "duree", "pays_zone", "entreprise_reference", "profile" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "expertises_entreprises", "description": [ "id", "entreprise_id", "expertise", "niveau_certification", "niveau_formation", "nombre_experts", "reference_entreprise" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "experts", "description": [ "id_utilisateur", "id_privilege", "nom_prenom", "descriptions", "date_naissance", "lieu_naissance", "nationalite", "pays_naissance", "situation_familiale", "pays_residence", "cin_passport_permis", "date_expiration", "statut", "employeur", "qualifications", "specialisation", "grade", "fonction", "domaine_activite", "telephone_expert", "email_expert", "profile", "password_expert", "verification_status", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "interlocuteurs", "description": [ "id", "entreprise_id", "nom_fonction_interlocuteur_pays", "telephone_interlocuteur_pays", "email_interlocuteur_pays", "nom_fonction_point_focal_region", "telephone_point_focal_region", "email_point_focal_region" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "likes", "description": [ "id", "number_like", "expert_id", "realisation_id", "date_like" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "log", "description": [ "id_log", "ip", "params", "token", "titre", "description", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "privileges", "description": [ "id_privilege", "libelle", "description", "updated_at", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "realisations", "description": [ "id", "expert_id", "type", "titre", "description", "image_url", "date_publication", "niveau", "created_at", "updated_at" ], "les_types": [ "add", "edit", "list", "details" ] }, { "table": "recuperation", "description": [ "id_recuperation", "email", "code", "etat", "created_at" ], "les_types": [ "add", "edit", "list", "details" ] } ] }, { "module": "public", "les_tables": [ { "table": "login", "description": [ "login", "pwd" ], "les_types": [ "login" ] } ] } ] }
{ "projectName": "projet1.angular", "decription": "Fichier de configuration de Taf", "taf_base_url": "https:\/\/www.cnscl.jant.tech\/taf\/", "les_modules": [ { "module": "home", "les_tables": [ { "table": "adresses", "description": [ "id", "expert_id", "pays", "continent", "region", "departement", "arrondissement", "commune", "rue_quartier", "numero", "ville", "telephone", "email" ], "table_descriptions": { "table_name": "adresses", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "adresses", "experts" ], "les_referenced_table": [ "experts" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "adresses", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "adresses", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "pays", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "continent", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "region", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "departement", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "arrondissement", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "commune", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "rue_quartier", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "numero", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "ville", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "adresses_entreprises", "description": [ "id", "entreprise_id", "pays", "continent", "region", "departement", "arrondissement", "commune", "rue_quartier", "numero", "ville", "telephone", "email" ], "table_descriptions": { "table_name": "adresses_entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "adresses_entreprises", "entreprises" ], "les_referenced_table": [ "entreprises" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "entreprise_id", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table entreprises", "table": { "TABLE_NAME": "adresses_entreprises", "COLUMN_NAME": "entreprise_id", "REFERENCED_TABLE_NAME": "entreprises", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "adresses_entreprises", "entreprises" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "denomination", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sigle", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Etablissement Para public','Etablissement Priv\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "autre_statut", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "forme_juridique", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_creation", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaines_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "pays", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "continent", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "region", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "departement", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "arrondissement", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "commune", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "rue_quartier", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "numero", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "ville", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "commentaire", "description": [ "id_commentaire", "contenu", "date_commentaire", "id_realisation", "id_utilisateur" ], "table_descriptions": { "table_name": "commentaire", "cle_primaire": { "Field": "id_commentaire", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "commentaire", "realisations", "experts" ], "les_referenced_table": [ "realisations", "experts" ], "les_colonnes": [ { "Field": "id_commentaire", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "contenu", "Type": "text", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_commentaire", "Type": "timestamp", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "id_realisation", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table realisations", "table": { "TABLE_NAME": "commentaire", "COLUMN_NAME": "id_realisation", "REFERENCED_TABLE_NAME": "realisations", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "realisations", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "commentaire", "realisations", "experts" ], "les_referenced_table": [ "experts" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "realisations", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "commentaire", "realisations", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "type", "Type": "int(1)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "titre", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "image_url", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_publication", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "niveau", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] } }, { "Field": "id_utilisateur", "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 experts", "table": { "TABLE_NAME": "commentaire", "COLUMN_NAME": "id_utilisateur", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "commentaire", "realisations", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "competences", "description": [ "id", "expert_id", "expertise", "niveau_certification", "niveau_formation", "pays_zone", "diplome_attestation" ], "table_descriptions": { "table_name": "competences", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "competences", "experts" ], "les_referenced_table": [ "experts" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "competences", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "competences", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "expertise", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "niveau_certification", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "niveau_formation", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_zone", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "diplome_attestation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "contacts_responsables", "description": [ "id", "entreprise_id", "nom_fonction_responsable", "telephone_responsable", "email_responsable" ], "table_descriptions": { "table_name": "contacts_responsables", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "contacts_responsables", "entreprises" ], "les_referenced_table": [ "entreprises" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "entreprise_id", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table entreprises", "table": { "TABLE_NAME": "contacts_responsables", "COLUMN_NAME": "entreprise_id", "REFERENCED_TABLE_NAME": "entreprises", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "contacts_responsables", "entreprises" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "denomination", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sigle", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Etablissement Para public','Etablissement Priv\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "autre_statut", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "forme_juridique", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_creation", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaines_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "nom_fonction_responsable", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_responsable", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email_responsable", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "donation", "description": [ "id_donation", "donation_date", "donation_type", "donation_amount", "net_amount", "sender_name", "sender_country" ], "table_descriptions": { "table_name": "donation", "cle_primaire": { "Field": "id_donation", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "donation" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_donation", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "donation_date", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "donation_type", "Type": "varchar(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "donation_amount", "Type": "decimal(10,2)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "net_amount", "Type": "decimal(10,2)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sender_name", "Type": "varchar(100)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sender_country", "Type": "varchar(100)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "entreprises", "description": [ "id", "denomination", "sigle", "statut", "autre_statut", "forme_juridique", "date_creation", "domaines_activite" ], "table_descriptions": { "table_name": "entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "entreprises" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "denomination", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sigle", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Etablissement Para public','Etablissement Priv\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "autre_statut", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "forme_juridique", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_creation", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaines_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "experiences", "description": [ "id", "expert_id", "poste", "annee", "duree", "pays_zone", "entreprise_reference", "profile" ], "table_descriptions": { "table_name": "experiences", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "experiences", "experts" ], "les_referenced_table": [ "experts" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "experiences", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "experiences", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "poste", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "annee", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "duree", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_zone", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "entreprise_reference", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "expertises_entreprises", "description": [ "id", "entreprise_id", "expertise", "niveau_certification", "niveau_formation", "nombre_experts", "reference_entreprise" ], "table_descriptions": { "table_name": "expertises_entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "expertises_entreprises", "entreprises" ], "les_referenced_table": [ "entreprises" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "entreprise_id", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table entreprises", "table": { "TABLE_NAME": "expertises_entreprises", "COLUMN_NAME": "entreprise_id", "REFERENCED_TABLE_NAME": "entreprises", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "expertises_entreprises", "entreprises" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "denomination", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sigle", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Etablissement Para public','Etablissement Priv\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "autre_statut", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "forme_juridique", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_creation", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaines_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "expertise", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "niveau_certification", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "niveau_formation", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nombre_experts", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "reference_entreprise", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "experts", "description": [ "id_utilisateur", "id_privilege", "nom_prenom", "descriptions", "date_naissance", "lieu_naissance", "nationalite", "pays_naissance", "situation_familiale", "pays_residence", "cin_passport_permis", "date_expiration", "statut", "employeur", "qualifications", "specialisation", "grade", "fonction", "domaine_activite", "telephone_expert", "email_expert", "profile", "password_expert", "verification_status", "created_at", "updated_at" ], "table_descriptions": { "table_name": "experts", "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": [ "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "interlocuteurs", "description": [ "id", "entreprise_id", "nom_fonction_interlocuteur_pays", "telephone_interlocuteur_pays", "email_interlocuteur_pays", "nom_fonction_point_focal_region", "telephone_point_focal_region", "email_point_focal_region" ], "table_descriptions": { "table_name": "interlocuteurs", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "interlocuteurs", "entreprises" ], "les_referenced_table": [ "entreprises" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "entreprise_id", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table entreprises", "table": { "TABLE_NAME": "interlocuteurs", "COLUMN_NAME": "entreprise_id", "REFERENCED_TABLE_NAME": "entreprises", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "entreprises", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "interlocuteurs", "entreprises" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "denomination", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "sigle", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Etablissement Para public','Etablissement Priv\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "autre_statut", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "forme_juridique", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_creation", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaines_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "nom_fonction_interlocuteur_pays", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_interlocuteur_pays", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email_interlocuteur_pays", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_fonction_point_focal_region", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_point_focal_region", "Type": "varchar(20)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "email_point_focal_region", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "likes", "description": [ "id", "number_like", "expert_id", "realisation_id", "date_like" ], "table_descriptions": { "table_name": "likes", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "likes", "experts", "realisations" ], "les_referenced_table": [ "experts", "realisations" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "number_like", "Type": "int(11)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "likes", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "likes", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "realisation_id", "Type": "int(11)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne id de la table realisations", "table": { "TABLE_NAME": "likes", "COLUMN_NAME": "realisation_id", "REFERENCED_TABLE_NAME": "realisations", "REFERENCED_COLUMN_NAME": "id" }, "table_existant": false, "referenced_table": { "table_name": "realisations", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "likes", "experts", "realisations" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "realisations", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": true }, { "Field": "type", "Type": "int(1)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "titre", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "image_url", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_publication", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "niveau", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] } }, { "Field": "date_like", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "log", "description": [ "id_log", "ip", "params", "token", "titre", "description", "created_at" ], "table_descriptions": { "table_name": "log", "cle_primaire": { "Field": "id_log", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "log" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_log", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "ip", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "params", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "token", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "titre", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "privileges", "description": [ "id_privilege", "libelle", "description", "updated_at", "created_at" ], "table_descriptions": { "table_name": "privileges", "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": [ "privileges" ], "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": "libelle", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "realisations", "description": [ "id", "expert_id", "type", "titre", "description", "image_url", "date_publication", "niveau", "created_at", "updated_at" ], "table_descriptions": { "table_name": "realisations", "cle_primaire": { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "realisations", "experts" ], "les_referenced_table": [ "experts" ], "les_colonnes": [ { "Field": "id", "Type": "int(11)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "expert_id", "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 experts", "table": { "TABLE_NAME": "realisations", "COLUMN_NAME": "expert_id", "REFERENCED_TABLE_NAME": "experts", "REFERENCED_COLUMN_NAME": "id_utilisateur" }, "table_existant": false, "referenced_table": { "table_name": "experts", "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": [ "realisations", "experts" ], "les_referenced_table": [], "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": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nom_prenom", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "descriptions", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_naissance", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "lieu_naissance", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "nationalite", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_naissance", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "situation_familiale", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "pays_residence", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "cin_passport_permis", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_expiration", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "statut", "Type": "enum('Chef d''entreprise','Employ\u00e9','Informel','Autre')", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "employeur", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "qualifications", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "specialisation", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "grade", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "fonction", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "domaine_activite", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "telephone_expert", "Type": "varchar(255)", "Null": "YES", "Key": "MUL", "Default": null, "Extra": "", "explications": "cl\u00e9 \u00e9trang\u00e8re li\u00e9e \u00e0 la colonne de la table ", "table": false, "table_existant": false }, { "Field": "email_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "profile", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "password_expert", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "verification_status", "Type": "int(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" } ] } }, { "Field": "type", "Type": "int(1)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "titre", "Type": "varchar(255)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "description", "Type": "text", "Null": "NO", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "image_url", "Type": "varchar(255)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "date_publication", "Type": "datetime", "Null": "YES", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "niveau", "Type": "int(11)", "Null": "YES", "Key": "", "Default": "0", "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" }, { "Field": "updated_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] }, { "table": "recuperation", "description": [ "id_recuperation", "email", "code", "etat", "created_at" ], "table_descriptions": { "table_name": "recuperation", "cle_primaire": { "Field": "id_recuperation", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, "les_based_table_name": [ "recuperation" ], "les_referenced_table": [], "les_colonnes": [ { "Field": "id_recuperation", "Type": "int(255)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "explications": "cl\u00e9 primaire" }, { "Field": "email", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "code", "Type": "int(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "etat", "Type": "int(1)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "explications": "" }, { "Field": "created_at", "Type": "datetime", "Null": "NO", "Key": "", "Default": "current_timestamp()", "Extra": "", "explications": "" } ] }, "les_types": [ "add", "edit", "list", "details" ] } ] }, { "module": "public", "les_tables": [ { "table": "login", "description": [ "login", "pwd" ], "les_types": [ "login" ] } ] } ] }

Service angular api.service.ts

Instalations à faire

Créez un service dans votre projet Angular nommé api.service.ts avec le contenu suivant :

import { HttpClient, HttpHeaders } from '@angular/common/http'; import { Injectable } from '@angular/core'; import { Router } from '@angular/router'; import { JwtHelperService } from '@auth0/angular-jwt'; import * as moment from 'moment'; @Injectable({ providedIn: 'root' }) export class ApiService { local_storage_prefixe = "prefix."; taf_base_url = "https://www.cnscl.jant.tech/taf/"; network: any = { token: undefined, status: true, message: "Aucun probléme détecté", } token: any = { token_key: null, token_decoded: null, user_connected: null, is_expired: null, date_expiration: null } constructor(private http: HttpClient, private route: Router) { } // sauvegardes async get_from_local_storage(key: string): Promise { let res: any = await localStorage.getItem(this.local_storage_prefixe + key); return JSON.parse(res) } async save_on_local_storage(key: string, value: any): Promise { await localStorage.setItem(this.local_storage_prefixe + key, JSON.stringify(value)); } async delete_from_local_storage(key: string) { await localStorage.setItem(this.local_storage_prefixe + key, 'null'); } async get_token() { //le token n'est pas encore chargé if (this.network.token == undefined) { this.network.token = await this.get_from_local_storage("token") if (this.network.token != undefined && this.network.token != null) {// token existant this.update_data_from_token()// mise a jour du token } } else {// token dèja chargé this.update_data_from_token()// mise a jour du token } return this.network.token } //les requetes http async taf_get(path: string, on_success: Function, on_error: Function) { let api_url = this.taf_base_url + path; const httpOptions = { headers: new HttpHeaders({ Authorization: "Bearer " + await this.get_token(), }) }; this.http.get(api_url, httpOptions).subscribe( (reponse: any) => {// on success on_success(reponse) }, (error: any) => {// on error this.on_taf_get_error(error, on_error) } ) } on_taf_get_error(error: any, on_error: Function) { this.network.status = false; this.network.message = error alert("Merci de vérifier votre connexion") on_error(error) } async taf_post(path: string, data_to_send: any, on_success: Function, on_error: Function) { let api_url = this.taf_base_url + path; const httpOptions = { headers: new HttpHeaders({ Authorization: "Bearer " + await this.get_token(), }) }; this.http.post(api_url, data_to_send, httpOptions).subscribe( (reponse: any) => {// on success on_success(reponse) }, (error: any) => {// on error this.on_taf_post_error(error, on_error) } ) } on_taf_post_error(error: any, on_error: any) { this.network.status = false; this.network.message = error alert("Merci de vérifier votre connexion") on_error(error) } async update_data_from_token() { let token_key = await this.get_from_local_storage("token") const helper = new JwtHelperService(); const decodedToken = helper.decodeToken(token_key); const expirationDate = helper.getTokenExpirationDate(token_key); const isExpired = helper.isTokenExpired(token_key); this.token = { token_key: token_key, token_decoded: decodedToken, user_connected: decodedToken.taf_data, is_expired: isExpired, date_expiration: expirationDate } if (this.token.is_expired) { this.on_token_expire() } } on_token_expire() { alert("Votre session s'est expiré! Veuillez vous connecter à nouveau") this.delete_from_local_storage("token") this.route.navigate(['/public/login']) } format_date(date_string: string) { return { full: moment(date_string).locale("fr").format("dddd Do MMMM YYYY"),// 27 février 2023 jma: moment(date_string).locale("fr").format("Do MMMM YYYY"),// jeudi ... jma2: moment(date_string).locale("fr").format("DD-MM-YYYY"),// 01-11-2023 jma3: moment(date_string).locale("fr").format("YYYY-MM-DD"),// 2023-10-21 full_datetime: moment(date_string).locale("fr").format("dddd Do MMMM YYYY à HH:mm"),// 27 février 2023 } } format_current_date() { return { full: moment().locale("fr").format("dddd Do MMMM YYYY"),// 27 février 2023 jma: moment().locale("fr").format("Do MMMM YYYY"),// jeudi ... jma2: moment().locale("fr").format("DD-MM-YYYY"),// 01-11-2023 full_datetime: moment().locale("fr").format("dddd Do MMMM YYYY à HH:mm"),// 27 février 2023 } } custom_menu() { let id_privilege = parseInt(this.token.token_decoded.taf_data.id_privilege) //2 console.log("id_privilege= ", id_privilege) this.menu = this.full_menu.filter((un_menu: any) => { un_menu.items = un_menu.items.filter((un_item: any) => { return un_item.privileges.indexOf(id_privilege) != -1 }) return un_menu.items.length > 0 }) } has_acces(route: string) { } }