diff --git a/src/main/java/entity/UserPT.java b/src/main/java/entity/UserPT.java
new file mode 100644
index 0000000..bc5d455
--- /dev/null
+++ b/src/main/java/entity/UserPT.java
@@ -0,0 +1,46 @@
+package entity;
+
+import javax.persistence.CascadeType;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.FetchType;
+import javax.persistence.ForeignKey;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.MapsId;
+import javax.persistence.OneToOne;
+import javax.persistence.Table;
+
+import com.querydsl.core.annotations.QueryEntity;
+
+@QueryEntity
+@Entity(name="UserPT")
+@Table(name = "UserPT")
+public class UserPT {
+    @Id
+    @Column(name = "user_id", length = 36, nullable = false)
+    public String userid;
+
+    @OneToOne(optional = false, cascade = CascadeType.ALL, fetch = FetchType.LAZY)
+    @MapsId
+    @JoinColumn(name = "user_id", foreignKey = @ForeignKey(name = "fk_pt_user"))
+    public User user;
+
+    @Column(name = "magic", nullable = false)
+    public int magic;
+
+    @Column(name = "uploaded", nullable = false)
+    public long upload;
+
+    @Column(name = "downloaded", nullable = false)
+    public long download;
+
+    @Column(name = "ratio", nullable = false, precision = 5, scale = 2)
+    public double share;
+
+    @Column(name = "default_seed_path")
+    public String farmurl;
+
+    @Column(name = "vip_downloads", nullable = false)
+    public int viptime;
+}