package zs.payment.entity.mysql;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

import java.math.BigDecimal;

/**
 * 商品规格选项
 */
@Setter
@Getter
@NoArgsConstructor
@TableName("ims_ewei_shop_goods_option")
public class ImsEweiShopGoodsOption {
    //create table ims_ewei_shop_goods_option
    //(
    //    id                int auto_increment
    //        primary key,
    //    uniacid           int            default 0    null,
    //    goodsid           int(10)        default 0    null,
    //    title             varchar(255)   default ''   null,
    //    thumb             varchar(60)    default ''   null,
    //    productprice      decimal(10, 2) default 0.00 null,
    //    marketprice       decimal(10, 2) default 0.00 null,
    //    costprice         decimal(10, 2) default 0.00 null,
    //    stock             int            default 0    null,
    //    weight            decimal(10, 2) default 0.00 null,
    //    displayorder      int            default 0    null,
    //    specs             text                        null,
    //    skuId             varchar(255)   default ''   null,
    //    goodssn           varchar(255)   default ''   null,
    //    productsn         varchar(255)   default ''   null,
    //    `virtual`         int            default 0    null,
    //    exchange_stock    int            default 0    null,
    //    exchange_postage  decimal(10, 2) default 0.00 not null,
    //    presellprice      decimal(10, 2) default 0.00 not null,
    //    day               int(3)                      not null,
    //    allfullbackprice  decimal(10, 2)              not null,
    //    fullbackprice     decimal(10, 2)              not null,
    //    allfullbackratio  decimal(10, 2)              null,
    //    fullbackratio     decimal(10, 2)              null,
    //    isfullback        tinyint(3)                  not null,
    //    islive            int                         not null,
    //    liveprice         decimal(10, 2) default 0.00 not null,
    //    cycelbuy_periodic varchar(20)    default ''   not null,
    //    sku_id            int            default 0    null comment '云商城规格id'
    //)

    @TableId(type = IdType.AUTO)
    private Long id;

    //所属企云商城的id
    private Integer uniacid;

    //商品id
    private Integer goodsid;

    //规格标题
    private String title;

    //缩略图
    private String thumb;

    //销售价
    private BigDecimal productprice;

    //市场价
    private BigDecimal marketprice;

    //成本价
    private BigDecimal costprice;

    //库存
    private Integer stock;

    //重量
    private BigDecimal weight;

    //排序
    private Integer displayorder;

    //规格内容
    private String specs;

    //SKU id ,存储芸信的商品规格id,下单与获取运费验证是否可售等使用这个
    private String skuId;

    //商品编号
    private String goodssn;

    //货品编号
    private String productsn;

    //是否虚拟
    private Integer virtual;

    //兑换库存
    private Integer exchange_stock;

    //兑换邮费
    private BigDecimal exchange_postage;

    //预售价
    private BigDecimal presellprice;

    //天数
    private Integer day;

    //全返总价 必填
    private BigDecimal allfullbackprice;

    //全返价 必填
    private BigDecimal fullbackprice;

    //全返总比例
    private BigDecimal allfullbackratio;

    //全返比例
    private BigDecimal fullbackratio;

    //是否全返
    private Integer isfullback;

    //是否直播
    private Integer islive;

    //直播价
    private BigDecimal liveprice;

    //周期购周期
    private String cycelbuy_periodic;

    //云商城规格id
    private Integer sku_id;

}