优化domain 定义，增加serialid 和 索引
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TPersondtl.java b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TPersondtl.java
index 303ea2e..9e0ad35 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TPersondtl.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TPersondtl.java
@@ -10,6 +10,7 @@
indexes = {@Index(name = "prsndtl_transdate_idx", columnList = "transdate"),
@Index(name = "prsndtl_accdate_idx", columnList = "accdate"),
@Index(name = "prsndtl_status_idx", columnList = "status"),
+ @Index(name = "prsndlt_tenantid_idx", columnList = "tenantid"),
@Index(name = "prsndtl_reverse_idx", columnList = "REVERSE_FLAG")})
public class TPersondtl {
@@ -93,18 +94,18 @@
@NotNull
private String tenantid = "";
- @Column(name = "DTLTYPE", length = 20)
- private String dtltype;
+ @Column(name = "DTLTYPE", length = 20)
+ private String dtltype;
- public String getDtltype() {
- return dtltype;
- }
+ public String getDtltype() {
+ return dtltype;
+ }
- public void setDtltype(String dtltype) {
- this.dtltype = dtltype;
- }
+ public void setDtltype(String dtltype) {
+ this.dtltype = dtltype;
+ }
- public String getRefno() {
+ public String getRefno() {
return refno;
}
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TShopdtl.java b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TShopdtl.java
index 6e5c7bc..e930ce8 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TShopdtl.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TShopdtl.java
@@ -8,6 +8,7 @@
indexes = {@Index(name = "shopdtl_accdate", columnList = "accdate"),
@Index(name = "shopdtl_shopaccno", columnList = "shopaccno"),
@Index(name = "shopdtl_transdate", columnList = "transdate"),
+ @Index(name = "shopdtl_tenantid_idx", columnList = "tenantid"),
@Index(name = "shopdtl_updateflag", columnList = "updatebala")})
public class TShopdtl {
@Id
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TSourceTypeConfig.java b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TSourceTypeConfig.java
index df7ec88..c56ffde 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TSourceTypeConfig.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TSourceTypeConfig.java
@@ -13,6 +13,7 @@
@Table(name = "TB_SOURCETYPE_CONFIG",
indexes = {@Index(name = "source_type_config_idx", columnList = "sourcetype, configid, tenantid", unique = true)})
public class TSourceTypeConfig implements Serializable {
+ private static final long serialVersionUID = 9020235338229267313L;
@Id
@SequenceGenerator(name = "sourcetype_cfg_id", sequenceName = "SEQ_SOURCETYPE_CONFIG", allocationSize = 1, initialValue = 1000)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "sourcetype_cfg_id")
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TTransactionMain.java b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TTransactionMain.java
index 474d5cc..fdd77e5 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TTransactionMain.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/api/domain/TTransactionMain.java
@@ -15,6 +15,7 @@
@Table(name = "TB_TRANSACTIONMAIN",
indexes = {@Index(name = "transmain_accdate", columnList = "accdate"),
@Index(name = "transmain_status", columnList = "status"),
+ @Index(name = "transmain_tenantid_idx", columnList = "tenantid"),
@Index(name = "transmain_outtrade", unique = true, columnList = "outid, outtradeno")})
@SequenceGenerator(name = "seq_refno", allocationSize = 100)
public class TTransactionMain {
@@ -124,6 +125,7 @@
public void setDtltype(String dtltype) {
this.dtltype = dtltype;
}
+
public String getRefno() {
return refno;
}
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TDictionary.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TDictionary.java
index 76bcc21..1f766c9 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TDictionary.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TDictionary.java
@@ -8,6 +8,7 @@
@Table(name = "TB_DICTIONARY",
indexes = {@Index(name = "dictionary_idx", columnList = "dicttype, dictval, tenantid", unique = true)})
public class TDictionary implements DictionaryTable, Serializable {
+ private static final long serialVersionUID = -4346024672769882893L;
@Id
@Column(name = "id")
@SequenceGenerator(name = "dictid", sequenceName = "SEQ_DICTIONARY", allocationSize = 1, initialValue = 1000)
@@ -73,6 +74,14 @@
this.dictid = dictid;
}
+ public String getTenantId() {
+ return tenantId;
+ }
+
+ public void setTenantId(String tenantId) {
+ this.tenantId = tenantId;
+ }
+
@Override
public String getDictKey() {
return this.dictval;
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TFunction.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TFunction.java
index 1477cec..cbf8354 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TFunction.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TFunction.java
@@ -12,6 +12,7 @@
@JsonIgnoreProperties(value = {"hibernateLazyInitializer"})
@SequenceGenerator(name = "SEQ_FUNC", sequenceName = "SEQ_FUNC", allocationSize = 1, initialValue = 1000)
public class TFunction implements Serializable {
+ private static final long serialVersionUID = 1862862725121064784L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_FUNC")
@Column(name = "ID", nullable = false)
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TOperator.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TOperator.java
index 29e2e13..8e8f83b 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TOperator.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TOperator.java
@@ -9,12 +9,13 @@
import javax.persistence.*;
import javax.validation.constraints.Email;
import javax.validation.constraints.NotNull;
+import java.io.Serializable;
import java.util.Collection;
@Entity
@Table(name = "TB_OPERATOR",
indexes = {@Index(name = "opercode_idx", columnList = "OPERCODE, tenantid", unique = true)})
-public class TOperator implements UserDetails {
+public class TOperator implements UserDetails, Serializable {
private static final long serialVersionUID = 2148742269021236587L;
@Id
@GenericGenerator(name = "idGenerator", strategy = "uuid")
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TRoleFunction.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TRoleFunction.java
index b64e0e9..18a0a68 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TRoleFunction.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TRoleFunction.java
@@ -4,11 +4,13 @@
import javax.persistence.*;
import javax.validation.constraints.NotNull;
+import java.io.Serializable;
@Entity
@Table(name = "TB_ROLE_FUNCTION",
indexes = {@Index(name = "role_funcation_idx", columnList = "roleid, functionid, tenantid", unique = true)})
-public class TRoleFunction {
+public class TRoleFunction implements Serializable {
+ private static final long serialVersionUID = 6098241093888979729L;
@Id
@GenericGenerator(name = "idGenerator", strategy = "uuid")
@GeneratedValue(generator = "idGenerator")
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubject.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubject.java
index ba54f21..d02d05e 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubject.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubject.java
@@ -1,7 +1,5 @@
package com.supwisdom.dlpay.framework.domain;
-import org.hibernate.annotations.GenericGenerator;
-
import javax.persistence.*;
import javax.validation.constraints.NotNull;
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubjectday.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubjectday.java
index 18b151d..d200c62 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubjectday.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSubjectday.java
@@ -4,7 +4,8 @@
import javax.validation.constraints.NotNull;
@Entity
-@Table(name = "TB_SUBJECTDAY")
+@Table(name = "TB_SUBJECTDAY",
+ indexes = {@Index(name = "subjectday_idx", columnList = "subjno, accdate, tenantid", unique = true)})
@IdClass(TSubjectdayPK.class)
public class TSubjectday {
@Id
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSyspara.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSyspara.java
index 8ec551c..8269487 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSyspara.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TSyspara.java
@@ -7,11 +7,13 @@
import javax.persistence.*;
import javax.validation.constraints.NotNull;
+import java.io.Serializable;
@Entity
@Table(name = "TB_SYSPARA")
@IdClass(TSysparaPK.class)
-public class TSyspara {
+public class TSyspara implements Serializable {
+ private static final long serialVersionUID = 6760877848228345624L;
@Id
@Column(name = "PARAID", nullable = false, precision = 9)
private Integer paraid;
diff --git a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TTranscode.java b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TTranscode.java
index 46e53e4..1506e65 100644
--- a/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TTranscode.java
+++ b/payapi/src/main/java/com/supwisdom/dlpay/framework/domain/TTranscode.java
@@ -8,6 +8,7 @@
@Table(name = "TB_TRANSCODE",
indexes = {@Index(name = "transcode_idx", columnList = "transcode, tenantid", unique = true)})
public class TTranscode implements DictionaryTable, Serializable {
+ private static final long serialVersionUID = -8077649544237207668L;
@Id
@Column(name = "transcode_id")
@NotNull