src/main/java/object/TransRecord.java

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;

    @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;
}