bdhDWEUS

1DROP TABLE IF EXISTS `votmed`;
2CREATE TABLE `votmed` (
3    `kool-ID` INT UNSIGNED NOT NULL,
4    `opetaja-ID` SMALLINT UNSIGNED NOT NULL,
5    `opilase-ID` SMALLINT UNSIGNED NOT NULL,
6    `personali-ID` SMALLINT UNSIGNED NOT NULL,
7    PRIMARY KEY (`kool-ID`, `opetaja-ID`, `opilase-ID`, `personali-ID`),
8    CONSTRAINT `Constr_votmed_kool-ID_fk`
9        FOREIGN KEY `kooli andmed_fk` (`kool-ID`) REFERENCES `kooli andmed` (`kooliID`)
10        ON DELETE CASCADE ON UPDATE CASCADE,
11    
12    CONSTRAINT `Constr_votmed_opetaja-ID_fk`
13        FOREIGN KEY `opetajate andmed_fk` (`opetaja-ID`) REFERENCES `opetajate andmed` (`opetajaID`)
14        ON DELETE CASCADE ON UPDATE CASCADE,
15    
16    CONSTRAINT `Constr_votmed_opilase-ID_fk`
17        FOREIGN KEY `parimad opilased_fk` (`opilase-ID`) REFERENCES `parimad opilased` (`opilaseID`)
18    	ON DELETE CASCADE ON UPDATE CASCADE,
19    
20    CONSTRAINT `Constr_votmed_personali-ID_fk`
21        FOREIGN KEY `personali andmed_fk` (`personali-ID`) REFERENCES `personali andmed` (`personaliID`)
22    	ON DELETE CASCADE ON UPDATE CASCADE
23
24); ENGINE=INNODB CHARACTER SET ascii COLLATE ascii_general_ci