blob: 5245d1c5d4246e6a609f4d23916efeafc0267213 [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;
4
5import javax.persistence.Column;
6import javax.persistence.Entity;
7import javax.persistence.ForeignKey;
8import javax.persistence.Id;
9import javax.persistence.JoinColumn;
10import javax.persistence.Lob;
11import javax.persistence.ManyToOne;
12import javax.persistence.Table;
13import javax.persistence.Temporal;
14import javax.persistence.TemporalType;
rhj46f62c42025-06-06 23:24:10 +080015import com.querydsl.core.annotations.QueryEntity;
root927f1532025-05-09 05:33:32 +000016
rhj46f62c42025-06-06 23:24:10 +080017@QueryEntity
root927f1532025-05-09 05:33:32 +000018@Entity
19@Table(name = "Post")
rootcd436562025-05-08 14:09:19 +000020public class Post {
root927f1532025-05-09 05:33:32 +000021 @Id
22 @Column(name = "post_id", length = 64, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000023 public String postid;
root927f1532025-05-09 05:33:32 +000024
25 @Column(name = "title", length = 255, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000026 public String posttitle;
root927f1532025-05-09 05:33:32 +000027
28 @Lob
29 @Column(name = "content", nullable = false)
root4b6a76b2025-05-09 04:57:59 +000030 public String postcontent;
root927f1532025-05-09 05:33:32 +000031
32 @Column(name = "author_id", length = 36, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000033 public String postuserid;
root927f1532025-05-09 05:33:32 +000034
35 @ManyToOne(optional = false)
36 @JoinColumn(name = "author_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_post_user"), insertable = false, updatable = false)
37 public User author;
38
39 @Column(name = "created_at", nullable = false)
40 @Temporal(TemporalType.TIMESTAMP)
41 public Date posttime;
42
43 @Column(name = "reply_count", nullable = false)
44 public int replytime;
45
46 @Column(name = "view_count", nullable = false)
47 public int readtime;
rootcd436562025-05-08 14:09:19 +000048}