#OPALGERIA MINISTRY OF HEALTH

  ____                           _
 |  _ \ _ __ _   _ _____ __ __ _| | ___   _
 | |_) | '__| | | |_  / '__/ _` | |/ / | | |
 |  __/| |  | |_| |/ /| | | (_| |   <| |_| |
 |_|   |_|   \__, /___|_|  \__,_|_|\_\\__, |
             |___/                    |___/


Ministry of Health --> sante.gov.dz

#pwned's by: Al1ne3737
Somos: Al1ne3737, PopTart, shap3r, Dext3r, Ergo, Mecz1nho, TkaTheGod, Asahi, mxc, Xoha.


Database: prive_db
[65 tables]
+----------------------+
| cab_gen              |
| cab_spe              |
| cabinet_param        |
| cabinets             |
| chir_den             |
| commune              |
| dairas               |
| dentiste             |
| diabetologie         |
| directeur_med        |
| directeur_tech       |
| directeur_tech_pharm |
| dirpharm_gross       |
| equip_radio          |
| equipement           |
| etat                 |
| etatc                |
| filiere              |
| forme                |
| garde                |
| gerant               |
| grossiste            |
| gynecologie          |
| hemodialyse          |
| histo_cab            |
| historique           |
| historique_gprive    |
| laboratoire          |
| medecin              |
| mov_cabs             |
| mov_gross            |
| mov_off              |
| nature               |
| officine             |
| ophtalement          |
| orl                  |
| perso_diab           |
| perso_gyneco         |
| perso_hymo           |
| perso_labo           |
| perso_med_diab       |
| perso_med_gyneco     |
| perso_med_hemod      |
| perso_med_opht       |
| perso_med_orl        |
| perso_med_pma        |
| perso_med_reduc      |
| perso_opht           |
| perso_orl            |
| perso_pma            |
| perso_radio          |
| perso_reduc          |
| perso_transp         |
| personne_phy_mor     |
| personnel_medical    |
| personnel_paramed    |
| pharmaci             |
| pharmacien           |
| radio                |
| reducation           |
| spec                 |
| specialite           |
| unite_stansp_san     |
| vehicule             |
| wilaya               |
+----------------------+


Database: prive_db
Table: mov_off
[7 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| act           | int(1)      |
| annee         | varchar(2)  |
| code_off      | varchar(11) |
| date_decision | date        |
| date_etat     | date        |
| etat          | varchar(2)  |
| ndecision     | varchar(20) |
+---------------+-------------+

Database: prive_db
Table: perso_med_hemod
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: perso_med_pma
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: directeur_tech_pharm
[12 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| actif           | int(1)       |
| annee           | varchar(2)   |
| code_dir        | varchar(15)  |
| date_dip        | date         |
| date_nais_dir   | date         |
| domicile_dir    | varchar(100) |
| email           | varchar(150) |
| nationalite_dir | char(3)      |
| nom_dir         | varchar(30)  |
| prenom_dir      | varchar(30)  |
| tel             | varchar(15)  |
| universite      | varchar(150) |
+-----------------+--------------+

Database: prive_db
Table: perso_pma
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: etatc
[2 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| ETAT     | varchar(2)  |
| LIB_ETAT | varchar(60) |
+----------+-------------+

Database: prive_db
Table: grossiste
[19 columns]
+--------------------------+---------------+
| Column                   | Type          |
+--------------------------+---------------+
| adresse                  | varchar(255)  |
| annee                    | varchar(4)    |
| code_commune             | varchar(4)    |
| code_etablissement_sisdz | varchar(25)   |
| code_g                   | varchar(11)   |
| COMMUNE                  | varchar(4)    |
| DATE_SAISI               | date          |
| email                    | varchar(150)  |
| forme_juridique          | varchar(2)    |
| latitude                 | double(18,16) |
| longitude                | double(18,16) |
| nature                   | varchar(2)    |
| nom_etablissement        | varchar(255)  |
| NUM_ORDRE                | varchar(4)    |
| OBS_ETAT                 | varchar(255)  |
| tel                      | varchar(150)  |
| type                     | varchar(30)   |
| url                      | varchar(255)  |
| WILAYA                   | varchar(2)    |
+--------------------------+---------------+

Database: prive_db
Table: medecin
[17 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| adresse_mail     | varchar(150) |
| annee            | varchar(2)   |
| commune_naiss    | varchar(4)   |
| Date_diplome     | date         |
| date_eq          | date         |
| date_naissance   | date         |
| ID_medecin       | varchar(11)  |
| Lieu_diplome     | varchar(255) |
| nationalite      | varchar(50)  |
| nom_jeune_fille  | varchar(100) |
| nom_medecin      | varchar(100) |
| num_securite_soc | varchar(15)  |
| NUM_TEL          | varchar(15)  |
| prenom_medecin   | varchar(100) |
| sex_medecin      | char(1)      |
| typedip          | varchar(30)  |
| wilaya_naissance | char(2)      |
+------------------+--------------+

Database: prive_db
Table: cab_gen
[14 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| ID_medecin | varchar(11) |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: historique_gprive
[5 columns]
+-----------+------------+
| Column    | Type       |
+-----------+------------+
| code_w    | varchar(4) |
| id        | int(11)    |
| nat       | varchar(2) |
| nb_saisis | int(6)     |
| nb_total  | int(11)    |
+-----------+------------+

Database: prive_db
Table: filiere
[2 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| code_fil    | varchar(3)  |
| libelle_fil | varchar(70) |
+-------------+-------------+

Database: prive_db
Table: gynecologie
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: radio
[15 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| CO_SPE     | varchar(3)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| ID_medecin | varchar(11) |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: hemodialyse
[17 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| capacite      | int(5)      |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| type_centre   | varchar(50) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: specialite
[5 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ABREVIATIO | varchar(6)  |
| CO_SPE     | varchar(3)  |
| LIB_SPE    | varchar(30) |
| SELECTION  | int(11)     |
| TY_SPE     | varchar(1)  |
+------------+-------------+

Database: prive_db
Table: unite_stansp_san
[15 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| annee         | varchar(2)   |
| CO_SPE        | varchar(3)   |
| code_phy_mor  | int(11)      |
| COMMUNE       | varchar(4)   |
| DATE_ETAT     | date         |
| date_ouvert   | date         |
| DATE_real     | date         |
| decision      | varchar(5)   |
| ETAT          | varchar(2)   |
| NATURE        | varchar(2)   |
| ndecis_ouvert | varchar(20)  |
| ndecis_real   | varchar(20)  |
| OBS_ETAT      | varchar(80)  |
| siege_soc     | varchar(100) |
| WILAYA        | varchar(2)   |
+---------------+--------------+

Database: prive_db
Table: perso_hymo
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: etat
[2 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| ETAT     | varchar(2)  |
| LIB_ETAT | varchar(40) |
+----------+-------------+

Database: prive_db
Table: cabinets
[26 columns]
+--------------------------+---------------+
| Column                   | Type          |
+--------------------------+---------------+
| adresse                  | varchar(80)   |
| annee                    | varchar(2)    |
| CO_SPE                   | varchar(3)    |
| code_com                 | varchar(4)    |
| code_commune             | varchar(4)    |
| code_etablissement_sisdz | varchar(11)   |
| date_aut                 | date          |
| date_decis_dsp           | date          |
| date_decision_msp        | date          |
| date_fin_validite        | date          |
| date_ouvert              | date          |
| DATE_SAISI               | date          |
| email                    | varchar(150)  |
| ID_medecin               | varchar(11)   |
| latitude                 | double(18,16) |
| longitude                | double(18,16) |
| NATURE                   | varchar(2)    |
| ndecision_dsp            | varchar(20)   |
| ndecision_msp            | varchar(20)   |
| nom_etablissement        | varchar(255)  |
| num_aut                  | varchar(10)   |
| NUM_ORDRE                | varchar(4)    |
| OBS_ETAT                 | varchar(80)   |
| tel                      | varchar(150)  |
| url                      | varchar(255)  |
| WILAYA                   | varchar(2)    |
+--------------------------+---------------+

Database: prive_db
Table: reducation
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: forme
[2 columns]
+-----------+-------------+
| Column    | Type        |
+-----------+-------------+
| coforme   | varchar(2)  |
| LIB_forme | varchar(10) |
+-----------+-------------+

Database: prive_db
Table: equipement
[2 columns]
+---------+--------------+
| Column  | Type         |
+---------+--------------+
| libelle | varchar(100) |
| num     | int(11)      |
+---------+--------------+

Database: prive_db
Table: perso_diab
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: perso_orl
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: mov_cabs
[7 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| act           | int(1)      |
| annee         | varchar(2)  |
| code_cab      | varchar(11) |
| date_decision | date        |
| date_etat     | date        |
| etat          | varchar(2)  |
| ndecision     | varchar(20) |
+---------------+-------------+

Database: prive_db
Table: officine
[21 columns]
+--------------------------+---------------+
| Column                   | Type          |
+--------------------------+---------------+
| adresse                  | varchar(255)  |
| annee                    | varchar(2)    |
| cadre_install            | varchar(1)    |
| code_com                 | varchar(4)    |
| code_commune             | varchar(4)    |
| code_etablissement_sisdz | varchar(11)   |
| code_pharm               | varchar(11)   |
| DATE_install             | date          |
| date_ouvert              | date          |
| email                    | varchar(150)  |
| latitude                 | double(18,16) |
| longitude                | double(18,16) |
| nature                   | varchar(2)    |
| ndecis_install           | varchar(20)   |
| ndecis_ouvert            | varchar(20)   |
| nom_etablissement        | varchar(255)  |
| NUM_ORDRE                | varchar(4)    |
| OBS_ETAT                 | varchar(80)   |
| tel                      | varchar(150)  |
| url                      | varchar(255)  |
| WILAYA                   | varchar(2)    |
+--------------------------+---------------+

Database: prive_db
Table: mov_gross
[8 columns]
+--------------------------+-------------+
| Column                   | Type        |
+--------------------------+-------------+
| actif                    | int(1)      |
| annee                    | varchar(2)  |
| code_etablissement_sisdz | varchar(25) |
| date_decision_g          | date        |
| DATE_ETAT                | date        |
| DATE_SAISI               | date        |
| ETAT                     | varchar(2)  |
| ndecision_g              | varchar(20) |
+--------------------------+-------------+

Database: prive_db
Table: perso_opht
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: personnel_paramed
[18 columns]
+-------------------+--------------+
| Column            | Type         |
+-------------------+--------------+
| actif             | int(1)       |
| code_pers         | int(11)      |
| commune_naissance | char(2)      |
| date_diplome      | date         |
| date_naiss        | date         |
| email             | varchar(150) |
| filiere           | varchar(50)  |
| lieu_diplome      | varchar(50)  |
| mode              | varchar(20)  |
| nationalite       | varchar(50)  |
| nom_jeune_fille   | varchar(100) |
| nom_pers          | varchar(30)  |
| num_securite_soc  | varchar(15)  |
| prenom_pers       | varchar(30)  |
| sex               | varchar(1)   |
| tel               | varchar(15)  |
| type_dip          | varchar(30)  |
| wilaya_naissance  | char(2)      |
+-------------------+--------------+

Database: prive_db
Table: perso_med_orl
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: perso_labo
[5 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| code_pers  | int(11)     |
| date_etat  | date        |
| etat       | varchar(10) |
| ID_medecin | varchar(11) |
| ndecision  | varchar(20) |
+------------+-------------+

Database: prive_db
Table: spec
[5 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ABREVIATIO | varchar(6)  |
| CO_SPE     | varchar(3)  |
| LIB_SPE    | varchar(30) |
| SELECTION  | int(11)     |
| TY_SPE     | varchar(1)  |
+------------+-------------+

Database: prive_db
Table: perso_med_gyneco
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: personne_phy_mor
[6 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| code_phy_mor     | int(11)      |
| denomination     | varchar(100) |
| nom_gerant       | varchar(50)  |
| nom_promoteur    | varchar(50)  |
| prenom_gerant    | varchar(50)  |
| prenom_promoteur | varchar(30)  |
+------------------+--------------+

Database: prive_db
Table: perso_transp
[6 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: commune
[6 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_com     | char(2)     |
| code_commune | varchar(4)  |
| code_epsp    | char(2)     |
| code_sec     | char(2)     |
| code_w       | char(2)     |
| commune      | varchar(25) |
+--------------+-------------+

Database: prive_db
Table: dirpharm_gross
[4 columns]
+--------------------------+-------------+
| Column                   | Type        |
+--------------------------+-------------+
| code_dir                 | varchar(15) |
| code_etablissement_sisdz | varchar(25) |
| date_decis               | date        |
| ndicision                | varchar(20) |
+--------------------------+-------------+

Database: prive_db
Table: nature
[3 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| CARACTEREN | varchar(1)  |
| LIBELLE    | varchar(70) |
| NATURE     | char(2)     |
+------------+-------------+

Database: prive_db
Table: laboratoire
[16 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| CO_SPE     | varchar(3)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| grade      | varchar(30) |
| ID_medecin | varchar(11) |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: garde
[3 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| code_pharm | varchar(11) |
| date_deb   | date        |
| heure_deb  | varchar(15) |
+------------+-------------+

Database: prive_db
Table: dairas
[3 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| CodeDaira  | varchar(4)   |
| CodeWilaya | varchar(2)   |
| NomDaira   | varchar(255) |
+------------+--------------+

Database: prive_db
Table: vehicule
[4 columns]
+-----------------+-------------+
| Column          | Type        |
+-----------------+-------------+
| categorie       | varchar(10) |
| code_phy_mor    | int(11)     |
| immatriculation | varchar(10) |
| numdecis        | varchar(20) |
+-----------------+-------------+

Database: prive_db
Table: perso_gyneco
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: dentiste
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: gerant
[10 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| adresse_mail     | varchar(150) |
| annee            | varchar(2)   |
| code_g           | varchar(11)  |
| date_naissance   | date         |
| domicile         | varchar(150) |
| nationalite      | varchar(50)  |
| nom_g            | varchar(100) |
| NUM_TEL          | varchar(15)  |
| prenom_g         | varchar(100) |
| wilaya_naissance | char(2)      |
+------------------+--------------+

Database: prive_db
Table: perso_med_opht
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: directeur_tech
[6 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| code_dir      | int(11)      |
| date_nais_dir | date         |
| email         | varchar(150) |
| nom_dir       | varchar(30)  |
| prenom_dir    | varchar(30)  |
| tel           | varchar(15)  |
+---------------+--------------+

Database: prive_db
Table: cabinet_param
[15 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| CO_SPE     | varchar(3)  |
| code_pers  | int(11)     |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: diabetologie
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: historique
[6 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| action        | varchar(100) |
| date          | datetime     |
| adresse_ip    | varchar(15)  |
| affiche       | int(11)      |
| id_historique | int(11)      |
| login         | varchar(100) |
+---------------+--------------+

Database: prive_db
Table: ophtalement
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: equip_radio
[5 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| etat       | varchar(10) |
| ID_medecin | int(11)     |
| nb         | int(11)     |
| ndecision  | varchar(20) |
| num        | int(11)     |
+------------+-------------+

Database: prive_db
Table: pharmacien
[11 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| actif            | int(1)       |
| adresse_mail     | varchar(150) |
| annee            | varchar(2)   |
| code_pharm       | varchar(11)  |
| date_dip         | date         |
| date_naissance   | date         |
| inscrip_ordre    | varchar(50)  |
| nom_pharm        | varchar(100) |
| NUM_TEL          | varchar(15)  |
| prenom_pharm     | varchar(100) |
| wilaya_naissance | char(2)      |
+------------------+--------------+

Database: prive_db
Table: perso_med_diab
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: wilaya
[3 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| code_region | char(2)     |
| code_w      | char(2)     |
| wilaya      | varchar(50) |
+-------------+-------------+

Database: prive_db
Table: chir_den
[15 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| CO_SPE     | varchar(3)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| ID_medecin | varchar(11) |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: directeur_med
[6 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| code_dir      | int(11)      |
| date_nais_dir | date         |
| email         | varchar(150) |
| nom_dir       | varchar(30)  |
| prenom_dir    | varchar(30)  |
| tel           | varchar(15)  |
+---------------+--------------+

Database: prive_db
Table: cab_spe
[15 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| annee      | varchar(2)  |
| CO_SPE     | varchar(3)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_SAISI | date        |
| decision   | varchar(5)  |
| ETAT       | varchar(2)  |
| ID_medecin | varchar(11) |
| NATURE     | varchar(2)  |
| ndecision  | varchar(20) |
| NUM_ORDRE  | varchar(4)  |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: personnel_medical
[9 columns]
+-------------------+--------------+
| Column            | Type         |
+-------------------+--------------+
| code_pers         | int(11)      |
| commune_naissance | char(2)      |
| date_naiss        | date         |
| email             | varchar(150) |
| mode              | varchar(20)  |
| nom_pers          | varchar(30)  |
| prenom_pers       | varchar(30)  |
| specialite        | varchar(50)  |
| wilaya_naissance  | char(2)      |
+-------------------+--------------+

Database: prive_db
Table: perso_radio
[5 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| code_pers  | int(11)     |
| date_etat  | date        |
| etat       | varchar(10) |
| ID_medecin | varchar(11) |
| ndecision  | varchar(20) |
+------------+-------------+

Database: prive_db
Table: perso_med_reduc
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: perso_reduc
[7 columns]
+--------------+-------------+
| Column       | Type        |
+--------------+-------------+
| code_dir     | int(11)     |
| code_pers    | int(11)     |
| code_phy_mor | int(11)     |
| date_etat    | date        |
| etat         | varchar(10) |
| ndecis_real  | varchar(20) |
| ndicision    | varchar(20) |
+--------------+-------------+

Database: prive_db
Table: orl
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| ADR_PROF      | varchar(80) |
| annee         | varchar(2)  |
| CO_SPE        | varchar(3)  |
| code_dir      | int(11)     |
| code_phy_mor  | int(11)     |
| COMMUNE       | varchar(4)  |
| DATE_ETAT     | date        |
| date_ouvert   | date        |
| DATE_real     | date        |
| ETAT          | varchar(2)  |
| ndecis_ouvert | varchar(20) |
| ndecis_real   | varchar(20) |
| NUM_ORDRE     | int(4)      |
| OBS_ETAT      | varchar(80) |
| WILAYA        | varchar(2)  |
+---------------+-------------+

Database: prive_db
Table: pharmaci
[19 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ADR_PROF   | varchar(80) |
| ADR_PROF1  | varchar(80) |
| CO_SPE     | varchar(3)  |
| CODE_PRAT  | varchar(8)  |
| COMMUNE    | varchar(4)  |
| DATE_DECIS | date        |
| DATE_ETAT  | date        |
| DATE_MSP   | date        |
| DATE_OUVER | date        |
| DATE_SAISI | date        |
| DECIS_DSP  | varchar(20) |
| DECIS_MSP  | varchar(20) |
| ETAT       | varchar(2)  |
| ID_medecin | int(11)     |
| NATURE     | varchar(2)  |
| NUM_ORDRE  | varchar(4)  |
| NUM_TEL    | varchar(15) |
| OBS_ETAT   | varchar(80) |
| WILAYA     | varchar(2)  |
+------------+-------------+

Database: prive_db
Table: histo_cab
[6 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| action        | varchar(100) |
| date          | datetime     |
| adresse_ip    | varchar(15)  |
| affiche       | int(11)      |
| id_historique | int(11)      |
| login         | varchar(100) |
+---------------+--------------+