etrade / dili-xtrade · Files

DROP TABLE IF EXISTS `shop_express_setting`;
CREATE TABLE `shop_express_setting`
(
    `id`            bigint   NOT NULL AUTO_INCREMENT,
    `shop_id`       bigint   NOT NULL COMMENT '店铺id',
    `type`          json     NOT NULL COMMENT '配送方式',
    `fee`           DECIMAL(24, 2)    DEFAULT NULL COMMENT '固定运费',
    `condition`     json              DEFAULT NULL COMMENT '包邮条件',
    `free_amount`   DECIMAL(24, 2)    DEFAULT NULL COMMENT '包邮金额',
    `free_time`     time COMMENT '包邮时间',
    `period`        int COMMENT '包邮时间段(如偏移24小时)',
    `created_time`  datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `creater`       varchar(50) NULL DEFAULT NULL COMMENT '创建人名字',
    `creater_id`    bigint NULL DEFAULT NULL COMMENT '创建人ID',
    `modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `modifier`      varchar(50) NULL DEFAULT NULL COMMENT '修改人名字',
    `modifier_id`   bigint NULL DEFAULT NULL COMMENT '修改人ID',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX           idx_shop_id(`shop_id`) USING BTREE COMMENT '店铺id'
) ENGINE = InnoDB AUTO_INCREMENT = 1   COMMENT = '店铺运费设置';