blob: 009061ecfaf936928eba91068b6383eacd063dcc [file] [log] [blame]
rootff0769a2025-05-18 17:24:41 +00001package entity;
rootcd436562025-05-08 14:09:19 +00002
root927f1532025-05-09 05:33:32 +00003import java.util.Date;
rhj5b69b7e2025-06-07 01:28:08 +08004import java.util.List;
root927f1532025-05-09 05:33:32 +00005
6import javax.persistence.Column;
7import javax.persistence.Entity;
8import javax.persistence.ForeignKey;
9import javax.persistence.Id;
10import javax.persistence.JoinColumn;
11import javax.persistence.Lob;
12import javax.persistence.ManyToOne;
13import javax.persistence.Table;
14import javax.persistence.Temporal;
15import javax.persistence.TemporalType;
rhj46f62c42025-06-06 23:24:10 +080016import com.querydsl.core.annotations.QueryEntity;
rhj5b69b7e2025-06-07 01:28:08 +080017import javax.persistence.OneToMany;
18import javax.persistence.CascadeType;
19import javax.persistence.FetchType;
root927f1532025-05-09 05:33:32 +000020
rhj46f62c42025-06-06 23:24:10 +080021@QueryEntity
root927f1532025-05-09 05:33:32 +000022@Entity
23@Table(name = "Post")
rootcd436562025-05-08 14:09:19 +000024public class Post {
root927f1532025-05-09 05:33:32 +000025 @Id
26 @Column(name = "post_id", length = 64, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000027 public String postid;
root927f1532025-05-09 05:33:32 +000028
29 @Column(name = "title", length = 255, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000030 public String posttitle;
root927f1532025-05-09 05:33:32 +000031
32 @Lob
33 @Column(name = "content", nullable = false)
root4b6a76b2025-05-09 04:57:59 +000034 public String postcontent;
root927f1532025-05-09 05:33:32 +000035
36 @Column(name = "author_id", length = 36, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000037 public String postuserid;
root927f1532025-05-09 05:33:32 +000038
39 @ManyToOne(optional = false)
40 @JoinColumn(name = "author_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_post_user"), insertable = false, updatable = false)
41 public User author;
rhj5b69b7e2025-06-07 01:28:08 +080042
root927f1532025-05-09 05:33:32 +000043 @Column(name = "created_at", nullable = false)
44 @Temporal(TemporalType.TIMESTAMP)
45 public Date posttime;
46
47 @Column(name = "reply_count", nullable = false)
48 public int replytime;
49
50 @Column(name = "view_count", nullable = false)
51 public int readtime;
rootcd436562025-05-08 14:09:19 +000052}