m6kF9k1h

1DROP TABLE IF EXISTS `DEPARTMENT`;
2CREATE TABLE `DEPARTMENT` (
3  `ID` bigint(20) NOT NULL,
4  `NAME` varchar(255) DEFAULT NULL,
5  PRIMARY KEY (`ID`)
6) ENGINE=InnoDB DEFAULT CHARSET=latin1;
7
8DROP TABLE IF EXISTS `EMPLOYEE`;
9CREATE TABLE `EMPLOYEE` (
10  `ID` bigint(20) NOT NULL,
11  `NAME` varchar(255) DEFAULT NULL,
12  `DEPARTMENT_ID` bigint(20) DEFAULT NULL,
13  PRIMARY KEY (`ID`),
14  KEY `FK_EMPLOYEE_DEPARTMENT_ID` (`DEPARTMENT_ID`),
15  CONSTRAINT `FK_EMPLOYEE_DEPARTMENT_ID` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `DEPARTMENT` (`ID`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;