Guest User

Untitled

a guest
Jul 16th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. CREATE TABLE author(
  2. author_id INT AUTO_INCREMENT PRIMARY KEY,
  3. name VARCHAR(20),
  4. author_phone_fk INT NULL,
  5. CONSTRAINT `author_phone_fk`
  6. FOREIGN KEY(author_phone_fk) REFERENCES phone(phone_id));
  7.  
  8. CREATE TABLE phone(
  9. phone_id INT AUTO_INCREMENT PRIMARY KEY,
  10. number VARCHAR(20));
  11.  
  12. @Entity
  13. public class Phone {
  14.  
  15. @Id
  16. @Column(name = "phone_id")
  17. private int id;
  18.  
  19. private String number;
  20.  
  21. }
  22.  
  23. @Entity
  24. public class Author {
  25.  
  26. @Id
  27. @Column(name = "author_id")
  28. private int id;
  29.  
  30. private String name;
  31.  
  32. @OneToOne(cascade = CascadeType.PERSIST)
  33. @JoinColumn(name = "author_phone_fk")
  34. private Phone phone;
  35. }
Add Comment
Please, Sign In to add comment