商城sql

DROP TABLE IF EXISTS pms_spec;
CREATE TABLE pms_spec (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格名称’,
nick_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘规格别名’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0 未删除 1 删除 默认0’,
create_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建者名称’,
modify_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改人’,
del_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除人名称’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘规格表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_spec VALUES (4, ‘颜色’, ‘’, ‘0’, ‘admin’, ‘admin2’, NULL, NULL, NULL, ‘2020-11-03 12:37:14’);
INSERT INTO pms_spec VALUES (5, ‘尺寸’, ‘’, ‘0’, ‘admin’, ‘admin’, NULL, NULL, NULL, ‘2020-10-27 14:58:02’);
INSERT INTO pms_spec VALUES (6, ‘版本’, ‘’, ‘0’, ‘admin1’, NULL, NULL, NULL, NULL, NULL);

DROP TABLE IF EXISTS pms_category;
CREATE TABLE pms_category (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘分类名称’,
parent_id bigint(20) NOT NULL DEFAULT 0 COMMENT ‘父级分类id 没有父级 则为0’,
type_id bigint(20) DEFAULT NULL COMMENT ‘类型id，只有分类是三级分类的时候才有 一级和二级分类没有’,
grade char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘分类的层级 1 一级 2 二级 3 三级’,
rate decimal(3, 2) DEFAULT NULL COMMENT ‘分类扣率 三级分类的时候才有，主要是和店铺对账使用’,
sort int(11) DEFAULT NULL COMMENT ‘排序 数值越低 排序越前’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0未删除 1删除 默认0’,
create_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建者名称’,
modify_name varchar(145) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改者名称’,
del_name varchar(145) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除者名称’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品分类表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_category VALUES (19, ‘服装鞋包’, 0, NULL, ‘1’, NULL, 1, ‘0’, ‘admin’, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-5a473c0e82434b0299ba7b28944d8a4f.’, ‘/pages/user/coupon/list’, NULL, ‘2020-10-26 10:09:10’, NULL);
INSERT INTO pms_category VALUES (20, ‘美妆护肤’, 0, NULL, ‘1’, NULL, 2, ‘0’, ‘admin’, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-e7143fd23d2b4aefa6a14400c7092409.’, ‘/pages/marketing/preMarking’, NULL, NULL, NULL);
INSERT INTO pms_category VALUES (21, ‘手机数码’, 0, NULL, ‘1’, NULL, 1, ‘0’, ‘admin’, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-92a2f26440fd4ac1bdc49fbee9aad0ce.’, ‘/pages/product/jifenList’, NULL, NULL, NULL);
INSERT INTO pms_category VALUES (22, ‘男装’, 19, NULL, ‘2’, NULL, 2, ‘0’, ‘admin’, NULL, NULL, NULL, ‘2020-10-25 12:01:25’, NULL);

DROP TABLE IF EXISTS pms_category_spec;
CREATE TABLE pms_category_spec (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
cate_id bigint(20) NOT NULL COMMENT ‘分类id 对应pms_category表中的id’,
spec_id bigint(20) NOT NULL COMMENT ‘规格id 对应pms_goods_spec 表中的id’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0 未删除 1删除 默认0’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘分类和规格的关联表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_category_spec VALUES (13, 28, 4, ‘0’);

DROP TABLE IF EXISTS pms_spec_value;
CREATE TABLE pms_spec_value (
id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘主键id’,
spec_id bigint(20) NOT NULL COMMENT ‘规格id 对应pms_goods_spec表中的id’,
name varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格值的名称’,
sort int(11) DEFAULT NULL COMMENT ‘排序 数值越小排序越前’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0 未删除 1删除 默认0’,
create_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建者名称’,
modify_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改者名称’,
del_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除者名称’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id) USING BTREE,
INDEX spec_id(spec_id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘规格值表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_spec_value VALUES (‘159807754093040’, 4, ‘红色’, 1, ‘0’, ‘admin2’, NULL, NULL, ‘2020-11-03 12:37:14’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘159807754093041’, 4, ‘蓝色’, 1, ‘0’, ‘admin2’, NULL, NULL, ‘2020-11-03 12:37:14’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘159807754093042’, 4, ‘白色’, 1, ‘0’, ‘admin2’, NULL, NULL, ‘2020-11-03 12:37:14’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘159807755904350’, 5, ‘L’, 1, ‘0’, ‘admin’, NULL, NULL, ‘2020-10-27 14:58:02’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘159807755904351’, 5, ‘M’, 1, ‘0’, ‘admin’, NULL, NULL, ‘2020-10-27 14:58:02’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘159807755904352’, 5, ‘XXL’, 1, ‘0’, ‘admin’, NULL, NULL, ‘2020-10-27 14:58:02’, NULL, NULL);
INSERT INTO pms_spec_value VALUES (‘160015227683250’, 5, ‘版型’, 1, ‘0’, ‘admin’, NULL, NULL, ‘2020-10-27 14:58:02’, NULL, NULL);

DROP TABLE IF EXISTS pms_sku_spec_value;
CREATE TABLE pms_sku_spec_value (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
spu_id bigint(20) NOT NULL COMMENT ‘商品id’,
sku_id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘单品id 对应pms_sku表中的id’,
spec_id bigint(20) NOT NULL COMMENT ‘规格id 对应pms_spec表中的id’,
spec_value_id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格值id 对应pms_spec_value 表中的id’,
value_remark varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格值’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT '删除标记 0 未删除 1 删除 默认0 ',
PRIMARY KEY (id) USING BTREE,
INDEX spec_id(spec_id) USING BTREE,
INDEX sku_id(sku_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 657 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘单品的规格值表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_sku_spec_value VALUES (144, 26, ‘1598230936517262’, 5, ‘159807755904352’, ‘XXL’, ‘0’);

DROP TABLE IF EXISTS pms_type;
CREATE TABLE pms_type (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘类型名称’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0 未删除 1删除 默认0’,
create_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建者名称’,
modify_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改者名称’,
del_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除者名称’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品类型表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_type VALUES (4, ‘年份’, ‘0’, ‘admin’, NULL, NULL, NULL, NULL, NULL);
INSERT INTO pms_type VALUES (5, ‘www’, ‘0’, ‘admin2’, ‘admin2’, NULL, NULL, ‘2020-09-24 19:47:21’, NULL);
INSERT INTO pms_type VALUES (6, ‘’, ‘0’, ‘admin’, NULL, NULL, NULL, NULL, NULL);
INSERT INTO pms_type VALUES (7, ‘颜色’, ‘0’, ‘admin’, NULL, NULL, NULL, NULL, NULL);
INSERT INTO pms_type VALUES (8, ‘产地’, ‘0’, ‘admin1’, ‘admin’, NULL, NULL, ‘2020-11-02 18:42:03’, NULL);
INSERT INTO pms_type VALUES (9, ‘nono’, ‘0’, ‘admin’, NULL, NULL, NULL, NULL, NULL);

DROP TABLE IF EXISTS pms_goods_spec_value;
CREATE TABLE pms_goods_spec_value (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
spu_id bigint(20) NOT NULL COMMENT ‘商品id 对应pms_goods表中的id’,
spec_id bigint(20) NOT NULL COMMENT ‘规格id 对应pms_spec表中的id’,
spec_value_id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格值id 对应pms_spec_value表中的id’,
url varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘规格值的图片地址’,
value_remark varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘规格值’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT '删除标记 0 未删除 1 删除 默认0 ',
PRIMARY KEY (id) USING BTREE,
INDEX spu_id(spu_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 310 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品和规格值的关联表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_goods_spec_value VALUES (85, 25, 4, ‘159807754093040’, NULL, ‘红色’, ‘0’);
INSERT INTO pms_goods_spec_value VALUES (86, 25, 4, ‘159807754093041’, NULL, ‘蓝色’, ‘0’);
INSERT INTO pms_goods_spec_value VALUES (87, 25, 4, ‘159807754093042’, NULL, ‘白色’, ‘0’);

DROP TABLE IF EXISTS pms_goods;
CREATE TABLE pms_goods (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品名称’,
subtitle varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘商品副标题’,
price decimal(20, 2) DEFAULT NULL COMMENT ‘销售价’,
pc_desc text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT ‘PC版详情’,
mobile_desc text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT ‘手机版详情’,
seo_title varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘seo标题’,
seo_keywords varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘seo关键字’,
seo_desc varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘see描述’,
store_id bigint(20) NOT NULL COMMENT '商品的店铺id 如果是平台的则为0 ',
first_cate_id bigint(20) DEFAULT NULL COMMENT ‘一级分类id’,
second_cate_id bigint(20) DEFAULT NULL COMMENT ‘二级分类id’,
third_cate_id bigint(20) DEFAULT NULL COMMENT ‘三级分类id’,
type_id bigint(20) NOT NULL COMMENT ‘类型id’,
brand_id bigint(20) NOT NULL COMMENT ‘品牌id’,
store_fcate_id bigint(20) DEFAULT NULL COMMENT ‘店铺一级分类’,
store_scate_id bigint(20) DEFAULT NULL COMMENT ‘店铺二级分类’,
store_tcate_id bigint(20) DEFAULT NULL COMMENT ‘店铺三级分类’,
url varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘商品图片’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0未删除 1删除 默认0’,
create_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建人的名称’,
modify_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改人的名称’,
del_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除人的名字’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
commission_rate decimal(3, 2) DEFAULT 0.00 COMMENT ‘佣金比例’,
s_commission_rate decimal(3, 2) DEFAULT 0.00 COMMENT ‘二级佣金比例’,
status char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘审核状态 0 审核通过 1 审核未通过 2 审核中’,
shelves_status char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘商品上架状态 0 下架 1上架 2违规下架 默认0’,
is_virtual char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘是否是虚拟商品 0 否 1 是默认0’,
video varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘商品视频地址’,
video_pic varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘商品视频封面地址’,
logistics_template_id bigint(20) DEFAULT NULL COMMENT ‘物流模版id 对应oms_logistics_template表的id’,
store_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘店鋪名稱’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_goods VALUES (24, ‘平台试用商品’, NULL, 1001.00, ‘’, ‘’, ‘’, ‘’, ‘’, 0, 19, 22, 28, 4, 3, NULL, NULL, NULL, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-34f50ccb68b94b32af4ee63f283030a7.’, ‘0’, ‘admin’, NULL, NULL, ‘2020-08-22 14:59:44’, ‘2020-11-18 13:28:04’, NULL, 0.00, 0.00, ‘3’, ‘0’, ‘0’, ‘’, ‘’, 7, ‘平台自营’);
INSERT INTO pms_goods VALUES (25, ‘平台分销商品’, NULL, 1100.00, ‘

32

’, ‘

32

’, ‘’, ‘’, ‘’, 0, 19, 22, 28, 4, 3, NULL, NULL, NULL, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-733e78fcd86f498cb4393a5b4a5e7fb0.’, ‘0’, ‘admin’, NULL, NULL, ‘2020-08-22 15:01:04’, ‘2020-10-21 19:45:37’, NULL, 0.10, 0.05, ‘3’, ‘1’, ‘0’, ‘’, ‘’, 8, ‘平台自营’);

DROP TABLE IF EXISTS pms_goods_attribute_value;
CREATE TABLE pms_goods_attribute_value (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
spu_id bigint(20) NOT NULL COMMENT ‘商品id’,
attribute_id varchar(126) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘属性id’,
attribute_name varchar(126) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘属性名称’,
attribute_value_id varchar(126) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘属性值id’,
attribute_value varchar(126) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘属性值’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT '删除标记 0 未删除 1删除 默认0 ',
PRIMARY KEY (id) USING BTREE,
INDEX spu_id(spu_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 98 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品下面的属性值’ ROW_FORMAT = Dynamic;
INSERT INTO pms_goods_attribute_value VALUES (41, 25, ‘159807764670340’, ‘年份’, ‘15980776467161598077646703400’, ‘1999’, ‘0’);
INSERT INTO pms_goods_attribute_value VALUES (42, 26, ‘159807764670340’, ‘年份’, ‘15980776467161598077646703400’, ‘1999’, ‘0’);
INSERT INTO pms_goods_attribute_value VALUES (43, 27, ‘159807764670340’, ‘年份’, ‘15980776467161598077646703400’, ‘1999’, ‘0’);

DROP TABLE IF EXISTS pms_sku;
CREATE TABLE pms_sku (
id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘主键id’,
spu_id bigint(20) NOT NULL COMMENT ‘商品id ，对应pms_goods中的id’,
sku_no varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘单品的编号’,
name varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘单品的名称’,
subtitle varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘单品的副标题’,
stock int(11) NOT NULL COMMENT ‘单品库存’,
warning_stock int(11) DEFAULT NULL COMMENT ‘预警库存’,
price decimal(20, 2) NOT NULL COMMENT ‘单品价格’,
weight decimal(20, 2) NOT NULL COMMENT ‘单品的重量’,
store_id bigint(20) NOT NULL COMMENT ‘店铺id 如果是平台 则是0’,
shelves_status char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘单品上架状态 0 下架 1上架 2 违规下架 默认0’,
url varchar(124) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘默认图片的url’,
status char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘审核状态 0 审核通过 1 审核未通过 2 审核中’,
reason varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘拒绝原因’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘删除标记 0 未删除 1删除 默认0’,
create_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘创建者名称’,
modify_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘修改者名称’,
del_name varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除者名称’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
up_time timestamp(0) DEFAULT NULL COMMENT ‘单品上架时间’,
commission_rate decimal(3, 2) DEFAULT 0.00 COMMENT ‘佣金比例 该字段是冗余字段，和商品表中的佣金比例是一个字断’,
s_commission_rate decimal(3, 2) DEFAULT 0.00 COMMENT ‘二级佣金比例 该字段是冗余字段，和商品表中的佣金比例是一个字断’,
is_virtual char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘是否是虚拟商品 0 否 1 是 默认0 该字段是商品冗余字段 和商品表保持一致’,
is_batch_sku char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT ‘0’ COMMENT ‘是否批发商品 0否 1是 默认0’,
logistics_template_id bigint(20) DEFAULT NULL COMMENT ‘物流模版id 该字段是冗余字段和pms_goods表中的保持一致’,
PRIMARY KEY (id) USING BTREE,
INDEX spu_id(spu_id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘单品表’ ROW_FORMAT = Dynamic;
INSERT INTO pms_sku VALUES (‘1598079455498220’, 22, ‘1598079424000’, ‘平台牛仔裤(((红色-L)))’, ‘红色-L’, 92, -1, 1000.01, 54.00, 0, ‘1’, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-32685ab8abcd42b6928a2baf68b882f2.’, ‘3’, NULL, ‘0’, NULL, NULL, NULL, ‘2020-09-18 16:10:12’, NULL, NULL, ‘2020-10-24 16:44:03’, 0.00, 0.00, ‘0’, ‘0’, 7);
INSERT INTO pms_sku VALUES (‘1598079455498221’, 22, ‘1598079424001’, ‘平台牛仔裤(((红色-M)))’, ‘红色-M’, 100, -1, 1000.01, 54.00, 0, ‘1’, ‘http://wskj-mallplus.oss-cn-beijing.aliyuncs.com/wskj-mallplus-20200822-32685ab8abcd42b6928a2baf68b882f2.’, ‘3’, NULL, ‘0’, NULL, NULL, NULL, ‘2020-09-18 16:10:12’, NULL, NULL, ‘2020-10-24 16:44:03’, 0.00, 0.00, ‘0’, ‘0’, 7);

DROP TABLE IF EXISTS ums_bussiness_category;
CREATE TABLE ums_bussiness_category (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘分类名称’,
parent_id bigint(20) NOT NULL COMMENT ‘上级分类id 0 表示没有上级’,
grade int(11) NOT NULL COMMENT ‘1 一级分类 2 二级分类 3 三级分类’,
sort int(11) DEFAULT NULL COMMENT ‘排序 数值越小 越靠前’,
bussiness_id bigint(20) DEFAULT NULL COMMENT ‘店铺id’,
del_flag char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘删除标记 0 未删除 1 删除’,
create_time timestamp(0) DEFAULT NULL COMMENT ‘创建时间’,
modify_time timestamp(0) DEFAULT NULL COMMENT ‘修改时间’,
del_time timestamp(0) DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘店铺分类’ ROW_FORMAT = Dynamic;