13jBZw8G

1CREATE TABLE IF NOT EXISTS `dbo`.`department` (
2  `id` INT NOT NULL,
3  `name` VARCHAR(255) NOT NULL,
4  `short_name` VARCHAR(255) NULL,
5  PRIMARY KEY (`id`),
6  .................
7	
8CREATE TABLE IF NOT EXISTS `dbo`.`teacher` (
9  `id` INT NOT NULL,
10  `first_name` VARCHAR(255) NOT NULL,
11  `middle_name` VARCHAR(255) NOT NULL,
12  `last_name` VARCHAR(255) NOT NULL,
13  PRIMARY KEY (`id`),
14  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
15  ......................
16	
17CREATE TABLE IF NOT EXISTS `dbo`.`rate` (
18  `teacher_id` INT NOT NULL,
19  `department_id` INT NOT NULL,
20  `rate` DOUBLE NOT NULL,
21  PRIMARY KEY (`teacher_id`, `department_id`),
22  .........................
23	
24@Entity
25    @Table(name = "rate")
26    public class Rate {
27        @ManyToOne
28        @JoinColumn(name = "teacher_id", nullable = false)
29        private Teacher teacher;
30        @ManyToOne
31        @JoinColumn(name = "department_id", nullable = false)
32        private Department department;
33        @Id
34        private Long id = teacher.getId() + department.getId();
35        private Double rate;
36    }