|
ToDo:
|
午前中はヘタっていました。
CREATE TABLE `test`.`Skill` ( `ID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `Name` VARCHAR(45) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE = InnoDB; CREATE TABLE `test`.`Emp_Skill` ( `EmpID` INTEGER UNSIGNED NOT NULL, `SkillID` INTEGER UNSIGNED NOT NULL, PRIMARY KEY (`EmpID`, `SkillID`), CONSTRAINT `FK_Emp_Skill_1` FOREIGN KEY `FK_Emp_Skill_1` (`EmpID`) REFERENCES `employee` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `FK_Emp_Skill_2` FOREIGN KEY `FK_Emp_Skill_2` (`SkillID`) REFERENCES `skill` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT )
A5サイズで6万円弱。いいなぁ。