· 8 years ago · Nov 23, 2017, 10:00 AM
1-- Adminer 4.3.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `echantillon`;
9CREATE TABLE `echantillon` (
10 `ECH_CODE` int(11) DEFAULT NULL,
11 `ECH_PRIXHT` double DEFAULT NULL,
12 `MED_DEPOTLEGAL` varchar(9) DEFAULT NULL,
13 KEY `MED_DEPOTLEGAL` (`MED_DEPOTLEGAL`),
14 CONSTRAINT `echantillon_ibfk_1` FOREIGN KEY (`MED_DEPOTLEGAL`) REFERENCES `medicament` (`MED_DEPOTLEGAL`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
17INSERT INTO `echantillon` (`ECH_CODE`, `ECH_PRIXHT`, `MED_DEPOTLEGAL`) VALUES
18(1, 4, '3MYC7'),
19(2, 2, 'AMOPIL7'),
20(3, 1, 'AMOXIG12'),
21(4, 0.5, 'AMOXIG12'),
22(5, 0.3, 'POMDI20'),
23(6, 0.1, 'JOVAI8'),
24(7, 10, 'DIMIRTAM6'),
25(8, 5, 'TROXT21'),
26(9, 3.2, 'JOVAI8'),
27(10, 2.1, 'DIMIRTAM6'),
28(11, 0.5, 'URIEG6'),
29(12, 0.7, 'DOLRIL7'),
30(13, 0.8, 'TXISOL22'),
31(14, 1, 'DORNOM8'),
32(15, 1.8, 'PIRIZ8'),
33(16, 6, 'EVILR7'),
34(17, 0.21, 'EVILR7'),
35(18, 0.37, 'INSXT5'),
36(19, 0.48, 'TXISOL22'),
37(20, 0.98, 'LIDOXY23'),
38(21, 1.5, 'LIDOXY23'),
39(22, 1.78, 'TXISOL22'),
40(23, 1.56, 'LIDOXY23'),
41(24, 2.58, 'URIEG6'),
42(25, 1.48, 'EQUILARX6'),
43(26, 6.3, 'JOVAI8'),
44(27, 3.4, 'INSXT5'),
45(28, 2.9, 'PARMOL16'),
46(29, 4.63, 'TXISOL22'),
47(30, 2.36, 'LIDOXY23'),
48(31, 1.25, 'TXISOL22'),
49(32, 1.36, 'PIRIZ8'),
50(33, 5.48, 'BACTIV13');
51
52DROP TABLE IF EXISTS `famille`;
53CREATE TABLE `famille` (
54 `FAM_CODE` varchar(3) DEFAULT NULL,
55 `FAM_LIBELLE` varchar(80) DEFAULT NULL,
56 KEY `FAM_CODE` (`FAM_CODE`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59
60DROP TABLE IF EXISTS `medicament`;
61CREATE TABLE `medicament` (
62 `MED_DEPOTLEGAL` varchar(10) NOT NULL,
63 `MED_NOMCOMMERCIAL` varchar(25) DEFAULT NULL,
64 `FAM_CODE` varchar(3) DEFAULT NULL,
65 `MED_COMPOSITION` varchar(255) DEFAULT NULL,
66 `MED_EFFETS` varchar(255) DEFAULT NULL,
67 `MED_CONTREINDIC` varchar(255) DEFAULT NULL,
68 `TVA` int(11) NOT NULL,
69 PRIMARY KEY (`MED_DEPOTLEGAL`),
70 KEY `MED_DEPOTLEGAL` (`MED_DEPOTLEGAL`),
71 KEY `contrainte2` (`FAM_CODE`),
72 CONSTRAINT `contrainte2` FOREIGN KEY (`FAM_CODE`) REFERENCES `famille` (`FAM_CODE`)
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75
76DROP TABLE IF EXISTS `praticien`;
77CREATE TABLE `praticien` (
78 `PRA_NUM` int(11) DEFAULT NULL,
79 `PRA_NOM` varchar(25) DEFAULT NULL,
80 `PRA_PRENOM` varchar(30) DEFAULT NULL,
81 `PRA_ADRESSE` varchar(50) DEFAULT NULL,
82 `PRA_CP` varchar(5) DEFAULT NULL,
83 `PRA_VILLE` varchar(25) DEFAULT NULL,
84 `PRA_COEFNOTORIETE` float DEFAULT NULL,
85 `TYP_CODE` varchar(3) DEFAULT NULL,
86 `SPE_CODE` varchar(25) NOT NULL,
87 `NB_SPE` int(11) NOT NULL,
88 KEY `PRA_NUM` (`PRA_NUM`),
89 KEY `TYP_CODE` (`TYP_CODE`),
90 CONSTRAINT `praticien_ibfk_1` FOREIGN KEY (`TYP_CODE`) REFERENCES `type_praticien` (`TYP_CODE`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92
93
94DROP TABLE IF EXISTS `proposer`;
95CREATE TABLE `proposer` (
96 `RAP_NUM` int(11) DEFAULT NULL,
97 `ECH_NUM` int(11) DEFAULT NULL
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99
100
101DROP TABLE IF EXISTS `region`;
102CREATE TABLE `region` (
103 `REG_CODE` varchar(2) DEFAULT NULL,
104 `SEC_CODE` varchar(1) DEFAULT NULL,
105 `REG_NOM` varchar(50) DEFAULT NULL
106) ENGINE=InnoDB DEFAULT CHARSET=latin1;
107
108
109DROP TABLE IF EXISTS `specialite`;
110CREATE TABLE `specialite` (
111 `SPE_CODE` varchar(5) DEFAULT NULL,
112 `SPE_LIBELLE` varchar(150) DEFAULT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115
116DROP TABLE IF EXISTS `tva`;
117CREATE TABLE `tva` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `taux` double NOT NULL,
120 PRIMARY KEY (`id`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123
124DROP TABLE IF EXISTS `type_praticien`;
125CREATE TABLE `type_praticien` (
126 `TYP_CODE` varchar(3) NOT NULL,
127 `TYP_LIBELLE` varchar(25) DEFAULT NULL,
128 `TYP_LIEU` varchar(35) DEFAULT NULL,
129 PRIMARY KEY (`TYP_CODE`),
130 KEY `TYP_CODE` (`TYP_CODE`)
131) ENGINE=InnoDB DEFAULT CHARSET=latin1;
132
133
134DROP TABLE IF EXISTS `visite`;
135CREATE TABLE `visite` (
136 `v_num` int(11) NOT NULL,
137 `v_date` date NOT NULL,
138 `v_description` varchar(255) NOT NULL,
139 `vis_numsecu` varchar(255) NOT NULL,
140 `pra_num` int(11) NOT NULL,
141 `reg_code` varchar(255) NOT NULL,
142 PRIMARY KEY (`v_num`),
143 KEY `ccccf` (`vis_numsecu`),
144 KEY `pra_num` (`pra_num`),
145 CONSTRAINT `visite_ibfk_1` FOREIGN KEY (`pra_num`) REFERENCES `praticien` (`PRA_NUM`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148
149DROP TABLE IF EXISTS `visiteur`;
150CREATE TABLE `visiteur` (
151 `VIS_NUMSECU` varchar(255) NOT NULL,
152 `VIS_NOM` varchar(25) DEFAULT NULL,
153 `Vis_PRENOM` varchar(50) DEFAULT NULL,
154 `VIS_ADRESSE` varchar(50) DEFAULT NULL,
155 `VIS_CP` varchar(5) DEFAULT NULL,
156 `VIS_VILLE` varchar(30) DEFAULT NULL,
157 `VIS_DATE_EMBAUCHE` datetime DEFAULT NULL,
158 `REG_CODE` varchar(10) NOT NULL,
159 PRIMARY KEY (`VIS_NUMSECU`)
160) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
161
162
163-- 2017-11-23 09:57:59