blob: 1593ca03a67864f20177da8e7ba21c091d8625b7 [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;
15
16@Entity
17@Table(name = "Post")
rootcd436562025-05-08 14:09:19 +000018public class Post {
root927f1532025-05-09 05:33:32 +000019 @Id
20 @Column(name = "post_id", length = 64, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000021 public String postid;
root927f1532025-05-09 05:33:32 +000022
23 @Column(name = "title", length = 255, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000024 public String posttitle;
root927f1532025-05-09 05:33:32 +000025
26 @Lob
27 @Column(name = "content", nullable = false)
root4b6a76b2025-05-09 04:57:59 +000028 public String postcontent;
root927f1532025-05-09 05:33:32 +000029
30 @Column(name = "author_id", length = 36, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000031 public String postuserid;
root927f1532025-05-09 05:33:32 +000032
33 @ManyToOne(optional = false)
34 @JoinColumn(name = "author_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_post_user"), insertable = false, updatable = false)
35 public User author;
36
37 @Column(name = "created_at", nullable = false)
38 @Temporal(TemporalType.TIMESTAMP)
39 public Date posttime;
40
41 @Column(name = "reply_count", nullable = false)
42 public int replytime;
43
44 @Column(name = "view_count", nullable = false)
45 public int readtime;
rootcd436562025-05-08 14:09:19 +000046}