· 8 years ago · May 25, 2018, 04:24 PM
1CREATE SCHEMA IF NOT EXISTS `h9kosanddb` DEFAULT CHARACTER SET utf8;
2USE `h9kosanddb`;
3
4-- -----------------------------------------------------
5-- Table `h9kosanddb`.`tbl6professeurs`
6-- -----------------------------------------------------
7DROP TABLE IF EXISTS `h9kosanddb`.`tbl6professeurs` ;
8
9CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6professeurs` (
10 `id` INT NOT NULL AUTO_INCREMENT ,
11 `nomProf` VARCHAR(100) NULL ,
12 PRIMARY KEY (`id`) )
13ENGINE = InnoDB
14DEFAULT CHARACTER SET = utf8
15COLLATE = utf8_general_ci;
16
17
18-- -----------------------------------------------------
19-- Table `h9kosanddb`.`tbl6sessions`
20-- -----------------------------------------------------
21DROP TABLE IF EXISTS `h9kosanddb`.`tbl6sessions` ;
22
23CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6sessions` (
24 `id` INT NOT NULL AUTO_INCREMENT ,
25 `numsession` VARCHAR(45) NULL ,
26 PRIMARY KEY (`id`) )
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `h9kosanddb`.`tbl6cours`
32-- -----------------------------------------------------
33DROP TABLE IF EXISTS `h9kosanddb`.`tbl6cours` ;
34
35CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6cours` (
36 `id` INT NOT NULL AUTO_INCREMENT ,
37 `nomCours` VARCHAR(45) NULL ,
38 `numeroCours` VARCHAR(10) NULL ,
39 `professeurs_id` INT NULL ,
40 `sessions_id` INT NULL ,
41 PRIMARY KEY (`id`) ,
42 INDEX fk_cours_professeurs (`professeurs_id` ASC) ,
43 INDEX fk_cours_sessions (`sessions_id` ASC) ,
44 CONSTRAINT `fk_cours_professeurs`
45 FOREIGN KEY (`professeurs_id` )
46 REFERENCES `h9kosanddb`.`tbl6professeurs` (`id` )
47 ON DELETE NO ACTION
48 ON UPDATE NO ACTION,
49 CONSTRAINT `fk_cours_sessions`
50 FOREIGN KEY (`sessions_id` )
51 REFERENCES `h9kosanddb`.`tbl6sessions` (`id` )
52 ON DELETE NO ACTION
53 ON UPDATE NO ACTION)
54ENGINE = InnoDB
55DEFAULT CHARACTER SET = utf8
56COLLATE = utf8_general_ci;
57
58
59-- -----------------------------------------------------
60-- Table `h9kosanddb`.`tbl6tps`
61-- -----------------------------------------------------
62DROP TABLE IF EXISTS `h9kosanddb`.`tbl6tps` ;
63
64CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6tps` (
65 `id` INT NOT NULL AUTO_INCREMENT ,
66 `ponderation` INT NULL ,
67 `dateTP` DATE NULL ,
68 `rencontre` INT NULL ,
69 `titreTP` VARCHAR(45) NULL ,
70 `noTP` INT NULL ,
71 `cours_id` INT NULL ,
72 PRIMARY KEY (`id`) ,
73 INDEX fk_tps_cours (`cours_id` ASC) ,
74 CONSTRAINT `fk_tps_cours`
75 FOREIGN KEY (`cours_id` )
76 REFERENCES `h9kosanddb`.`tbl6cours` (`id` )
77 ON DELETE NO ACTION
78 ON UPDATE NO ACTION)
79ENGINE = InnoDB
80DEFAULT CHARACTER SET = utf8
81COLLATE = utf8_general_ci;
82
83
84-- -----------------------------------------------------
85-- Table `h9kosanddb`.`tbl6criteres`
86-- -----------------------------------------------------
87DROP TABLE IF EXISTS `h9kosanddb`.`tbl6criteres` ;
88
89CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6criteres` (
90 `id` INT NOT NULL AUTO_INCREMENT ,
91 `ponderationCritere` INT NULL ,
92 `nomCritere` VARCHAR(100) NULL ,
93 `tps_id` INT NULL ,
94 INDEX fk_criteres_tps (`tps_id` ASC) ,
95 PRIMARY KEY (`id`) ,
96 CONSTRAINT `fk_criteres_tps`
97 FOREIGN KEY (`tps_id` )
98 REFERENCES `h9kosanddb`.`tbl6tps` (`id` )
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION)
101ENGINE = InnoDB
102DEFAULT CHARACTER SET = utf8
103COLLATE = utf8_general_ci;
104
105
106-- -----------------------------------------------------
107-- Table `h9kosanddb`.`tbl6etudiants`
108-- -----------------------------------------------------
109DROP TABLE IF EXISTS `h9kosanddb`.`tbl6etudiants` ;
110
111CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6etudiants` (
112 `id` INT NOT NULL AUTO_INCREMENT ,
113 `nom` VARCHAR(45) NULL ,
114 `prenom` VARCHAR(45) NULL ,
115 `matricule` VARCHAR(7) NULL ,
116 PRIMARY KEY (`id`) )
117ENGINE = InnoDB
118DEFAULT CHARACTER SET = utf8
119COLLATE = utf8_general_ci;
120
121
122-- -----------------------------------------------------
123-- Table `h9kosanddb`.`tbl6cours_etudiants`
124-- -----------------------------------------------------
125DROP TABLE IF EXISTS `h9kosanddb`.`tbl6cours_etudiants` ;
126
127CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6cours_etudiants` (
128 `id` INT NOT NULL AUTO_INCREMENT ,
129 `cours_id` INT NULL ,
130 `etudiants_id` INT NULL ,
131 PRIMARY KEY (`id`) ,
132 INDEX fk_cours_etudiants_cours (`cours_id` ASC) ,
133 INDEX fk_cours_etudiants_etudiants (`etudiants_id` ASC) ,
134 CONSTRAINT `fk_cours_etudiants_cours`
135 FOREIGN KEY (`cours_id` )
136 REFERENCES `h9kosanddb`.`tbl6cours` (`id` )
137 ON DELETE NO ACTION
138 ON UPDATE NO ACTION,
139 CONSTRAINT `fk_cours_etudiants_etudiants`
140 FOREIGN KEY (`etudiants_id` )
141 REFERENCES `h9kosanddb`.`tbl6etudiants` (`id` )
142 ON DELETE NO ACTION
143 ON UPDATE NO ACTION)
144ENGINE = InnoDB
145DEFAULT CHARACTER SET = utf8
146COLLATE = utf8_general_ci;
147
148
149-- -----------------------------------------------------
150-- Table `h9kosanddb`.`tbl6resultatstps`
151-- -----------------------------------------------------
152DROP TABLE IF EXISTS `h9kosanddb`.`tbl6resultatstps` ;
153
154CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6resultatstps` (
155 `id` INT NOT NULL AUTO_INCREMENT ,
156 `noteTP` DECIMAL(4,1) NULL ,
157 `commentaireOmnivox` VARCHAR(100) NULL ,
158 `cours_etudiants_id` INT NULL ,
159 PRIMARY KEY (`id`) ,
160 INDEX fk_resultatstps_cours_etudiants (`cours_etudiants_id` ASC) ,
161 CONSTRAINT `fk_resultatstps_cours_etudiants`
162 FOREIGN KEY (`cours_etudiants_id` )
163 REFERENCES `h9kosanddb`.`tbl6cours_etudiants` (`id` )
164 ON DELETE NO ACTION
165 ON UPDATE NO ACTION)
166ENGINE = InnoDB
167DEFAULT CHARACTER SET = utf8
168COLLATE = utf8_general_ci;
169
170
171-- -----------------------------------------------------
172-- Table `h9kosanddb`.`tbl6resultatstps_criteres`
173-- -----------------------------------------------------
174DROP TABLE IF EXISTS `h9kosanddb`.`tbl6resultatstps_criteres` ;
175
176CREATE TABLE IF NOT EXISTS `h9kosanddb`.`tbl6resultatstps_criteres` (
177 `id` INT NOT NULL AUTO_INCREMENT ,
178 `resultatstps_id` INT NULL ,
179 `noteCritere` DECIMAL(4,1) NULL ,
180 `critiqueCritere` VARCHAR(100) NULL ,
181 `critere_nom` VARCHAR(45) NULL ,
182 INDEX fk_table1_resultatstps (`resultatstps_id` ASC) ,
183 PRIMARY KEY (`id`) ,
184 CONSTRAINT `fk_table1_resultatstps`
185 FOREIGN KEY (`resultatstps_id` )
186 REFERENCES `h9kosanddb`.`tbl6resultatstps` (`id` )
187 ON DELETE NO ACTION
188 ON UPDATE NO ACTION)
189ENGINE = InnoDB
190DEFAULT CHARACTER SET = utf8
191COLLATE = utf8_general_ci;