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
| CREATE TABLE CL_classe(
CL_ident INT AUTO_INCREMENT,
CL_code CHAR(6) NOT NULL,
CL_libelle VARCHAR(50) NOT NULL,
PRIMARY KEY(CL_ident),
UNIQUE(CL_code)
);
CREATE TABLE MN_manuel(
MN_ident INT AUTO_INCREMENT,
PRIMARY KEY(MN_ident)
);
CREATE TABLE PE_personnage(
PE_ident INT AUTO_INCREMENT,
PE_nom VARCHAR(50) NOT NULL,
CL_ident INT NOT NULL,
PRIMARY KEY(PE_ident),
FOREIGN KEY(CL_ident) REFERENCES CL_classe(CL_ident)
);
CREATE TABLE SO_sort(
SO_ident INT AUTO_INCREMENT,
SO_code CHAR(4) NOT NULL,
SO_libelle VARCHAR(50) NOT NULL,
SO_portee DECIMAL(5,0) NOT NULL,
MN_ident INT NOT NULL,
PRIMARY KEY(SO_ident),
UNIQUE(SO_code),
FOREIGN KEY(MN_ident) REFERENCES MN_manuel(MN_ident)
);
CREATE TABLE lier(
SO_ident INT,
CL_ident INT,
PRIMARY KEY(SO_ident, CL_ident),
FOREIGN KEY(SO_ident) REFERENCES SO_sort(SO_ident),
FOREIGN KEY(CL_ident) REFERENCES CL_classe(CL_ident)
); |
Partager