Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Entity
- @Getter
- @Setter
- @Table(name = "Question")
- public class Question {
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- private int id;
- @Column(length = 128)
- private String name;
- @OneToMany(mappedBy = "question", cascade = CascadeType.ALL, orphanRemoval = true)
- private List<QuestionAnswerMapping> questionAnswerMapping;
- }
- @Entity
- @Getter
- @Setter
- @Table(name = "Answer")
- public class Answer {
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- private int id;
- @Column(length = 255)
- private String displayText;
- @OneToMany(mappedBy = "answer")
- private List<QuestionAnswerMapping> questionAnswerMapping;
- }
- @Entity
- @Table(name = "Question_Answer_Mapping")
- public class QuestionAnswerMapping {
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- private int id;
- @ManyToOne
- @JoinColumn(name="questionId", nullable = false /*, referencedColumnName="id" , foreignKey=@ForeignKey(name="FK_Question", value=ConstraintMode.CONSTRAINT)*/)
- /* @JoinColumns(value = { @JoinColumn(name="questionId",referencedColumnName="id",foreignKey=@ForeignKey(value=ConstraintMode.CONSTRAINT)) }) */
- private Question question;
- @ManyToOne
- @JoinColumn(name="answerId", nullable = false /*, referencedColumnName="id", foreignKey=@ForeignKey(name="FK_Answer", value=ConstraintMode.CONSTRAINT)*/)
- /* @JoinColumns(value = { @JoinColumn(name="answerId",referencedColumnName="id",foreignKey=@ForeignKey(value=ConstraintMode.CONSTRAINT)) }) */
- private Answer answer;
- }
- ---
- spring:
- profiles: local
- datasource:
- url: jdbc:mysql://localhost:3306/test?useSSL=false
- username: root
- jpa:
- generate-ddl: true
- show-sql: true
- hibernate:
- naming:
- physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
- properties:
- hibernate:
- dialect: org.hibernate.dialect.MySQL5Dialect
- ddl-auto: create-drop
- CREATE TABLE `question` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(128) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
- CREATE TABLE `answer` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `displayText` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
- CREATE TABLE `question_answer_mapping` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `answerId` int(11) NOT NULL,
- `questionId` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKpjg76y4ofqmvfmbujphnqyq1y` (`answerId`),
- KEY `FK2mbyguxt74rwhv1n1t11wi3fl` (`questionId`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Add Comment
Please, Sign In to add comment