Z7Mpaxsc

1DROP TABLE iF EXISTS `votmed`;
2
3CREATE TABLE `votmed` (
4`kool-ID` int(11)unsigned NOT NULL,
5`opetaja-ID` int(10)unsigned NOT NULL,
6`opilase-ID` int(10) unsigned NOT NULL,
7`personali-ID` int(11) NOT NULL,
8PRIMARY KEY (`kool-ID`,`opetaja-ID`,`opilase-ID`,`personali-ID`),
9INDEX (`kool-ID`),
10INDEX (`opetaja-ID`),
11INDEX (`opilase-ID`),
12INDEX (`personali-ID`)
13);
14
15ALTER TABLE `votmed` 
16
17ADD CONSTRAINT FOREIGN KEY (`kooliID`) REFERENCES `kooli andmed` (`kooliID`) ON DELETE CASCADE ON UPDATE CASCADE,
18
19ADD CONSTRAINT FOREIGN KEY (`opetajaID`) REFERENCES `opetajate andmed` (`opetajaID`) ON DELETE CASCADE ON UPDATE CASCADE,
20
21ADD CONSTRAINT FOREIGN KEY (`opilaseID`) REFERENCES `parimad opilased` (`opilaseID`) ON DELETE CASCADE ON UPDATE CASCADE
22
23ADD CONSTRAINT FOREIGN KEY (`personaliID`) REFERENCES `personali andmed` (`personaliID`) ON DELETE CASCADE ON UPDATE CASCADE;