package com.by4cloud.platformx.business.entity;
|
|
import com.by4cloud.platformx.common.data.mybatis.BaseModel;
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import io.swagger.v3.oas.annotations.media.Schema;
|
import jakarta.persistence.Column;
|
import jakarta.persistence.Entity;
|
import lombok.Data;
|
import org.hibernate.annotations.Table;
|
import org.springframework.format.annotation.DateTimeFormat;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
/**
|
* 2026年8月7日 16:04:22
|
* syt
|
*/
|
@Data
|
@Entity//加了才能自动生成表
|
@Table(appliesTo="bank_statement",comment = "银行流水")//给表加注释
|
@jakarta.persistence.Table(name = "bank_statement")//数据库创建的表明
|
public class BankStatement extends BaseModel<BankStatement> {
|
|
@Schema(description = "交易流水")
|
@Column(columnDefinition="VARCHAR(128) comment '交易流水'")
|
private String bankSeqNo;
|
|
@Schema(description = "收款银行账户id")
|
@Column(columnDefinition="VARCHAR(128) comment '收款银行账户id'")
|
private String receiveBankAcc;
|
|
@Schema(description = "收款银行账户账号")
|
@Column(columnDefinition="VARCHAR(128) comment '收款银行账户账号'")
|
private String receiveBankAccAcc;
|
|
@Schema(description = "收款银行账户户名")
|
@Column(columnDefinition="VARCHAR(128) comment '收款银行账户户名'")
|
private String receiveBankAccName;
|
|
@Schema(description = "付款银行账户")
|
@Column(columnDefinition="VARCHAR(128) comment '付款银行账户'")
|
private String payBankNo;
|
|
@Schema(description = "付款银行账户户名")
|
@Column(columnDefinition="VARCHAR(128) comment '付款银行账户户名'")
|
private String payBankAccName;
|
|
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
@Schema(description = "交易时间")
|
@Column(columnDefinition = "datetime comment '交易时间'")
|
private Date tranDate;
|
|
@Schema(description = "交易金额")
|
@Column(columnDefinition = "decimal(10,2) comment '交易金额'")
|
private BigDecimal tranAmount;
|
|
@Schema(description = "数据ID")
|
@Column(columnDefinition="bigint comment '数据ID'")
|
private Long dataId;
|
|
@Schema(description = "数据")
|
@Column(columnDefinition="text comment '数据'")
|
private String dataJson;
|
|
@Schema(description = "客户ID")
|
@Column(columnDefinition="bigint comment '客户ID'")
|
private Long busGuestId;
|
|
@Schema(description = "合同ID")
|
@Column(columnDefinition="bigint comment '合同ID'")
|
private Long contractId;
|
}
|
