Guest User

#OPALGERIA MINISTRY OF HEALTH

a guest
Mar 8th, 2019
259
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ____ _
  2. | _ \ _ __ _ _ _____ __ __ _| | ___ _
  3. | |_) | '__| | | |_ / '__/ _` | |/ / | | |
  4. | __/| | | |_| |/ /| | | (_| | <| |_| |
  5. |_| |_| \__, /___|_| \__,_|_|\_\\__, |
  6. |___/ |___/
  7.  
  8.  
  9. Ministry of Health --> sante.gov.dz
  10.  
  11. #pwned's by: Al1ne3737
  12. Somos: Al1ne3737, PopTart, shap3r, Dext3r, Ergo, Mecz1nho, TkaTheGod, Asahi, mxc, Xoha.
  13.  
  14.  
  15. Database: prive_db
  16. [65 tables]
  17. +----------------------+
  18. | cab_gen |
  19. | cab_spe |
  20. | cabinet_param |
  21. | cabinets |
  22. | chir_den |
  23. | commune |
  24. | dairas |
  25. | dentiste |
  26. | diabetologie |
  27. | directeur_med |
  28. | directeur_tech |
  29. | directeur_tech_pharm |
  30. | dirpharm_gross |
  31. | equip_radio |
  32. | equipement |
  33. | etat |
  34. | etatc |
  35. | filiere |
  36. | forme |
  37. | garde |
  38. | gerant |
  39. | grossiste |
  40. | gynecologie |
  41. | hemodialyse |
  42. | histo_cab |
  43. | historique |
  44. | historique_gprive |
  45. | laboratoire |
  46. | medecin |
  47. | mov_cabs |
  48. | mov_gross |
  49. | mov_off |
  50. | nature |
  51. | officine |
  52. | ophtalement |
  53. | orl |
  54. | perso_diab |
  55. | perso_gyneco |
  56. | perso_hymo |
  57. | perso_labo |
  58. | perso_med_diab |
  59. | perso_med_gyneco |
  60. | perso_med_hemod |
  61. | perso_med_opht |
  62. | perso_med_orl |
  63. | perso_med_pma |
  64. | perso_med_reduc |
  65. | perso_opht |
  66. | perso_orl |
  67. | perso_pma |
  68. | perso_radio |
  69. | perso_reduc |
  70. | perso_transp |
  71. | personne_phy_mor |
  72. | personnel_medical |
  73. | personnel_paramed |
  74. | pharmaci |
  75. | pharmacien |
  76. | radio |
  77. | reducation |
  78. | spec |
  79. | specialite |
  80. | unite_stansp_san |
  81. | vehicule |
  82. | wilaya |
  83. +----------------------+
  84.  
  85.  
  86. Database: prive_db
  87. Table: mov_off
  88. [7 columns]
  89. +---------------+-------------+
  90. | Column | Type |
  91. +---------------+-------------+
  92. | act | int(1) |
  93. | annee | varchar(2) |
  94. | code_off | varchar(11) |
  95. | date_decision | date |
  96. | date_etat | date |
  97. | etat | varchar(2) |
  98. | ndecision | varchar(20) |
  99. +---------------+-------------+
  100.  
  101. Database: prive_db
  102. Table: perso_med_hemod
  103. [7 columns]
  104. +--------------+-------------+
  105. | Column | Type |
  106. +--------------+-------------+
  107. | code_dir | int(11) |
  108. | code_pers | int(11) |
  109. | code_phy_mor | int(11) |
  110. | date_etat | date |
  111. | etat | varchar(10) |
  112. | ndecis_real | varchar(20) |
  113. | ndicision | varchar(20) |
  114. +--------------+-------------+
  115.  
  116. Database: prive_db
  117. Table: perso_med_pma
  118. [7 columns]
  119. +--------------+-------------+
  120. | Column | Type |
  121. +--------------+-------------+
  122. | code_dir | int(11) |
  123. | code_pers | int(11) |
  124. | code_phy_mor | int(11) |
  125. | date_etat | date |
  126. | etat | varchar(10) |
  127. | ndecis_real | varchar(20) |
  128. | ndicision | varchar(20) |
  129. +--------------+-------------+
  130.  
  131. Database: prive_db
  132. Table: directeur_tech_pharm
  133. [12 columns]
  134. +-----------------+--------------+
  135. | Column | Type |
  136. +-----------------+--------------+
  137. | actif | int(1) |
  138. | annee | varchar(2) |
  139. | code_dir | varchar(15) |
  140. | date_dip | date |
  141. | date_nais_dir | date |
  142. | domicile_dir | varchar(100) |
  143. | email | varchar(150) |
  144. | nationalite_dir | char(3) |
  145. | nom_dir | varchar(30) |
  146. | prenom_dir | varchar(30) |
  147. | tel | varchar(15) |
  148. | universite | varchar(150) |
  149. +-----------------+--------------+
  150.  
  151. Database: prive_db
  152. Table: perso_pma
  153. [7 columns]
  154. +--------------+-------------+
  155. | Column | Type |
  156. +--------------+-------------+
  157. | code_dir | int(11) |
  158. | code_pers | int(11) |
  159. | code_phy_mor | int(11) |
  160. | date_etat | date |
  161. | etat | varchar(10) |
  162. | ndecis_real | varchar(20) |
  163. | ndicision | varchar(20) |
  164. +--------------+-------------+
  165.  
  166. Database: prive_db
  167. Table: etatc
  168. [2 columns]
  169. +----------+-------------+
  170. | Column | Type |
  171. +----------+-------------+
  172. | ETAT | varchar(2) |
  173. | LIB_ETAT | varchar(60) |
  174. +----------+-------------+
  175.  
  176. Database: prive_db
  177. Table: grossiste
  178. [19 columns]
  179. +--------------------------+---------------+
  180. | Column | Type |
  181. +--------------------------+---------------+
  182. | adresse | varchar(255) |
  183. | annee | varchar(4) |
  184. | code_commune | varchar(4) |
  185. | code_etablissement_sisdz | varchar(25) |
  186. | code_g | varchar(11) |
  187. | COMMUNE | varchar(4) |
  188. | DATE_SAISI | date |
  189. | email | varchar(150) |
  190. | forme_juridique | varchar(2) |
  191. | latitude | double(18,16) |
  192. | longitude | double(18,16) |
  193. | nature | varchar(2) |
  194. | nom_etablissement | varchar(255) |
  195. | NUM_ORDRE | varchar(4) |
  196. | OBS_ETAT | varchar(255) |
  197. | tel | varchar(150) |
  198. | type | varchar(30) |
  199. | url | varchar(255) |
  200. | WILAYA | varchar(2) |
  201. +--------------------------+---------------+
  202.  
  203. Database: prive_db
  204. Table: medecin
  205. [17 columns]
  206. +------------------+--------------+
  207. | Column | Type |
  208. +------------------+--------------+
  209. | adresse_mail | varchar(150) |
  210. | annee | varchar(2) |
  211. | commune_naiss | varchar(4) |
  212. | Date_diplome | date |
  213. | date_eq | date |
  214. | date_naissance | date |
  215. | ID_medecin | varchar(11) |
  216. | Lieu_diplome | varchar(255) |
  217. | nationalite | varchar(50) |
  218. | nom_jeune_fille | varchar(100) |
  219. | nom_medecin | varchar(100) |
  220. | num_securite_soc | varchar(15) |
  221. | NUM_TEL | varchar(15) |
  222. | prenom_medecin | varchar(100) |
  223. | sex_medecin | char(1) |
  224. | typedip | varchar(30) |
  225. | wilaya_naissance | char(2) |
  226. +------------------+--------------+
  227.  
  228. Database: prive_db
  229. Table: cab_gen
  230. [14 columns]
  231. +------------+-------------+
  232. | Column | Type |
  233. +------------+-------------+
  234. | ADR_PROF | varchar(80) |
  235. | annee | varchar(2) |
  236. | COMMUNE | varchar(4) |
  237. | DATE_DECIS | date |
  238. | DATE_ETAT | date |
  239. | DATE_SAISI | date |
  240. | decision | varchar(5) |
  241. | ETAT | varchar(2) |
  242. | ID_medecin | varchar(11) |
  243. | NATURE | varchar(2) |
  244. | ndecision | varchar(20) |
  245. | NUM_ORDRE | varchar(4) |
  246. | OBS_ETAT | varchar(80) |
  247. | WILAYA | varchar(2) |
  248. +------------+-------------+
  249.  
  250. Database: prive_db
  251. Table: historique_gprive
  252. [5 columns]
  253. +-----------+------------+
  254. | Column | Type |
  255. +-----------+------------+
  256. | code_w | varchar(4) |
  257. | id | int(11) |
  258. | nat | varchar(2) |
  259. | nb_saisis | int(6) |
  260. | nb_total | int(11) |
  261. +-----------+------------+
  262.  
  263. Database: prive_db
  264. Table: filiere
  265. [2 columns]
  266. +-------------+-------------+
  267. | Column | Type |
  268. +-------------+-------------+
  269. | code_fil | varchar(3) |
  270. | libelle_fil | varchar(70) |
  271. +-------------+-------------+
  272.  
  273. Database: prive_db
  274. Table: gynecologie
  275. [15 columns]
  276. +---------------+-------------+
  277. | Column | Type |
  278. +---------------+-------------+
  279. | ADR_PROF | varchar(80) |
  280. | annee | varchar(2) |
  281. | CO_SPE | varchar(3) |
  282. | code_dir | int(11) |
  283. | code_phy_mor | int(11) |
  284. | COMMUNE | varchar(4) |
  285. | DATE_ETAT | date |
  286. | date_ouvert | date |
  287. | DATE_real | date |
  288. | ETAT | varchar(2) |
  289. | ndecis_ouvert | varchar(20) |
  290. | ndecis_real | varchar(20) |
  291. | NUM_ORDRE | int(4) |
  292. | OBS_ETAT | varchar(80) |
  293. | WILAYA | varchar(2) |
  294. +---------------+-------------+
  295.  
  296. Database: prive_db
  297. Table: radio
  298. [15 columns]
  299. +------------+-------------+
  300. | Column | Type |
  301. +------------+-------------+
  302. | ADR_PROF | varchar(80) |
  303. | annee | varchar(2) |
  304. | CO_SPE | varchar(3) |
  305. | COMMUNE | varchar(4) |
  306. | DATE_DECIS | date |
  307. | DATE_ETAT | date |
  308. | DATE_SAISI | date |
  309. | decision | varchar(5) |
  310. | ETAT | varchar(2) |
  311. | ID_medecin | varchar(11) |
  312. | NATURE | varchar(2) |
  313. | ndecision | varchar(20) |
  314. | NUM_ORDRE | varchar(4) |
  315. | OBS_ETAT | varchar(80) |
  316. | WILAYA | varchar(2) |
  317. +------------+-------------+
  318.  
  319. Database: prive_db
  320. Table: hemodialyse
  321. [17 columns]
  322. +---------------+-------------+
  323. | Column | Type |
  324. +---------------+-------------+
  325. | ADR_PROF | varchar(80) |
  326. | annee | varchar(2) |
  327. | capacite | int(5) |
  328. | CO_SPE | varchar(3) |
  329. | code_dir | int(11) |
  330. | code_phy_mor | int(11) |
  331. | COMMUNE | varchar(4) |
  332. | DATE_ETAT | date |
  333. | date_ouvert | date |
  334. | DATE_real | date |
  335. | ETAT | varchar(2) |
  336. | ndecis_ouvert | varchar(20) |
  337. | ndecis_real | varchar(20) |
  338. | NUM_ORDRE | int(4) |
  339. | OBS_ETAT | varchar(80) |
  340. | type_centre | varchar(50) |
  341. | WILAYA | varchar(2) |
  342. +---------------+-------------+
  343.  
  344. Database: prive_db
  345. Table: specialite
  346. [5 columns]
  347. +------------+-------------+
  348. | Column | Type |
  349. +------------+-------------+
  350. | ABREVIATIO | varchar(6) |
  351. | CO_SPE | varchar(3) |
  352. | LIB_SPE | varchar(30) |
  353. | SELECTION | int(11) |
  354. | TY_SPE | varchar(1) |
  355. +------------+-------------+
  356.  
  357. Database: prive_db
  358. Table: unite_stansp_san
  359. [15 columns]
  360. +---------------+--------------+
  361. | Column | Type |
  362. +---------------+--------------+
  363. | annee | varchar(2) |
  364. | CO_SPE | varchar(3) |
  365. | code_phy_mor | int(11) |
  366. | COMMUNE | varchar(4) |
  367. | DATE_ETAT | date |
  368. | date_ouvert | date |
  369. | DATE_real | date |
  370. | decision | varchar(5) |
  371. | ETAT | varchar(2) |
  372. | NATURE | varchar(2) |
  373. | ndecis_ouvert | varchar(20) |
  374. | ndecis_real | varchar(20) |
  375. | OBS_ETAT | varchar(80) |
  376. | siege_soc | varchar(100) |
  377. | WILAYA | varchar(2) |
  378. +---------------+--------------+
  379.  
  380. Database: prive_db
  381. Table: perso_hymo
  382. [7 columns]
  383. +--------------+-------------+
  384. | Column | Type |
  385. +--------------+-------------+
  386. | code_dir | int(11) |
  387. | code_pers | int(11) |
  388. | code_phy_mor | int(11) |
  389. | date_etat | date |
  390. | etat | varchar(10) |
  391. | ndecis_real | varchar(20) |
  392. | ndicision | varchar(20) |
  393. +--------------+-------------+
  394.  
  395. Database: prive_db
  396. Table: etat
  397. [2 columns]
  398. +----------+-------------+
  399. | Column | Type |
  400. +----------+-------------+
  401. | ETAT | varchar(2) |
  402. | LIB_ETAT | varchar(40) |
  403. +----------+-------------+
  404.  
  405. Database: prive_db
  406. Table: cabinets
  407. [26 columns]
  408. +--------------------------+---------------+
  409. | Column | Type |
  410. +--------------------------+---------------+
  411. | adresse | varchar(80) |
  412. | annee | varchar(2) |
  413. | CO_SPE | varchar(3) |
  414. | code_com | varchar(4) |
  415. | code_commune | varchar(4) |
  416. | code_etablissement_sisdz | varchar(11) |
  417. | date_aut | date |
  418. | date_decis_dsp | date |
  419. | date_decision_msp | date |
  420. | date_fin_validite | date |
  421. | date_ouvert | date |
  422. | DATE_SAISI | date |
  423. | email | varchar(150) |
  424. | ID_medecin | varchar(11) |
  425. | latitude | double(18,16) |
  426. | longitude | double(18,16) |
  427. | NATURE | varchar(2) |
  428. | ndecision_dsp | varchar(20) |
  429. | ndecision_msp | varchar(20) |
  430. | nom_etablissement | varchar(255) |
  431. | num_aut | varchar(10) |
  432. | NUM_ORDRE | varchar(4) |
  433. | OBS_ETAT | varchar(80) |
  434. | tel | varchar(150) |
  435. | url | varchar(255) |
  436. | WILAYA | varchar(2) |
  437. +--------------------------+---------------+
  438.  
  439. Database: prive_db
  440. Table: reducation
  441. [15 columns]
  442. +---------------+-------------+
  443. | Column | Type |
  444. +---------------+-------------+
  445. | ADR_PROF | varchar(80) |
  446. | annee | varchar(2) |
  447. | CO_SPE | varchar(3) |
  448. | code_dir | int(11) |
  449. | code_phy_mor | int(11) |
  450. | COMMUNE | varchar(4) |
  451. | DATE_ETAT | date |
  452. | date_ouvert | date |
  453. | DATE_real | date |
  454. | ETAT | varchar(2) |
  455. | ndecis_ouvert | varchar(20) |
  456. | ndecis_real | varchar(20) |
  457. | NUM_ORDRE | int(4) |
  458. | OBS_ETAT | varchar(80) |
  459. | WILAYA | varchar(2) |
  460. +---------------+-------------+
  461.  
  462. Database: prive_db
  463. Table: forme
  464. [2 columns]
  465. +-----------+-------------+
  466. | Column | Type |
  467. +-----------+-------------+
  468. | coforme | varchar(2) |
  469. | LIB_forme | varchar(10) |
  470. +-----------+-------------+
  471.  
  472. Database: prive_db
  473. Table: equipement
  474. [2 columns]
  475. +---------+--------------+
  476. | Column | Type |
  477. +---------+--------------+
  478. | libelle | varchar(100) |
  479. | num | int(11) |
  480. +---------+--------------+
  481.  
  482. Database: prive_db
  483. Table: perso_diab
  484. [7 columns]
  485. +--------------+-------------+
  486. | Column | Type |
  487. +--------------+-------------+
  488. | code_dir | int(11) |
  489. | code_pers | int(11) |
  490. | code_phy_mor | int(11) |
  491. | date_etat | date |
  492. | etat | varchar(10) |
  493. | ndecis_real | varchar(20) |
  494. | ndicision | varchar(20) |
  495. +--------------+-------------+
  496.  
  497. Database: prive_db
  498. Table: perso_orl
  499. [7 columns]
  500. +--------------+-------------+
  501. | Column | Type |
  502. +--------------+-------------+
  503. | code_dir | int(11) |
  504. | code_pers | int(11) |
  505. | code_phy_mor | int(11) |
  506. | date_etat | date |
  507. | etat | varchar(10) |
  508. | ndecis_real | varchar(20) |
  509. | ndicision | varchar(20) |
  510. +--------------+-------------+
  511.  
  512. Database: prive_db
  513. Table: mov_cabs
  514. [7 columns]
  515. +---------------+-------------+
  516. | Column | Type |
  517. +---------------+-------------+
  518. | act | int(1) |
  519. | annee | varchar(2) |
  520. | code_cab | varchar(11) |
  521. | date_decision | date |
  522. | date_etat | date |
  523. | etat | varchar(2) |
  524. | ndecision | varchar(20) |
  525. +---------------+-------------+
  526.  
  527. Database: prive_db
  528. Table: officine
  529. [21 columns]
  530. +--------------------------+---------------+
  531. | Column | Type |
  532. +--------------------------+---------------+
  533. | adresse | varchar(255) |
  534. | annee | varchar(2) |
  535. | cadre_install | varchar(1) |
  536. | code_com | varchar(4) |
  537. | code_commune | varchar(4) |
  538. | code_etablissement_sisdz | varchar(11) |
  539. | code_pharm | varchar(11) |
  540. | DATE_install | date |
  541. | date_ouvert | date |
  542. | email | varchar(150) |
  543. | latitude | double(18,16) |
  544. | longitude | double(18,16) |
  545. | nature | varchar(2) |
  546. | ndecis_install | varchar(20) |
  547. | ndecis_ouvert | varchar(20) |
  548. | nom_etablissement | varchar(255) |
  549. | NUM_ORDRE | varchar(4) |
  550. | OBS_ETAT | varchar(80) |
  551. | tel | varchar(150) |
  552. | url | varchar(255) |
  553. | WILAYA | varchar(2) |
  554. +--------------------------+---------------+
  555.  
  556. Database: prive_db
  557. Table: mov_gross
  558. [8 columns]
  559. +--------------------------+-------------+
  560. | Column | Type |
  561. +--------------------------+-------------+
  562. | actif | int(1) |
  563. | annee | varchar(2) |
  564. | code_etablissement_sisdz | varchar(25) |
  565. | date_decision_g | date |
  566. | DATE_ETAT | date |
  567. | DATE_SAISI | date |
  568. | ETAT | varchar(2) |
  569. | ndecision_g | varchar(20) |
  570. +--------------------------+-------------+
  571.  
  572. Database: prive_db
  573. Table: perso_opht
  574. [7 columns]
  575. +--------------+-------------+
  576. | Column | Type |
  577. +--------------+-------------+
  578. | code_dir | int(11) |
  579. | code_pers | int(11) |
  580. | code_phy_mor | int(11) |
  581. | date_etat | date |
  582. | etat | varchar(10) |
  583. | ndecis_real | varchar(20) |
  584. | ndicision | varchar(20) |
  585. +--------------+-------------+
  586.  
  587. Database: prive_db
  588. Table: personnel_paramed
  589. [18 columns]
  590. +-------------------+--------------+
  591. | Column | Type |
  592. +-------------------+--------------+
  593. | actif | int(1) |
  594. | code_pers | int(11) |
  595. | commune_naissance | char(2) |
  596. | date_diplome | date |
  597. | date_naiss | date |
  598. | email | varchar(150) |
  599. | filiere | varchar(50) |
  600. | lieu_diplome | varchar(50) |
  601. | mode | varchar(20) |
  602. | nationalite | varchar(50) |
  603. | nom_jeune_fille | varchar(100) |
  604. | nom_pers | varchar(30) |
  605. | num_securite_soc | varchar(15) |
  606. | prenom_pers | varchar(30) |
  607. | sex | varchar(1) |
  608. | tel | varchar(15) |
  609. | type_dip | varchar(30) |
  610. | wilaya_naissance | char(2) |
  611. +-------------------+--------------+
  612.  
  613. Database: prive_db
  614. Table: perso_med_orl
  615. [7 columns]
  616. +--------------+-------------+
  617. | Column | Type |
  618. +--------------+-------------+
  619. | code_dir | int(11) |
  620. | code_pers | int(11) |
  621. | code_phy_mor | int(11) |
  622. | date_etat | date |
  623. | etat | varchar(10) |
  624. | ndecis_real | varchar(20) |
  625. | ndicision | varchar(20) |
  626. +--------------+-------------+
  627.  
  628. Database: prive_db
  629. Table: perso_labo
  630. [5 columns]
  631. +------------+-------------+
  632. | Column | Type |
  633. +------------+-------------+
  634. | code_pers | int(11) |
  635. | date_etat | date |
  636. | etat | varchar(10) |
  637. | ID_medecin | varchar(11) |
  638. | ndecision | varchar(20) |
  639. +------------+-------------+
  640.  
  641. Database: prive_db
  642. Table: spec
  643. [5 columns]
  644. +------------+-------------+
  645. | Column | Type |
  646. +------------+-------------+
  647. | ABREVIATIO | varchar(6) |
  648. | CO_SPE | varchar(3) |
  649. | LIB_SPE | varchar(30) |
  650. | SELECTION | int(11) |
  651. | TY_SPE | varchar(1) |
  652. +------------+-------------+
  653.  
  654. Database: prive_db
  655. Table: perso_med_gyneco
  656. [7 columns]
  657. +--------------+-------------+
  658. | Column | Type |
  659. +--------------+-------------+
  660. | code_dir | int(11) |
  661. | code_pers | int(11) |
  662. | code_phy_mor | int(11) |
  663. | date_etat | date |
  664. | etat | varchar(10) |
  665. | ndecis_real | varchar(20) |
  666. | ndicision | varchar(20) |
  667. +--------------+-------------+
  668.  
  669. Database: prive_db
  670. Table: personne_phy_mor
  671. [6 columns]
  672. +------------------+--------------+
  673. | Column | Type |
  674. +------------------+--------------+
  675. | code_phy_mor | int(11) |
  676. | denomination | varchar(100) |
  677. | nom_gerant | varchar(50) |
  678. | nom_promoteur | varchar(50) |
  679. | prenom_gerant | varchar(50) |
  680. | prenom_promoteur | varchar(30) |
  681. +------------------+--------------+
  682.  
  683. Database: prive_db
  684. Table: perso_transp
  685. [6 columns]
  686. +--------------+-------------+
  687. | Column | Type |
  688. +--------------+-------------+
  689. | code_pers | int(11) |
  690. | code_phy_mor | int(11) |
  691. | date_etat | date |
  692. | etat | varchar(10) |
  693. | ndecis_real | varchar(20) |
  694. | ndicision | varchar(20) |
  695. +--------------+-------------+
  696.  
  697. Database: prive_db
  698. Table: commune
  699. [6 columns]
  700. +--------------+-------------+
  701. | Column | Type |
  702. +--------------+-------------+
  703. | code_com | char(2) |
  704. | code_commune | varchar(4) |
  705. | code_epsp | char(2) |
  706. | code_sec | char(2) |
  707. | code_w | char(2) |
  708. | commune | varchar(25) |
  709. +--------------+-------------+
  710.  
  711. Database: prive_db
  712. Table: dirpharm_gross
  713. [4 columns]
  714. +--------------------------+-------------+
  715. | Column | Type |
  716. +--------------------------+-------------+
  717. | code_dir | varchar(15) |
  718. | code_etablissement_sisdz | varchar(25) |
  719. | date_decis | date |
  720. | ndicision | varchar(20) |
  721. +--------------------------+-------------+
  722.  
  723. Database: prive_db
  724. Table: nature
  725. [3 columns]
  726. +------------+-------------+
  727. | Column | Type |
  728. +------------+-------------+
  729. | CARACTEREN | varchar(1) |
  730. | LIBELLE | varchar(70) |
  731. | NATURE | char(2) |
  732. +------------+-------------+
  733.  
  734. Database: prive_db
  735. Table: laboratoire
  736. [16 columns]
  737. +------------+-------------+
  738. | Column | Type |
  739. +------------+-------------+
  740. | ADR_PROF | varchar(80) |
  741. | annee | varchar(2) |
  742. | CO_SPE | varchar(3) |
  743. | COMMUNE | varchar(4) |
  744. | DATE_DECIS | date |
  745. | DATE_ETAT | date |
  746. | DATE_SAISI | date |
  747. | decision | varchar(5) |
  748. | ETAT | varchar(2) |
  749. | grade | varchar(30) |
  750. | ID_medecin | varchar(11) |
  751. | NATURE | varchar(2) |
  752. | ndecision | varchar(20) |
  753. | NUM_ORDRE | varchar(4) |
  754. | OBS_ETAT | varchar(80) |
  755. | WILAYA | varchar(2) |
  756. +------------+-------------+
  757.  
  758. Database: prive_db
  759. Table: garde
  760. [3 columns]
  761. +------------+-------------+
  762. | Column | Type |
  763. +------------+-------------+
  764. | code_pharm | varchar(11) |
  765. | date_deb | date |
  766. | heure_deb | varchar(15) |
  767. +------------+-------------+
  768.  
  769. Database: prive_db
  770. Table: dairas
  771. [3 columns]
  772. +------------+--------------+
  773. | Column | Type |
  774. +------------+--------------+
  775. | CodeDaira | varchar(4) |
  776. | CodeWilaya | varchar(2) |
  777. | NomDaira | varchar(255) |
  778. +------------+--------------+
  779.  
  780. Database: prive_db
  781. Table: vehicule
  782. [4 columns]
  783. +-----------------+-------------+
  784. | Column | Type |
  785. +-----------------+-------------+
  786. | categorie | varchar(10) |
  787. | code_phy_mor | int(11) |
  788. | immatriculation | varchar(10) |
  789. | numdecis | varchar(20) |
  790. +-----------------+-------------+
  791.  
  792. Database: prive_db
  793. Table: perso_gyneco
  794. [7 columns]
  795. +--------------+-------------+
  796. | Column | Type |
  797. +--------------+-------------+
  798. | code_dir | int(11) |
  799. | code_pers | int(11) |
  800. | code_phy_mor | int(11) |
  801. | date_etat | date |
  802. | etat | varchar(10) |
  803. | ndecis_real | varchar(20) |
  804. | ndicision | varchar(20) |
  805. +--------------+-------------+
  806.  
  807. Database: prive_db
  808. Table: dentiste
  809. [15 columns]
  810. +---------------+-------------+
  811. | Column | Type |
  812. +---------------+-------------+
  813. | ADR_PROF | varchar(80) |
  814. | annee | varchar(2) |
  815. | CO_SPE | varchar(3) |
  816. | code_dir | int(11) |
  817. | code_phy_mor | int(11) |
  818. | COMMUNE | varchar(4) |
  819. | DATE_ETAT | date |
  820. | date_ouvert | date |
  821. | DATE_real | date |
  822. | ETAT | varchar(2) |
  823. | ndecis_ouvert | varchar(20) |
  824. | ndecis_real | varchar(20) |
  825. | NUM_ORDRE | int(4) |
  826. | OBS_ETAT | varchar(80) |
  827. | WILAYA | varchar(2) |
  828. +---------------+-------------+
  829.  
  830. Database: prive_db
  831. Table: gerant
  832. [10 columns]
  833. +------------------+--------------+
  834. | Column | Type |
  835. +------------------+--------------+
  836. | adresse_mail | varchar(150) |
  837. | annee | varchar(2) |
  838. | code_g | varchar(11) |
  839. | date_naissance | date |
  840. | domicile | varchar(150) |
  841. | nationalite | varchar(50) |
  842. | nom_g | varchar(100) |
  843. | NUM_TEL | varchar(15) |
  844. | prenom_g | varchar(100) |
  845. | wilaya_naissance | char(2) |
  846. +------------------+--------------+
  847.  
  848. Database: prive_db
  849. Table: perso_med_opht
  850. [7 columns]
  851. +--------------+-------------+
  852. | Column | Type |
  853. +--------------+-------------+
  854. | code_dir | int(11) |
  855. | code_pers | int(11) |
  856. | code_phy_mor | int(11) |
  857. | date_etat | date |
  858. | etat | varchar(10) |
  859. | ndecis_real | varchar(20) |
  860. | ndicision | varchar(20) |
  861. +--------------+-------------+
  862.  
  863. Database: prive_db
  864. Table: directeur_tech
  865. [6 columns]
  866. +---------------+--------------+
  867. | Column | Type |
  868. +---------------+--------------+
  869. | code_dir | int(11) |
  870. | date_nais_dir | date |
  871. | email | varchar(150) |
  872. | nom_dir | varchar(30) |
  873. | prenom_dir | varchar(30) |
  874. | tel | varchar(15) |
  875. +---------------+--------------+
  876.  
  877. Database: prive_db
  878. Table: cabinet_param
  879. [15 columns]
  880. +------------+-------------+
  881. | Column | Type |
  882. +------------+-------------+
  883. | ADR_PROF | varchar(80) |
  884. | annee | varchar(2) |
  885. | CO_SPE | varchar(3) |
  886. | code_pers | int(11) |
  887. | COMMUNE | varchar(4) |
  888. | DATE_DECIS | date |
  889. | DATE_ETAT | date |
  890. | DATE_SAISI | date |
  891. | decision | varchar(5) |
  892. | ETAT | varchar(2) |
  893. | NATURE | varchar(2) |
  894. | ndecision | varchar(20) |
  895. | NUM_ORDRE | varchar(4) |
  896. | OBS_ETAT | varchar(80) |
  897. | WILAYA | varchar(2) |
  898. +------------+-------------+
  899.  
  900. Database: prive_db
  901. Table: diabetologie
  902. [15 columns]
  903. +---------------+-------------+
  904. | Column | Type |
  905. +---------------+-------------+
  906. | ADR_PROF | varchar(80) |
  907. | annee | varchar(2) |
  908. | CO_SPE | varchar(3) |
  909. | code_dir | int(11) |
  910. | code_phy_mor | int(11) |
  911. | COMMUNE | varchar(4) |
  912. | DATE_ETAT | date |
  913. | date_ouvert | date |
  914. | DATE_real | date |
  915. | ETAT | varchar(2) |
  916. | ndecis_ouvert | varchar(20) |
  917. | ndecis_real | varchar(20) |
  918. | NUM_ORDRE | int(4) |
  919. | OBS_ETAT | varchar(80) |
  920. | WILAYA | varchar(2) |
  921. +---------------+-------------+
  922.  
  923. Database: prive_db
  924. Table: historique
  925. [6 columns]
  926. +---------------+--------------+
  927. | Column | Type |
  928. +---------------+--------------+
  929. | action | varchar(100) |
  930. | date | datetime |
  931. | adresse_ip | varchar(15) |
  932. | affiche | int(11) |
  933. | id_historique | int(11) |
  934. | login | varchar(100) |
  935. +---------------+--------------+
  936.  
  937. Database: prive_db
  938. Table: ophtalement
  939. [15 columns]
  940. +---------------+-------------+
  941. | Column | Type |
  942. +---------------+-------------+
  943. | ADR_PROF | varchar(80) |
  944. | annee | varchar(2) |
  945. | CO_SPE | varchar(3) |
  946. | code_dir | int(11) |
  947. | code_phy_mor | int(11) |
  948. | COMMUNE | varchar(4) |
  949. | DATE_ETAT | date |
  950. | date_ouvert | date |
  951. | DATE_real | date |
  952. | ETAT | varchar(2) |
  953. | ndecis_ouvert | varchar(20) |
  954. | ndecis_real | varchar(20) |
  955. | NUM_ORDRE | int(4) |
  956. | OBS_ETAT | varchar(80) |
  957. | WILAYA | varchar(2) |
  958. +---------------+-------------+
  959.  
  960. Database: prive_db
  961. Table: equip_radio
  962. [5 columns]
  963. +------------+-------------+
  964. | Column | Type |
  965. +------------+-------------+
  966. | etat | varchar(10) |
  967. | ID_medecin | int(11) |
  968. | nb | int(11) |
  969. | ndecision | varchar(20) |
  970. | num | int(11) |
  971. +------------+-------------+
  972.  
  973. Database: prive_db
  974. Table: pharmacien
  975. [11 columns]
  976. +------------------+--------------+
  977. | Column | Type |
  978. +------------------+--------------+
  979. | actif | int(1) |
  980. | adresse_mail | varchar(150) |
  981. | annee | varchar(2) |
  982. | code_pharm | varchar(11) |
  983. | date_dip | date |
  984. | date_naissance | date |
  985. | inscrip_ordre | varchar(50) |
  986. | nom_pharm | varchar(100) |
  987. | NUM_TEL | varchar(15) |
  988. | prenom_pharm | varchar(100) |
  989. | wilaya_naissance | char(2) |
  990. +------------------+--------------+
  991.  
  992. Database: prive_db
  993. Table: perso_med_diab
  994. [7 columns]
  995. +--------------+-------------+
  996. | Column | Type |
  997. +--------------+-------------+
  998. | code_dir | int(11) |
  999. | code_pers | int(11) |
  1000. | code_phy_mor | int(11) |
  1001. | date_etat | date |
  1002. | etat | varchar(10) |
  1003. | ndecis_real | varchar(20) |
  1004. | ndicision | varchar(20) |
  1005. +--------------+-------------+
  1006.  
  1007. Database: prive_db
  1008. Table: wilaya
  1009. [3 columns]
  1010. +-------------+-------------+
  1011. | Column | Type |
  1012. +-------------+-------------+
  1013. | code_region | char(2) |
  1014. | code_w | char(2) |
  1015. | wilaya | varchar(50) |
  1016. +-------------+-------------+
  1017.  
  1018. Database: prive_db
  1019. Table: chir_den
  1020. [15 columns]
  1021. +------------+-------------+
  1022. | Column | Type |
  1023. +------------+-------------+
  1024. | ADR_PROF | varchar(80) |
  1025. | annee | varchar(2) |
  1026. | CO_SPE | varchar(3) |
  1027. | COMMUNE | varchar(4) |
  1028. | DATE_DECIS | date |
  1029. | DATE_ETAT | date |
  1030. | DATE_SAISI | date |
  1031. | decision | varchar(5) |
  1032. | ETAT | varchar(2) |
  1033. | ID_medecin | varchar(11) |
  1034. | NATURE | varchar(2) |
  1035. | ndecision | varchar(20) |
  1036. | NUM_ORDRE | varchar(4) |
  1037. | OBS_ETAT | varchar(80) |
  1038. | WILAYA | varchar(2) |
  1039. +------------+-------------+
  1040.  
  1041. Database: prive_db
  1042. Table: directeur_med
  1043. [6 columns]
  1044. +---------------+--------------+
  1045. | Column | Type |
  1046. +---------------+--------------+
  1047. | code_dir | int(11) |
  1048. | date_nais_dir | date |
  1049. | email | varchar(150) |
  1050. | nom_dir | varchar(30) |
  1051. | prenom_dir | varchar(30) |
  1052. | tel | varchar(15) |
  1053. +---------------+--------------+
  1054.  
  1055. Database: prive_db
  1056. Table: cab_spe
  1057. [15 columns]
  1058. +------------+-------------+
  1059. | Column | Type |
  1060. +------------+-------------+
  1061. | ADR_PROF | varchar(80) |
  1062. | annee | varchar(2) |
  1063. | CO_SPE | varchar(3) |
  1064. | COMMUNE | varchar(4) |
  1065. | DATE_DECIS | date |
  1066. | DATE_ETAT | date |
  1067. | DATE_SAISI | date |
  1068. | decision | varchar(5) |
  1069. | ETAT | varchar(2) |
  1070. | ID_medecin | varchar(11) |
  1071. | NATURE | varchar(2) |
  1072. | ndecision | varchar(20) |
  1073. | NUM_ORDRE | varchar(4) |
  1074. | OBS_ETAT | varchar(80) |
  1075. | WILAYA | varchar(2) |
  1076. +------------+-------------+
  1077.  
  1078. Database: prive_db
  1079. Table: personnel_medical
  1080. [9 columns]
  1081. +-------------------+--------------+
  1082. | Column | Type |
  1083. +-------------------+--------------+
  1084. | code_pers | int(11) |
  1085. | commune_naissance | char(2) |
  1086. | date_naiss | date |
  1087. | email | varchar(150) |
  1088. | mode | varchar(20) |
  1089. | nom_pers | varchar(30) |
  1090. | prenom_pers | varchar(30) |
  1091. | specialite | varchar(50) |
  1092. | wilaya_naissance | char(2) |
  1093. +-------------------+--------------+
  1094.  
  1095. Database: prive_db
  1096. Table: perso_radio
  1097. [5 columns]
  1098. +------------+-------------+
  1099. | Column | Type |
  1100. +------------+-------------+
  1101. | code_pers | int(11) |
  1102. | date_etat | date |
  1103. | etat | varchar(10) |
  1104. | ID_medecin | varchar(11) |
  1105. | ndecision | varchar(20) |
  1106. +------------+-------------+
  1107.  
  1108. Database: prive_db
  1109. Table: perso_med_reduc
  1110. [7 columns]
  1111. +--------------+-------------+
  1112. | Column | Type |
  1113. +--------------+-------------+
  1114. | code_dir | int(11) |
  1115. | code_pers | int(11) |
  1116. | code_phy_mor | int(11) |
  1117. | date_etat | date |
  1118. | etat | varchar(10) |
  1119. | ndecis_real | varchar(20) |
  1120. | ndicision | varchar(20) |
  1121. +--------------+-------------+
  1122.  
  1123. Database: prive_db
  1124. Table: perso_reduc
  1125. [7 columns]
  1126. +--------------+-------------+
  1127. | Column | Type |
  1128. +--------------+-------------+
  1129. | code_dir | int(11) |
  1130. | code_pers | int(11) |
  1131. | code_phy_mor | int(11) |
  1132. | date_etat | date |
  1133. | etat | varchar(10) |
  1134. | ndecis_real | varchar(20) |
  1135. | ndicision | varchar(20) |
  1136. +--------------+-------------+
  1137.  
  1138. Database: prive_db
  1139. Table: orl
  1140. [15 columns]
  1141. +---------------+-------------+
  1142. | Column | Type |
  1143. +---------------+-------------+
  1144. | ADR_PROF | varchar(80) |
  1145. | annee | varchar(2) |
  1146. | CO_SPE | varchar(3) |
  1147. | code_dir | int(11) |
  1148. | code_phy_mor | int(11) |
  1149. | COMMUNE | varchar(4) |
  1150. | DATE_ETAT | date |
  1151. | date_ouvert | date |
  1152. | DATE_real | date |
  1153. | ETAT | varchar(2) |
  1154. | ndecis_ouvert | varchar(20) |
  1155. | ndecis_real | varchar(20) |
  1156. | NUM_ORDRE | int(4) |
  1157. | OBS_ETAT | varchar(80) |
  1158. | WILAYA | varchar(2) |
  1159. +---------------+-------------+
  1160.  
  1161. Database: prive_db
  1162. Table: pharmaci
  1163. [19 columns]
  1164. +------------+-------------+
  1165. | Column | Type |
  1166. +------------+-------------+
  1167. | ADR_PROF | varchar(80) |
  1168. | ADR_PROF1 | varchar(80) |
  1169. | CO_SPE | varchar(3) |
  1170. | CODE_PRAT | varchar(8) |
  1171. | COMMUNE | varchar(4) |
  1172. | DATE_DECIS | date |
  1173. | DATE_ETAT | date |
  1174. | DATE_MSP | date |
  1175. | DATE_OUVER | date |
  1176. | DATE_SAISI | date |
  1177. | DECIS_DSP | varchar(20) |
  1178. | DECIS_MSP | varchar(20) |
  1179. | ETAT | varchar(2) |
  1180. | ID_medecin | int(11) |
  1181. | NATURE | varchar(2) |
  1182. | NUM_ORDRE | varchar(4) |
  1183. | NUM_TEL | varchar(15) |
  1184. | OBS_ETAT | varchar(80) |
  1185. | WILAYA | varchar(2) |
  1186. +------------+-------------+
  1187.  
  1188. Database: prive_db
  1189. Table: histo_cab
  1190. [6 columns]
  1191. +---------------+--------------+
  1192. | Column | Type |
  1193. +---------------+--------------+
  1194. | action | varchar(100) |
  1195. | date | datetime |
  1196. | adresse_ip | varchar(15) |
  1197. | affiche | int(11) |
  1198. | id_historique | int(11) |
  1199. | login | varchar(100) |
  1200. +---------------+--------------+
RAW Paste Data