绑定表
Change-Id: I9b381569457d242d1bd37bd8306e87d93eb0f640
diff --git a/src/main/java/object/TransRecord.java b/src/main/java/object/TransRecord.java
index e32dce2..7f1c800 100644
--- a/src/main/java/object/TransRecord.java
+++ b/src/main/java/object/TransRecord.java
@@ -1,12 +1,54 @@
package object;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.ForeignKey;
+import javax.persistence.Id;
+import javax.persistence.IdClass;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.Table;
+
+@Entity
+@Table(name = "Transport")
+@IdClass(TransportId.class)
public class TransRecord{
+ @Id
+ @Column(name = "task_id", length = 64, nullable = false)
public String taskid;
+
+ @Id
+ @Column(name = "uploader_id", length = 36, nullable = false)
public String uploaduserid;
+
+ @ManyToOne(optional = false)
+ @JoinColumn(name = "uploader_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_tr_user_up"), insertable = false, updatable = false)
+ public User uploader;
+
+ @Id
+ @Column(name = "downloader_id", length = 36, nullable = false)
public String downloaduserid;
+
+ @ManyToOne(optional = false)
+ @JoinColumn(name = "downloader_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_tr_user_down"), insertable = false, updatable = false)
+ public User downloader;
+
+ @Column(name = "seed_id", length = 64, nullable = false)
public String seedid;
- public int upload;
- public int download;
- public int maxupload;
- public int maxdownload;
+
+ @ManyToOne(optional = false)
+ @JoinColumn(name = "seed_id", referencedColumnName = "seed_id", foreignKey = @ForeignKey(name = "fk_tr_seed"), insertable = false, updatable = false)
+ public Seed seed;
+
+ @Column(name = "uploaded", nullable = false)
+ public long upload;
+
+ @Column(name = "downloaded", nullable = false)
+ public long download;
+
+ @Column(name = "upload_peak", nullable = false)
+ public long maxupload;
+
+ @Column(name = "download_peak", nullable = false)
+ public long maxdownload;
}
\ No newline at end of file