|
|
ToDo:
|
|
ɥozɐʞıɥ
2007-12-26 風邪が酷くなりつつあり [長年日記]
_ [ORM] Hibernate3 Annotation OneToMany
まずは所属のDDLと従業員DLLの更新(ALTERめんどーだったので作り直し)
CREATE TABLE `test`.`Department` (
`ID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`ID`)
)
ENGINE = InnoDB;
CREATE TABLE `test`.`Employee` (
`ID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`FirstName` VARCHAR(45) NOT NULL,
`LastName` VARCHAR(45) NOT NULL,
`DepartmentID` INTEGER UNSIGNED NOT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `FK_Employee_1` FOREIGN KEY `FK_Employee_1` (`DepartmentID`)
REFERENCES `department` (`ID`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB;
[ツッコミを入れる]
