|
|
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万円弱。いいなぁ。