baqing-shop/sql/biz_goods_freight.sql

-- 商品快递运费配置
CREATE TABLE IF NOT EXISTS `biz_goods_freight` (
  `goods_id`            bigint(20)    NOT NULL COMMENT '商品ID',
  `freight_type`        char(1)       NOT NULL COMMENT '1固定运费2运费模版',
  `fixed_amount`        decimal(10,2) DEFAULT NULL COMMENT '固定运费金额',
  `freight_template_id` bigint(20)    DEFAULT NULL COMMENT '运费模版ID',
  `del_flag`            char(1)       NOT NULL DEFAULT '0' COMMENT '0正常2删除',
  `create_time`         datetime      DEFAULT NULL,
  `update_time`         datetime      DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  KEY `idx_freight_template` (`freight_template_id`,`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商品快递运费配置';