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 44 45 46 47 48 49 50 51 52 53 54 55
| -- -----------------------------------------------------
-- Table PC
-- -----------------------------------------------------
CREATE TABLE PC
(
PCId INT NOT NULL,
CONSTRAINT PC_PK PRIMARY KEY (PCId)
) ;
-- -----------------------------------------------------
-- Table TERMINAL
-- -----------------------------------------------------
CREATE TABLE TERMINAL
(
TermId INT NOT NULL,
CONSTRAINT TERMINAL_PK PRIMARY KEY (TermId)
) ;
-- -----------------------------------------------------
-- Table IMPRIMANTE
-- -----------------------------------------------------
CREATE TABLE IMPRIMANTE
(
ImprId INT NOT NULL,
CONSTRAINT IMPRIMANTE_PK PRIMARY KEY (ImprId)
) ;
-- -----------------------------------------------------
-- Table IMPR_TERM
-- -----------------------------------------------------
CREATE TABLE IMPR_TERM
(
ImprId INT NOT NULL,
TermId INT NOT NULL,
CONSTRAINT IMPR_TERM_PK PRIMARY KEY (ImprId),
CONSTRAINT IMPR_TERM_AK UNIQUE (TermId),
CONSTRAINT IMPR_TERM_IMPRIMANTE_FK FOREIGN KEY (ImprId)
REFERENCES IMPRIMANTE,
CONSTRAINT IMPR_TERM_TERMINAL_FK FOREIGN KEY (TermId)
REFERENCES TERMINAL
) ;
-- -----------------------------------------------------
-- Table IMPR_PC
-- -----------------------------------------------------
CREATE TABLE IMPR_PC
(
PCId INT NOT NULL,
ImprId INT NOT NULL,
CONSTRAINT IMPR_PC_PK PRIMARY KEY (PCId, ImprId),
CONSTRAINT IMPR_PC_PC_FK FOREIGN KEY (PCId)
REFERENCES PC (PCId),
CONSTRAINT IMPR_PC_IMPRIMANTE_FK FOREIGN KEY (ImprId)
REFERENCES IMPRIMANTE
) ; |
Partager