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