Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.49 KB | None | 0 0
  1. Person
  2. ------------------------------------------------
  3. ID UINT NOT NULL,
  4. Name VARCHAR(200) NOT NULL,
  5. DOB DATE NOT NULL,
  6. Email VARCHAR(100) NOT NULL
  7.  
  8.  
  9. Person_History
  10. ------------------------------------------------
  11. ID UINT NOT NULL,
  12. PersonID UINT NOT NULL,
  13. Name VARCHAR(200) NOT NULL,
  14. DOB DATE NOT NULL,
  15. Email VARCHAR(100) NOT NULL
  16. AuditID UINT NOT NULL
  17.  
  18.  
  19. Audit
  20. ------------------------------------------------
  21. ID UINT NOT NULL,
  22. UserID UINT NOT NULL, -- Who
  23. AffectedOn DATE NOT NULL, -- When
  24. Comment VARCHAR(500) NOT NULL -- Why
  25.  
  26. Person
  27. ------------------------------------------------
  28. ID UINT NOT NULL,
  29. Name VARCHAR(200) NOT NULL,
  30. DOB DATE NOT NULL,
  31. Email VARCHAR(100) NOT NULL
  32.  
  33.  
  34. Person_History
  35. ------------------------------------------------
  36. ID UINT NOT NULL,
  37. PersonID UINT NOT NULL,
  38. AuditID UINT NOT NULL
  39.  
  40.  
  41. Audit
  42. ------------------------------------------------
  43. ID UINT NOT NULL,
  44. UserID UINT NOT NULL, -- Who
  45. AffectedOn DATE NOT NULL, -- When
  46. Comment VARCHAR(500) NOT NULL -- Why
  47.  
  48. @Entity
  49. @Table(name = "PERSON")
  50. public class Person {
  51.  
  52. @Id
  53. @Column(name = "ID", unique = true, nullable = false)
  54. private Integer id;
  55.  
  56. @Column(name = "DOB")
  57. @Temporal(TemporalType.DATE)
  58. private Date birthDate;
  59.  
  60. @Column(name = "EMAIL")
  61. private String email;
  62.  
  63. @OneToMany(mappedBy="person", fetch=FetchType.LAZY, cascade=CascadeType.ALL)
  64. private List<PersonHistory> personHistories;
  65.  
  66. // getters and setters...
  67.  
  68. }
  69.  
  70.  
  71. @Entity
  72. @Table(name = "PERSON_HISTORY")
  73. public class PersonHistory {
  74.  
  75. @Id
  76. @Column(name = "ID", unique = true, nullable = false)
  77. private Integer id;
  78.  
  79. @ManyToOne(fetch=FetchType.LAZY)
  80. @JoinColumn(name="ID_PERSON", nullable=false)
  81. private Person person;
  82.  
  83. @ManyToOne(fetch=FetchType.LAZY)
  84. @JoinColumn(name="ID_AUDIT", nullable=false)
  85. private Audit audit;
  86.  
  87. // getters and setters...
  88.  
  89. }
  90.  
  91.  
  92. @Entity
  93. @Table(name = "AUDIT")
  94. public class Audit {
  95.  
  96. @Id
  97. @Column(name = "ID", unique = true, nullable = false)
  98. private Integer id;
  99.  
  100. @Column(name = "AFFECTED_ON")
  101. @Temporal(TemporalType.DATE)
  102. private Date affectedOn;
  103.  
  104. @Column(name = "COMMENT")
  105. private String comment;
  106.  
  107. @ManyToOne(fetch=FetchType.LAZY)
  108. @JoinColumn(name="ID_USER", nullable=false)
  109. private User user;
  110.  
  111. // getters and setters...
  112.  
  113. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement