z6VMXaq0

1## 하이버네트에서 원투매니 릴레이션 세팅법
2
3```sql
4DROP SCHEMA IF EXISTS `hb-03-one-to-many`;
5
6CREATE SCHEMA `hb-03-one-to-many`;
7
8use `hb-03-one-to-many`;
9
10SET FOREIGN_KEY_CHECKS = 0;
11
12DROP TABLE IF EXISTS `instructor_detail`;
13
14CREATE TABLE `instructor_detail` (
15  `id` int(11) NOT NULL AUTO_INCREMENT,
16  `youtube_channel` varchar(128) DEFAULT NULL,
17  `hobby` varchar(45) DEFAULT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
20
21
22DROP TABLE IF EXISTS `instructor`;
23
24CREATE TABLE `instructor` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `first_name` varchar(45) DEFAULT NULL,
27  `last_name` varchar(45) DEFAULT NULL,
28  `email` varchar(45) DEFAULT NULL,
29  `instructor_detail_id` int(11) DEFAULT NULL,
30  PRIMARY KEY (`id`),
31  KEY `FK_DETAIL_idx` (`instructor_detail_id`),
32  CONSTRAINT `FK_DETAIL` FOREIGN KEY (`instructor_detail_id`) REFERENCES `instructor_detail` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
33) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
34
35DROP TABLE IF EXISTS `course`;
36
37CREATE TABLE `course` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `title` varchar(128) DEFAULT NULL,
40  `instructor_id` int(11) DEFAULT NULL,
41  PRIMARY KEY (`id`),
42  UNIQUE KEY `TITLE_UNIQUE` (`title`),
43  KEY `FK_INSTRUCTOR_idx` (`instructor_id`),
44  CONSTRAINT `FK_INSTRUCTOR` FOREIGN KEY (`instructor_id`) REFERENCES `instructor` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
45) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
46
47
48SET FOREIGN_KEY_CHECKS = 1;
49```