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 39 40 41 42 43
|
CREATE TABLE ELEVE (
num_eleve INT NOT NULL,
nom_eleve VARCHAR(40) NOT NULL,
pren_eleve VARCHAR(40) NOT NULL,
sexe_eleve VARCHAR(8) NOT NULL,
datenai_eleve DATE NOT NULL default '0000-00-00',
rue_eleve VARCHAR(40) NOT NULL,
cp_eleve VARCHAR(40) NOT NULL,
ville_eleve VARCHAR(40) NOT NULL,
tel_eleve VARCHAR(40) NULL,
mail_eleve VARCHAR(40) NULL,
code_district VARCHAR(5) NULL,
PRIMARY KEY (num_eleve),
FOREIGN KEY (code_district) REFERENCES DISTRICT(code_district)
) TYPE = InnoDB;
CREATE TABLE CLASSE (
code_classe VARCHAR(20) NOT NULL,
num_et VARCHAR(40) NOT NULL,
PRIMARY KEY (code_classe, num_et),
FOREIGN KEY (num_et) REFERENCES ETABLISSEMENT(num_et)
) TYPE = InnoDB;
CREATE TABLE CALENDRIER (
datedeb DATE NOT NULL,
PRIMARY KEY (datedeb)
) TYPE = InnoDB;
CREATE TABLE SITUATION (
num_eleve INT NOT NULL,
datedeb DATE NOT NULL,
code_classe VARCHAR(20) NOT NULL,
num_et VARCHAR(40) NOT NULL,
PRIMARY KEY (num_eleve, date_debut),
FOREIGN KEY (num_eleve) REFERENCES ELEVE(num_eleve),
FOREIGN KEY (datedeb) REFERENCES CALENDRIER(datedeb),
FOREIGN KEY (code_classe) REFERENCES CLASSE(code_classe),
FOREIGN KEY (num_et) REFERENCES CLASSE(num_et)
) TYPE = InnoDB; |
Partager