| package entity; |
| |
| import javax.persistence.Column; |
| import javax.persistence.Entity; |
| import javax.persistence.ForeignKey; |
| import javax.persistence.Id; |
| import javax.persistence.JoinColumn; |
| import javax.persistence.Lob; |
| import javax.persistence.ManyToOne; |
| import javax.persistence.Table; |
| |
| @Entity |
| @Table(name = "Appeal") |
| public class Appeal { |
| @Id |
| @Column(name = "appeal_id", length = 64, nullable = false) |
| public String appealid; |
| |
| @Column(name = "user_id", length = 36, nullable = false) |
| public String appealuserid; |
| |
| @ManyToOne(optional = false) |
| @JoinColumn(name = "user_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_appeal_user"), insertable = false, updatable = false) |
| public User user; |
| |
| @Lob |
| @Column(name = "content", nullable = false) |
| public String content; |
| |
| @Column(name = "file_url", length = 255) |
| public String fileURL; |
| |
| @Column(name = "status", nullable = false) |
| public int state; // 0: pending, 1: approved, 2: rejected |
| } |