绑定表
Change-Id: I9b381569457d242d1bd37bd8306e87d93eb0f640
diff --git a/src/main/java/object/Appeal.java b/src/main/java/object/Appeal.java
index 3df37e8..5057179 100644
--- a/src/main/java/object/Appeal.java
+++ b/src/main/java/object/Appeal.java
@@ -1,9 +1,35 @@
package object;
+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
}