blob: 36816c44d6807549b621a6958e6eea533252e4bc [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 javax.persistence.Column;
4import javax.persistence.Entity;
5import javax.persistence.ForeignKey;
6import javax.persistence.Id;
7import javax.persistence.JoinColumn;
8import javax.persistence.Lob;
9import javax.persistence.ManyToOne;
10import javax.persistence.Table;
11
12@Entity
13@Table(name = "Appeal")
rootcd436562025-05-08 14:09:19 +000014public class Appeal {
root927f1532025-05-09 05:33:32 +000015 @Id
16 @Column(name = "appeal_id", length = 64, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000017 public String appealid;
root927f1532025-05-09 05:33:32 +000018
19 @Column(name = "user_id", length = 36, nullable = false)
root4b6a76b2025-05-09 04:57:59 +000020 public String appealuserid;
root927f1532025-05-09 05:33:32 +000021
22 @ManyToOne(optional = false)
23 @JoinColumn(name = "user_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_appeal_user"), insertable = false, updatable = false)
24 public User user;
25
26 @Lob
27 @Column(name = "content", nullable = false)
root4b6a76b2025-05-09 04:57:59 +000028 public String content;
root927f1532025-05-09 05:33:32 +000029
30 @Column(name = "file_url", length = 255)
root4b6a76b2025-05-09 04:57:59 +000031 public String fileURL;
root927f1532025-05-09 05:33:32 +000032
33 @Column(name = "status", nullable = false)
root4b6a76b2025-05-09 04:57:59 +000034 public int state; // 0: pending, 1: approved, 2: rejected
rootcd436562025-05-08 14:09:19 +000035}