优化 transdtl 表
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/domain/TTransDtl.java b/src/main/java/com/supwisdom/dlpay/restaurant/domain/TTransDtl.java
index 0f3c4c2..1bce8e6 100644
--- a/src/main/java/com/supwisdom/dlpay/restaurant/domain/TTransDtl.java
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/domain/TTransDtl.java
@@ -1,226 +1,263 @@
package com.supwisdom.dlpay.restaurant.domain;
import javax.persistence.*;
+import javax.validation.constraints.NotNull;
@Entity
-@Table(name = "TB_TRANSDTL")
+@Table(name = "TB_TRANSDTL",
+ indexes = {@Index(name = "transdtl_accdate_idx", columnList = "accdate"),
+ @Index(name = "transdtl_transdate_idx", columnList = "transdate"),
+ @Index(name = "transdtl_status_idx", columnList = "status"),
+ @Index(name = "transdtl_coreaccdate_idx", columnList = "core_accdate, status")})
public class TTransDtl {
- private String billno;
- private String custname;
- private String custid;
- private String cardno;
- private Double amount;
- private String transdate;
- private String transtime;
- private String accdate;
- private String acctime;
- private Integer termid;
- private String status;
- private Integer revflag;
- private String transtype;
- private Integer shopid;
- private String attr1;
- private String revbillno;
- private String transmode;
- private Integer custtype;
- private Double managefee;
- private String mealtype;
- private Integer termsqlno;
+ private String billno;
+ private String custname;
+ private String custid;
+ private String cardno;
+ private Double amount;
+ private String transdate;
+ private String transtime;
+ private String accdate;
+ private String acctime;
+ private Integer termid;
+ private String status;
+ private Integer revflag;
+ private String transtype;
+ private Integer shopid;
+ private String attr1;
+ private String revbillno;
+ private String transmode;
+ private Integer custtype;
+ private Double managefee;
+ private String mealtype;
+ private Integer termsqlno;
+ private String refno;
+ private String coreAccdate;
+ private String coreStatus;
+ @Id
+ @Column(name = "billno", unique = true, nullable = false, length = 20)
+ public String getBillno() {
+ return billno;
+ }
- @Id
- @Column(name = "billno", unique = true, nullable = false, length = 20)
- public String getBillno() {
- return billno;
- }
+ public void setBillno(String billno) {
+ this.billno = billno;
+ }
- public void setBillno(String billno) {
- this.billno = billno;
- }
+ @Column(name = "custname", length = 30)
+ public String getCustname() {
+ return custname;
+ }
- @Column(name = "custname", length = 30)
- public String getCustname() {
- return custname;
- }
+ public void setCustname(String custname) {
+ this.custname = custname;
+ }
- public void setCustname(String custname) {
- this.custname = custname;
- }
+ @Column(name = "custid", length = 32)
+ public String getCustid() {
+ return custid;
+ }
- @Column(name = "custid", length = 32)
- public String getCustid() {
- return custid;
- }
+ public void setCustid(String custid) {
+ this.custid = custid;
+ }
- public void setCustid(String custid) {
- this.custid = custid;
- }
+ @Column(name = "cardno", length = 9)
+ public String getCardno() {
+ return cardno;
+ }
- @Column(name = "cardno", length = 9)
- public String getCardno() {
- return cardno;
- }
+ public void setCardno(String cardno) {
+ this.cardno = cardno;
+ }
- public void setCardno(String cardno) {
- this.cardno = cardno;
- }
+ @Column(name = "amount", precision = 15)
+ @NotNull
+ public Double getAmount() {
+ return amount;
+ }
- @Column(name = "amount", precision = 15)
- public Double getAmount() {
- return amount;
- }
+ public void setAmount(Double amount) {
+ this.amount = amount;
+ }
- public void setAmount(Double amount) {
- this.amount = amount;
- }
+ @Column(name = "transdate", length = 8)
+ @NotNull
+ public String getTransdate() {
+ return transdate;
+ }
- @Column(name = "transdate", length = 8)
- public String getTransdate() {
- return transdate;
- }
+ public void setTransdate(String transdate) {
+ this.transdate = transdate;
+ }
- public void setTransdate(String transdate) {
- this.transdate = transdate;
- }
+ @Column(name = "transtime", length = 6)
+ @NotNull
+ public String getTranstime() {
+ return transtime;
+ }
- @Column(name = "transtime", length = 6)
- public String getTranstime() {
- return transtime;
- }
+ public void setTranstime(String transtime) {
+ this.transtime = transtime;
+ }
- public void setTranstime(String transtime) {
- this.transtime = transtime;
- }
+ @Column(name = "accdate", length = 8)
+ public String getAccdate() {
+ return accdate;
+ }
- @Column(name = "accdate", length = 8)
- public String getAccdate() {
- return accdate;
- }
+ public void setAccdate(String accdate) {
+ this.accdate = accdate;
+ }
- public void setAccdate(String accdate) {
- this.accdate = accdate;
- }
+ @Column(name = "acctime", length = 6)
+ public String getAcctime() {
+ return acctime;
+ }
- @Column(name = "acctime", length = 6)
- public String getAcctime() {
- return acctime;
- }
+ public void setAcctime(String acctime) {
+ this.acctime = acctime;
+ }
- public void setAcctime(String acctime) {
- this.acctime = acctime;
- }
+ @Column(name = "termid", length = 9)
+ public Integer getTermid() {
+ return termid;
+ }
- @Column(name = "termid", length = 9)
- public Integer getTermid() {
- return termid;
- }
+ public void setTermid(Integer termid) {
+ this.termid = termid;
+ }
- public void setTermid(Integer termid) {
- this.termid = termid;
- }
+ @Column(name = "status", length = 10)
+ public String getStatus() {
+ return status;
+ }
- @Column(name = "status", length = 10)
- public String getStatus() {
- return status;
- }
+ public void setStatus(String status) {
+ this.status = status;
+ }
- public void setStatus(String status) {
- this.status = status;
- }
+ @Column(name = "revflag", length = 1)
+ public Integer getRevflag() {
+ return revflag;
+ }
- @Column(name = "revflag", length = 1)
- public Integer getRevflag() {
- return revflag;
- }
+ public void setRevflag(Integer revflag) {
+ this.revflag = revflag;
+ }
- public void setRevflag(Integer revflag) {
- this.revflag = revflag;
- }
+ @Column(name = "transtype", length = 10)
+ public String getTranstype() {
+ return transtype;
+ }
- @Column(name = "transtype", length = 10)
- public String getTranstype() {
- return transtype;
- }
-
- public void setTranstype(String transtype) {
- this.transtype = transtype;
- }
+ public void setTranstype(String transtype) {
+ this.transtype = transtype;
+ }
- @Column(name = "shopid", length = 9)
- public Integer getShopid() {
- return shopid;
- }
+ @Column(name = "shopid", length = 9)
+ public Integer getShopid() {
+ return shopid;
+ }
- public void setShopid(Integer shopid) {
- this.shopid = shopid;
- }
+ public void setShopid(Integer shopid) {
+ this.shopid = shopid;
+ }
- @Column(name = "attr1", length = 200)
- public String getAttr1() {
- return attr1;
- }
+ @Column(name = "attr1", length = 200)
+ public String getAttr1() {
+ return attr1;
+ }
- public void setAttr1(String attr1) {
- this.attr1 = attr1;
- }
+ public void setAttr1(String attr1) {
+ this.attr1 = attr1;
+ }
- @Column(name = "revbillno", length = 20)
- public String getRevbillno() {
- return revbillno;
- }
+ @Column(name = "revbillno", length = 20)
+ public String getRevbillno() {
+ return revbillno;
+ }
- public void setRevbillno(String revbillno) {
- this.revbillno = revbillno;
- }
+ public void setRevbillno(String revbillno) {
+ this.revbillno = revbillno;
+ }
- @Column(name = "transmode", length = 10)
- public String getTransmode() {
- return transmode;
- }
+ @Column(name = "transmode", length = 10)
+ public String getTransmode() {
+ return transmode;
+ }
- public void setTransmode(String transmode) {
- this.transmode = transmode;
- }
+ public void setTransmode(String transmode) {
+ this.transmode = transmode;
+ }
- @Column(name="custtype",length = 1)
- public Integer getCusttype() {
- return custtype;
- }
+ @Column(name = "custtype", length = 1)
+ public Integer getCusttype() {
+ return custtype;
+ }
- public void setCusttype(Integer custtype) {
- this.custtype = custtype;
- }
+ public void setCusttype(Integer custtype) {
+ this.custtype = custtype;
+ }
- @Column(name="mealtype",length = 10)
- public String getMealtype() {
- return mealtype;
- }
+ @Column(name = "mealtype", length = 10)
+ public String getMealtype() {
+ return mealtype;
+ }
- public void setMealtype(String mealtype) {
- this.mealtype = mealtype;
- }
+ public void setMealtype(String mealtype) {
+ this.mealtype = mealtype;
+ }
- @Column(name="termsqlno",length = 9)
- public Integer getTermsqlno() {
- return termsqlno;
- }
+ @Column(name = "termsqlno", length = 9)
+ public Integer getTermsqlno() {
+ return termsqlno;
+ }
- public void setTermsqlno(Integer termsqlno) {
- this.termsqlno = termsqlno;
- }
+ public void setTermsqlno(Integer termsqlno) {
+ this.termsqlno = termsqlno;
+ }
- @Column(name = "managefee", precision = 15)
- public Double getManagefee() {
- return managefee;
- }
+ @Column(name = "managefee", precision = 15)
+ public Double getManagefee() {
+ return managefee;
+ }
- public void setManagefee(Double managefee) {
- this.managefee = managefee;
- }
+ public void setManagefee(Double managefee) {
+ this.managefee = managefee;
+ }
+
+ @Column(name = "refno", length = 32)
+ public String getRefno() {
+ return refno;
+ }
+
+ public void setRefno(String refno) {
+ this.refno = refno;
+ }
+
+ @Column(name = "core_accdate", length = 8)
+ public String getCoreAccdate() {
+ return coreAccdate;
+ }
+
+ public void setCoreAccdate(String coreAccdate) {
+ this.coreAccdate = coreAccdate;
+ }
+
+ @Column(name = "core_status", length = 20)
+ public String getCoreStatus() {
+ return coreStatus;
+ }
+
+ public void setCoreStatus(String coreStatus) {
+ this.coreStatus = coreStatus;
+ }
}