package cn.csbr.springboot.dao.model;

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.sql.Date;
import java.sql.Timestamp;

/**
 * @Author: Raymond
 * @Date: 2019/6/18 11:56
 * @Description:
 */
@Getter
@Setter
@ToString
@Table(name = "mfcubestockdetail_old")
public class MfcubestockdetailOld2 {

    @Id
    @Column( name = "guid" )
    private String guid;//

    @Column( name = "depotGuid" )
    private String depotGuid;// 仓库ID/科室ID

    @Column( name = "depotName" )
    private String depotName;// 仓库名称/科室名称，就是放柜子的部门

    @Column( name = "CubeGuid" )
    private String cubeGuid ;//柜子ID

    @Column( name = "CubeName" )
    private String cubeName;// 柜子名称

    @Column( name = "LocGuid" )
    private String locGuid;// 货位id

    @Column( name = "LocName" )
    private String locName;// 货位名称

    @Column( name = "LabGuid" )
    private String labGuid;// 高值码

    @Column( name = "GoodsGUID" )
    private String goodsGUID;// 商品id

    @Column( name = "GoodsName" )
    private String goodsName;// 商品名称

    @Column( name = "Unit" )
    private String unit;// 单位

    @Column( name = "Lot" )
    private String lot;// 批号

    @Column( name = "Productiondate" )
    private Timestamp productiondate;// 生产日期

    @Column( name = "ExpireDate" )
    private Timestamp expireDate;// 有效期

    @Column( name = "SterilantLot" )
    private String sterilantLot;// 灭菌批号

    @Column( name = "SterilantDate" )
    private Timestamp sterilantDate;// 灭菌日期

    @Column( name = "SterilantEXPDate" )
    private Timestamp sterilantEXPDate;// 灭菌效期

    @Column( name = "Number" )
    private String number;// 数量

    @Column( name = "OwnerGUID" )
    private String ownerGUID;// 货位主id

    @Column( name = "OwnerName" )
    private String ownerName;// 货主

    @Column( name = "SupplierGUID" )
    private String supplierGUID;// 供应商id

    @Column( name = "SupplierName" )
    private String supplierName;// 供应商名称

    @Column( name = "RkBillNo" )
    private String rkBillNo;// 入库单号

    @Column( name = "PriceBuy" )
    private String priceBuy;// 价格

    @Column( name = "AmountBuy" )
    private String amountBuy;// 金额

    @Column( name = "Varchar1" )
    private String varchar1;

    @Column( name = "Varchar2" )
    private String varchar2;

    @Column( name = "Varchar3" )
    private String varchar3;

    @Column( name = "Varchar4" )
    private String varchar4;

    @Column( name = "Num1" )
    private String num1;

    @Column( name = "Num2" )
    private String num2;

    @Column( name = "Num3" )
    private String num3;
    ;
    @Column( name = "CREATE_TIME" )
    private Timestamp createTime;

    @Column( name = "UPDATE_TIME" )
    private Timestamp updateTime;

    @Column( name = "RfidUid" )
    private String rfidUid;// rfid标签id

    @Column( name = "BillState" )
    private String billState;// O:取货Y:在柜

    @Column( name = "use_time" )
    private Date useTime;// 取货时间

    @Column( name = "back_time" )
    private Date backTime;// 还货时间

    @Column( name = "use_username" )
    private String useUsername;

    @Column( name = "back_username" )
    private String backUsername;
}