1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
CREATE TABLE `annee` (
`Annee` varchar(4) NOT NULL default '',
PRIMARY KEY (`Annee`)
);
-- --------------------------------------------------------
CREATE TABLE `entite` (
`nom` varchar(20) NOT NULL default '',
`surEntite` varchar(20) NOT NULL default '',
PRIMARY KEY (`nom`)
);
-- --------------------------------------------------------
CREATE TABLE `indicateur` (
` Identificateur` varchar(20) NOT NULL default '',
`libelle` varchar(100) NOT NULL default '',
`surIndicateur` varchar(100) NOT NULL default '',
PRIMARY KEY (` Identificateur`)
);
-- --------------------------------------------------------
CREATE TABLE `valeur` (
`Entite` varchar(20) NOT NULL default '',
`Indic` varchar(20) NOT NULL default '',
`Annee` varchar(4) NOT NULL default '',
`valeur` int(11) NOT NULL default '-1',
PRIMARY KEY (`Entite`,`Indic`,`Annee`)
);
ALTER TABLE `valeur`
ADD CONSTRAINT `_annee` FOREIGN KEY (`annee`) REFERENCES `annee` (`annee`);
ALTER TABLE `valeur`
ADD CONSTRAINT `_entite` FOREIGN KEY (`Entite`) REFERENCES `entite` (`nom`);
ALTER TABLE `valeur`
ADD CONSTRAINT `_Indic` FOREIGN KEY (`Indic`) REFERENCES `indicateur` (`Identificateur`); |
Partager