1960 lines
114 KiB
SQL
1960 lines
114 KiB
SQL
/*
|
||
Navicat MySQL Dump SQL
|
||
|
||
Source Server : mall_cloud
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80402 (8.4.2)
|
||
Source Host : mysql8.excn.vip:3308
|
||
Source Schema : mall
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80402 (8.4.2)
|
||
File Encoding : 65001
|
||
|
||
Date: 02/12/2024 13:28:32
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_help
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_help`;
|
||
CREATE TABLE `cms_help` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`category_id` bigint NULL DEFAULT NULL COMMENT '帮助分类id',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
|
||
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '标题',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`read_count` int NULL DEFAULT NULL COMMENT '阅读数量',
|
||
`content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '内容',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '帮助表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_help
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_help_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_help_category`;
|
||
CREATE TABLE `cms_help_category` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类名称',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类图标',
|
||
`help_count` int NULL DEFAULT NULL COMMENT '专题数量',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '帮助分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_help_category
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_member_report
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_member_report`;
|
||
CREATE TABLE `cms_member_report` (
|
||
`id` bigint NULL DEFAULT NULL COMMENT '主键id',
|
||
`report_type` int NULL DEFAULT NULL COMMENT '举报类型：0->商品评价；1->话题内容；2->用户评论',
|
||
`report_member_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '举报人',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '举报时间',
|
||
`report_object` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
||
`report_status` int NULL DEFAULT NULL COMMENT '举报状态：0->未处理；1->已处理',
|
||
`handle_status` int NULL DEFAULT NULL COMMENT '处理结果：0->无效；1->有效；2->恶意',
|
||
`note` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户举报表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_member_report
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_prefrence_area
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_prefrence_area`;
|
||
CREATE TABLE `cms_prefrence_area` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专区名称',
|
||
`sub_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '子标题',
|
||
`pic` varbinary(500) NULL DEFAULT NULL COMMENT '展示图片',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优选专区' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_prefrence_area
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_prefrence_area_product_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_prefrence_area_product_relation`;
|
||
CREATE TABLE `cms_prefrence_area_product_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`prefrence_area_id` bigint NULL DEFAULT NULL COMMENT '优先专区id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优选专区和产品关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_prefrence_area_product_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_subject
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_subject`;
|
||
CREATE TABLE `cms_subject` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`category_id` bigint NULL DEFAULT NULL COMMENT '专题分类id',
|
||
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '标题',
|
||
`pic` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专题主图',
|
||
`product_count` int NULL DEFAULT NULL COMMENT '关联产品数量',
|
||
`recommend_status` int NULL DEFAULT NULL COMMENT '推荐状态（0->未推荐；1->已推荐）',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`collect_count` int NULL DEFAULT NULL COMMENT '收藏数量',
|
||
`read_count` int NULL DEFAULT NULL COMMENT '阅读数量',
|
||
`comment_count` int NULL DEFAULT NULL COMMENT '评论数量',
|
||
`album_pics` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '画册图片用逗号分割',
|
||
`description` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '内容',
|
||
`forward_count` int NULL DEFAULT NULL COMMENT '转发数',
|
||
`category_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专题分类名称',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '专题表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_subject
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_subject_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_subject_category`;
|
||
CREATE TABLE `cms_subject_category` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专题名称',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类图标',
|
||
`subject_count` int NULL DEFAULT NULL COMMENT '专题数量',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '专题分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_subject_category
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_subject_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_subject_comment`;
|
||
CREATE TABLE `cms_subject_comment` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`subject_id` bigint NULL DEFAULT NULL COMMENT '专题id',
|
||
`member_nick_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
|
||
`member_icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员头像',
|
||
`content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '评论内容',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '评论时间',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '专题评论表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_subject_comment
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_subject_product_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_subject_product_relation`;
|
||
CREATE TABLE `cms_subject_product_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`subject_id` bigint NULL DEFAULT NULL COMMENT '专题id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '专题商品关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_subject_product_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_topic
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_topic`;
|
||
CREATE TABLE `cms_topic` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`category_id` bigint NULL DEFAULT NULL COMMENT '话题分类id',
|
||
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '话题名称',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
|
||
`attend_count` int NULL DEFAULT NULL COMMENT '参与人数',
|
||
`attention_count` int NULL DEFAULT NULL COMMENT '关注人数',
|
||
`read_count` int NULL DEFAULT NULL COMMENT '阅读数量',
|
||
`award_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '奖品名称',
|
||
`attend_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '参与方式',
|
||
`content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '话题内容',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '话题表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_topic
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_topic_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_topic_category`;
|
||
CREATE TABLE `cms_topic_category` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类图标',
|
||
`subject_count` int NULL DEFAULT NULL COMMENT '专题数量',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '话题分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_topic_category
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for cms_topic_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `cms_topic_comment`;
|
||
CREATE TABLE `cms_topic_comment` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_nick_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
|
||
`topic_id` bigint NULL DEFAULT NULL COMMENT '专题id',
|
||
`member_icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员头像',
|
||
`content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '评论内容',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '评论时间',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '专题评论表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of cms_topic_comment
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_distribution_dictionary
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_distribution_dictionary`;
|
||
CREATE TABLE `dms_distribution_dictionary` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`value` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '参数值',
|
||
`comment` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`show_status` int NULL DEFAULT 1 COMMENT '显示状态（ 0: 不显示 1: 显示）',
|
||
`update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '分销字典表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_distribution_dictionary
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_bank_account
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_bank_account`;
|
||
CREATE TABLE `dms_member_bank_account` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`account_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '账户名',
|
||
`bank_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行名称',
|
||
`bank_card_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行卡号',
|
||
`open_bank_address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '开户行地址',
|
||
`default_status` int NULL DEFAULT NULL COMMENT '是否默认：0->否；1->是',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员银行账户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_bank_account
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_freeze_account_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_freeze_account_record`;
|
||
CREATE TABLE `dms_member_freeze_account_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`item_type` int NULL DEFAULT NULL COMMENT '项目类型',
|
||
`type` int NULL DEFAULT NULL COMMENT '收支类型：0->收入；1->支出',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易标题',
|
||
`note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`customer_id` bigint NULL DEFAULT NULL COMMENT '消费者Id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员冻结账户记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_freeze_account_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_month_reward_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_month_reward_record`;
|
||
CREATE TABLE `dms_member_month_reward_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`year` int NULL DEFAULT NULL COMMENT '年份',
|
||
`month` int NULL DEFAULT NULL COMMENT '月份',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员月度奖励发放记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_month_reward_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_total_income
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_total_income`;
|
||
CREATE TABLE `dms_member_total_income` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`item_type` int NULL DEFAULT NULL COMMENT '项目类型',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员总收入表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_total_income
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_trade_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_trade_record`;
|
||
CREATE TABLE `dms_member_trade_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`item_type` int NULL DEFAULT NULL COMMENT '项目类型',
|
||
`type` int NULL DEFAULT NULL COMMENT '收支类型：0->收入；1->支出',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易标题',
|
||
`note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`customer_id` bigint NULL DEFAULT NULL COMMENT '消费者Id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员账户交易记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_trade_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_transfer_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_transfer_record`;
|
||
CREATE TABLE `dms_member_transfer_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '转账会员id',
|
||
`member_nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '转账会员昵称',
|
||
`receiver_id` bigint NULL DEFAULT NULL COMMENT '接收会员Id',
|
||
`receiver_nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '接收会员昵称',
|
||
`receiver_phone` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '接收会员手机号',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员转账记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_transfer_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_member_withdraw_apply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_member_withdraw_apply`;
|
||
CREATE TABLE `dms_member_withdraw_apply` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`poundage` decimal(10, 2) NULL DEFAULT NULL COMMENT '手续费',
|
||
`actual_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '扣出手续费后的值',
|
||
`account_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '账户名',
|
||
`bank_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行名称',
|
||
`bank_card_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行卡号',
|
||
`open_bank_address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '开户行地址',
|
||
`real_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
|
||
`alipay_account` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '支付宝账号',
|
||
`wechat_account` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '微信账号',
|
||
`wechat_nickname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '微信昵称',
|
||
`withdraw_type` int NULL DEFAULT NULL COMMENT '提现方式(0: 支付宝; 1: 微信; 2: 银行卡)',
|
||
`payment_status` int NULL DEFAULT NULL COMMENT '付款状态：0->未打款；1->已打款；2->打款失败',
|
||
`failed_reason` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '失败原因',
|
||
`payment_time` datetime NULL DEFAULT NULL COMMENT '付款时间',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员提现申请表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_member_withdraw_apply
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_offline_payment_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_offline_payment_record`;
|
||
CREATE TABLE `dms_offline_payment_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`seller_bank_account_id` int NULL DEFAULT NULL COMMENT '商家银行账户id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`order_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单编号',
|
||
`pay_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
||
`payment_account_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '支付账户名',
|
||
`payment_bank_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '支付银行名称',
|
||
`payment_bank_card_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '支付银行卡号',
|
||
`confirm_status` int NULL DEFAULT NULL COMMENT '确认状态：0->未确认；1->已确认',
|
||
`confirm_time` datetime NULL DEFAULT NULL COMMENT '确认时间',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `idx_order_id`(`order_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '线下支付记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_offline_payment_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_platform_income
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_platform_income`;
|
||
CREATE TABLE `dms_platform_income` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`customer_id` bigint NULL DEFAULT NULL COMMENT '消费者Id',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
`note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '平台收入表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_platform_income
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_seller_bank_account
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_seller_bank_account`;
|
||
CREATE TABLE `dms_seller_bank_account` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`account_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '账户名',
|
||
`bank_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行名称',
|
||
`bank_card_num` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行卡号',
|
||
`open_bank_address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '开户行地址',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商家银行账户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_seller_bank_account
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_team_level
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_team_level`;
|
||
CREATE TABLE `dms_team_level` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`parent_id` bigint NULL DEFAULT NULL COMMENT '推荐人id',
|
||
`level_tree` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '层级树',
|
||
`level` int NULL DEFAULT NULL COMMENT '当前层级',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '团队层级关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_team_level
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_team_member_number
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_team_member_number`;
|
||
CREATE TABLE `dms_team_member_number` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`total` int NULL DEFAULT 0 COMMENT '团队成员总数',
|
||
`consumer` int NULL DEFAULT 0 COMMENT '消费者人数',
|
||
`partner` int NULL DEFAULT 0 COMMENT '经销商人数',
|
||
`one_diamond` int NULL DEFAULT 0 COMMENT '初级合作商人数',
|
||
`two_diamond` int NULL DEFAULT 0 COMMENT '中级合作商人数',
|
||
`three_diamond` int NULL DEFAULT 0 COMMENT '高级合作商人数',
|
||
`four_diamond` int NULL DEFAULT 0 COMMENT '特级合作商人数',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '团队成员数量表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_team_member_number
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_team_total_consume
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_team_total_consume`;
|
||
CREATE TABLE `dms_team_total_consume` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '团队累计消费表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_team_total_consume
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dms_team_total_income
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dms_team_total_income`;
|
||
CREATE TABLE `dms_team_total_income` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`value` decimal(10, 2) NULL DEFAULT NULL COMMENT '值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '团队总收入表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dms_team_total_income
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_cart_item
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_cart_item`;
|
||
CREATE TABLE `oms_cart_item` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`product_sku_id` bigint NULL DEFAULT NULL COMMENT '商品SKU id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`quantity` int NULL DEFAULT NULL COMMENT '购买数量',
|
||
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '添加到购物车的价格',
|
||
`sp1` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性1',
|
||
`sp2` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性2',
|
||
`sp3` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性3',
|
||
`product_pic` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品主图',
|
||
`product_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`product_sub_title` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品副标题（卖点）',
|
||
`product_sku_code` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品sku条码',
|
||
`member_nickname` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
|
||
`create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`modify_date` datetime NULL DEFAULT NULL COMMENT '修改时间',
|
||
`delete_status` int NULL DEFAULT 0 COMMENT '是否删除',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类',
|
||
`product_brand` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品品牌',
|
||
`product_sn` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品货号',
|
||
`product_attr` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品销售属性:[{\"key\":\"颜色\",\"value\":\"颜色\"},{\"key\":\"容量\",\"value\":\"4G\"}]',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '购物车表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_cart_item
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_company_address
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_company_address`;
|
||
CREATE TABLE `oms_company_address` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`address_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地址名称',
|
||
`send_status` int NULL DEFAULT NULL COMMENT '默认发货地址：0->否；1->是',
|
||
`receive_status` int NULL DEFAULT NULL COMMENT '是否默认收货地址：0->否；1->是',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收发货人姓名',
|
||
`phone` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人电话',
|
||
`province` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '省/直辖市',
|
||
`city` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '市',
|
||
`region` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '区',
|
||
`detail_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详细地址',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '公司收发货地址表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_company_address
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_express_company
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_express_company`;
|
||
CREATE TABLE `oms_express_company` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '编码',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'express' COMMENT '类型',
|
||
`status` int NULL DEFAULT 1 COMMENT '启用状态：0->禁用；1->启用',
|
||
`changer` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '修改人',
|
||
`change_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
|
||
`creater` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '快递公司表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_express_company
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order`;
|
||
CREATE TABLE `oms_order` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NOT NULL COMMENT '会员id',
|
||
`coupon_id` bigint NULL DEFAULT NULL COMMENT '优惠卷id',
|
||
`order_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单编号',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
|
||
`member_username` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户帐号',
|
||
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
|
||
`pay_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '应付金额（实际支付金额）',
|
||
`freight_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费金额',
|
||
`promotion_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '促销优化金额（促销价、满减、阶梯价）',
|
||
`integration_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '积分抵扣金额',
|
||
`coupon_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠券抵扣金额',
|
||
`discount_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '管理员后台调整订单使用的折扣金额',
|
||
`pay_type` int NULL DEFAULT NULL COMMENT '支付方式：0->未支付；1->支付宝；2->微信；3->线下支付',
|
||
`source_type` int NULL DEFAULT NULL COMMENT '订单来源：0->PC订单；1->app订单',
|
||
`status` int NULL DEFAULT NULL COMMENT '订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单',
|
||
`order_type` int NULL DEFAULT NULL COMMENT '订单类型：0->正常订单；1->秒杀订单',
|
||
`delivery_type` int NULL DEFAULT NULL COMMENT '提货方式：0->自提；1->物流',
|
||
`delivery_company` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '物流公司',
|
||
`delivery_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '物流单号',
|
||
`auto_confirm_day` int NULL DEFAULT NULL COMMENT '自动确认时间（天）',
|
||
`integration` int NULL DEFAULT NULL COMMENT '可以获得的积分',
|
||
`growth` int NULL DEFAULT NULL COMMENT '可以活动的成长值',
|
||
`promotion_info` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '活动信息',
|
||
`bill_type` int NULL DEFAULT NULL COMMENT '发票类型：0->不开发票；1->电子发票；2->纸质发票',
|
||
`bill_header` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '发票抬头',
|
||
`bill_content` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '发票内容',
|
||
`bill_receiver_phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收票人电话',
|
||
`bill_receiver_email` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收票人邮箱',
|
||
`receiver_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
|
||
`receiver_phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人电话',
|
||
`receiver_post_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人邮编',
|
||
`receiver_province` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '省份/直辖市',
|
||
`receiver_city` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '城市',
|
||
`receiver_region` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '区',
|
||
`receiver_detail_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详细地址',
|
||
`note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单备注',
|
||
`confirm_status` int NULL DEFAULT NULL COMMENT '确认收货状态：0->未确认；1->已确认',
|
||
`delete_status` int NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
|
||
`use_integration` int NULL DEFAULT NULL COMMENT '下单时使用的积分',
|
||
`payment_time` datetime NULL DEFAULT NULL COMMENT '支付时间',
|
||
`delivery_time` datetime NULL DEFAULT NULL COMMENT '发货时间',
|
||
`receive_time` datetime NULL DEFAULT NULL COMMENT '确认收货时间',
|
||
`comment_time` datetime NULL DEFAULT NULL COMMENT '评价时间',
|
||
`modify_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
|
||
`settlement_status` int NULL DEFAULT 0 COMMENT '分销结算状态（0->未结算；1->已结算；2->不结算）',
|
||
`settlement_time` datetime NULL DEFAULT NULL COMMENT '分销结算时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order_item
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order_item`;
|
||
CREATE TABLE `oms_order_item` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`order_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单编号',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT ' 商品id',
|
||
`product_pic` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品图片',
|
||
`product_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`product_brand` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品品牌',
|
||
`product_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品货号',
|
||
`product_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '销售价格',
|
||
`product_quantity` int NULL DEFAULT NULL COMMENT '购买数量',
|
||
`product_sku_id` bigint NULL DEFAULT NULL COMMENT '商品sku编号',
|
||
`product_sku_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品sku条码',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类id',
|
||
`sp1` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品的销售属性1',
|
||
`sp2` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品的销售属性2',
|
||
`sp3` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品的销售属性3',
|
||
`promotion_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品促销名称',
|
||
`promotion_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品促销分解金额',
|
||
`coupon_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠券优惠分解金额',
|
||
`integration_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '积分优惠分解金额',
|
||
`real_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '该商品经过优惠后的分解金额',
|
||
`gift_integration` int NULL DEFAULT 0 COMMENT '赠送积分',
|
||
`gift_growth` int NULL DEFAULT 0 COMMENT '赠送成长值',
|
||
`product_attr` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品销售属性:[{\"key\":\"颜色\",\"value\":\"颜色\"},{\"key\":\"容量\",\"value\":\"4G\"}]',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单中所包含的商品' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order_item
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order_operate_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order_operate_history`;
|
||
CREATE TABLE `oms_order_operate_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`operate_man` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作人：用户；系统；后台管理员',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
|
||
`order_status` int NULL DEFAULT NULL COMMENT '订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单',
|
||
`note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单操作历史记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order_operate_history
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order_return_apply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order_return_apply`;
|
||
CREATE TABLE `oms_order_return_apply` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`company_address_id` bigint NULL DEFAULT NULL COMMENT '收货地址表id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '退货商品id',
|
||
`order_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单编号',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '申请时间',
|
||
`member_username` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员用户名',
|
||
`return_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '退款金额',
|
||
`return_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '退货人姓名',
|
||
`return_phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '退货人电话',
|
||
`status` int NULL DEFAULT NULL COMMENT '申请状态：0->待处理；1->退货中；2->已完成；3->已拒绝',
|
||
`handle_time` datetime NULL DEFAULT NULL COMMENT '处理时间',
|
||
`product_pic` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品图片',
|
||
`product_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`product_brand` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品品牌',
|
||
`product_attr` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品销售属性：颜色：红色；尺码：xl;',
|
||
`product_count` int NULL DEFAULT NULL COMMENT '退货数量',
|
||
`product_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品单价',
|
||
`product_real_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品实际支付单价',
|
||
`reason` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原因',
|
||
`description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
|
||
`proof_pics` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '凭证图片，以逗号隔开',
|
||
`handle_note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '处理备注',
|
||
`handle_man` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '处理人员',
|
||
`receive_man` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人',
|
||
`receive_time` datetime NULL DEFAULT NULL COMMENT '收货时间',
|
||
`receive_note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货备注',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单退货申请' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order_return_apply
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order_return_reason
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order_return_reason`;
|
||
CREATE TABLE `oms_order_return_reason` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '退货类型',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`status` int NULL DEFAULT NULL COMMENT '状态：0->不启用；1->启用',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '退货原因表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order_return_reason
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for oms_order_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `oms_order_setting`;
|
||
CREATE TABLE `oms_order_setting` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`flash_order_overtime` int NULL DEFAULT NULL COMMENT '秒杀订单超时关闭时间(分)',
|
||
`normal_order_overtime` int NULL DEFAULT NULL COMMENT '正常订单超时时间(分)',
|
||
`confirm_overtime` int NULL DEFAULT NULL COMMENT '发货后自动确认收货时间（天）',
|
||
`finish_overtime` int NULL DEFAULT NULL COMMENT '自动完成交易时间，不能申请售后（天）',
|
||
`comment_overtime` int NULL DEFAULT NULL COMMENT '订单完成后自动好评时间（天）',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单设置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of oms_order_setting
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_album
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_album`;
|
||
CREATE TABLE `pms_album` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相册名称',
|
||
`cover_pic` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '封面图片',
|
||
`pic_count` int NULL DEFAULT NULL COMMENT '图片数量',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`description` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相册表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_album
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_album_pic
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_album_pic`;
|
||
CREATE TABLE `pms_album_pic` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`album_id` bigint NULL DEFAULT NULL COMMENT '相册id',
|
||
`pic` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '画册图片表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_album_pic
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_brand
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_brand`;
|
||
CREATE TABLE `pms_brand` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌名称',
|
||
`first_letter` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '首字母',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序号',
|
||
`factory_status` int NULL DEFAULT NULL COMMENT '是否为品牌制造商：0->不是；1->是',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态',
|
||
`product_count` int NULL DEFAULT NULL COMMENT '产品数量',
|
||
`product_comment_count` int NULL DEFAULT NULL COMMENT '产品评论数量',
|
||
`logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌logo',
|
||
`big_pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专区大图',
|
||
`brand_story` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '品牌故事',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '品牌表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_brand
|
||
-- ----------------------------
|
||
INSERT INTO `pms_brand` VALUES (60, 'san', 's', 1, 1, 1, NULL, NULL, '', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_comment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_comment`;
|
||
CREATE TABLE `pms_comment` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`member_nick_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
|
||
`product_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`star` int NULL DEFAULT NULL COMMENT '评价星数：0->5',
|
||
`member_ip` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '评价会员的ip',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '评价时间',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态',
|
||
`product_attribute` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '购买时的商品属性',
|
||
`collect_couont` int NULL DEFAULT NULL COMMENT '收藏总数',
|
||
`read_count` int NULL DEFAULT NULL COMMENT '阅读数量',
|
||
`content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '评价内容',
|
||
`pics` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '上传图片地址，以逗号隔开',
|
||
`member_icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '评论用户头像',
|
||
`replay_count` int NOT NULL COMMENT '回复数量',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品评价表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_comment
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_comment_replay
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_comment_replay`;
|
||
CREATE TABLE `pms_comment_replay` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`comment_id` bigint NULL DEFAULT NULL COMMENT '商品评价id',
|
||
`member_nick_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
|
||
`member_icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员头像',
|
||
`content` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '回复内容',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '回复时间',
|
||
`type` int NULL DEFAULT NULL COMMENT '评论人员类型；0->会员；1->管理员',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品评价回复表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_comment_replay
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_feight_template
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_feight_template`;
|
||
CREATE TABLE `pms_feight_template` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`charge_type` int NULL DEFAULT NULL COMMENT '计费类型:0->按重量；1->按件数',
|
||
`first_weight` decimal(10, 2) NULL DEFAULT NULL COMMENT '首重kg',
|
||
`first_fee` decimal(10, 2) NULL DEFAULT NULL COMMENT '首费（元）',
|
||
`continue_weight` decimal(10, 2) NULL DEFAULT NULL,
|
||
`continme_fee` decimal(10, 2) NULL DEFAULT NULL,
|
||
`dest` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '目的地（省、市）',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '运费模版' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_feight_template
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_member_price
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_member_price`;
|
||
CREATE TABLE `pms_member_price` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`member_level_id` bigint NULL DEFAULT NULL COMMENT '会员等级id',
|
||
`member_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '会员价格',
|
||
`member_level_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员等级名称',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 222 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品会员价格表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_member_price
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product`;
|
||
CREATE TABLE `pms_product` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`brand_id` bigint NULL DEFAULT NULL COMMENT '品牌id',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类id',
|
||
`feight_template_id` bigint NULL DEFAULT NULL COMMENT '运费模板id',
|
||
`product_attribute_category_id` bigint NULL DEFAULT NULL COMMENT '商品属性分类id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品名称',
|
||
`pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品图片',
|
||
`product_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '货号',
|
||
`delete_status` int NULL DEFAULT NULL COMMENT '删除状态：0->未删除；1->已删除',
|
||
`publish_status` int NULL DEFAULT NULL COMMENT '上架状态：0->下架；1->上架',
|
||
`new_status` int NULL DEFAULT NULL COMMENT '新品状态:0->不是新品；1->新品',
|
||
`recommand_status` int NULL DEFAULT NULL COMMENT '推荐状态；0->不推荐；1->推荐',
|
||
`verify_status` int NULL DEFAULT NULL COMMENT '审核状态：0->未审核；1->审核通过',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
`sale` int NULL DEFAULT NULL COMMENT '销量',
|
||
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
|
||
`promotion_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '促销价格',
|
||
`gift_growth` int NULL DEFAULT 0 COMMENT '赠送的成长值',
|
||
`gift_point` int NULL DEFAULT 0 COMMENT '赠送的积分',
|
||
`use_point_limit` int NULL DEFAULT NULL COMMENT '限制使用的积分数',
|
||
`sub_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '副标题',
|
||
`description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '商品描述',
|
||
`original_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '市场价',
|
||
`stock` int NULL DEFAULT NULL COMMENT '库存',
|
||
`low_stock` int NULL DEFAULT NULL COMMENT '库存预警值',
|
||
`unit` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '单位',
|
||
`weight` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品重量，默认为克',
|
||
`preview_status` int NULL DEFAULT NULL COMMENT '是否为预告商品：0->不是；1->是',
|
||
`service_ids` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '以逗号分割的产品服务：1->无忧退货；2->快速退款；3->免费包邮',
|
||
`keywords` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
||
`note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
||
`album_pics` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '画册图片，连产品图片限制为5张，以逗号分割',
|
||
`detail_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详细标题',
|
||
`detail_desc` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述',
|
||
`detail_html` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '产品详情网页内容',
|
||
`detail_mobile_html` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '移动端网页详情',
|
||
`promotion_start_time` datetime NULL DEFAULT NULL COMMENT '促销开始时间',
|
||
`promotion_end_time` datetime NULL DEFAULT NULL COMMENT '促销结束时间',
|
||
`promotion_per_limit` int NULL DEFAULT NULL COMMENT '活动限购数量',
|
||
`promotion_type` int NULL DEFAULT NULL COMMENT '促销类型：0->没有促销使用原价;1->使用促销价；2->使用会员价；3->使用阶梯价格；4->使用满减价格；5->限时购',
|
||
`brand_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌名称',
|
||
`product_category_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品分类名称',
|
||
`distribution_flag` int NULL DEFAULT 1 COMMENT '分销标志（0->不参与；1->参与）',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品信息' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product
|
||
-- ----------------------------
|
||
INSERT INTO `pms_product` VALUES (1, 60, 7, 0, 0, '银色星芒刺绣网纱底裤', 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180522/web.png', 'No86577', 1, 1, 1, 1, 1, 100, 0, 100.00, NULL, 0, 100, NULL, '111', '111', 120.00, 100, 20, '件', 1000.00, 0, NULL, '银色星芒刺绣网纱底裤', '银色星芒刺绣网纱底裤', NULL, '银色星芒刺绣网纱底裤', '银色星芒刺绣网纱底裤', '银色星芒刺绣网纱底裤', '银色星芒刺绣网纱底裤', NULL, NULL, NULL, 0, 'san', '外套', 1);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_attribute
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_attribute`;
|
||
CREATE TABLE `pms_product_attribute` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_attribute_category_id` bigint NULL DEFAULT NULL COMMENT '商品属性分类id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品属性名称',
|
||
`select_type` int NULL DEFAULT NULL COMMENT '属性选择类型：0->唯一；1->单选；2->多选',
|
||
`input_type` int NULL DEFAULT NULL COMMENT '属性录入方式：0->手工录入；1->从列表中选取',
|
||
`input_list` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '可选值列表，以逗号隔开',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序字段：最高的可以单独上传图片',
|
||
`filter_type` int NULL DEFAULT NULL COMMENT '分类筛选样式：1->普通；1->颜色',
|
||
`search_type` int NULL DEFAULT NULL COMMENT '检索类型；0->不需要进行检索；1->关键字检索；2->范围检索',
|
||
`related_status` int NULL DEFAULT NULL COMMENT '相同属性产品是否关联；0->不关联；1->关联',
|
||
`hand_add_status` int NULL DEFAULT NULL COMMENT '是否支持手动新增；0->不支持；1->支持',
|
||
`type` int NULL DEFAULT NULL COMMENT '属性的类型；0->商品规格；1->商品参数',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品属性参数表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_attribute
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_attribute_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_attribute_category`;
|
||
CREATE TABLE `pms_product_attribute_category` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '属性分类名称',
|
||
`attribute_count` int NULL DEFAULT 0 COMMENT '属性数量',
|
||
`param_count` int NULL DEFAULT 0 COMMENT '参数数量',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品属性分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_attribute_category
|
||
-- ----------------------------
|
||
INSERT INTO `pms_product_attribute_category` VALUES (11, '数码', 0, 0);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_attribute_value
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_attribute_value`;
|
||
CREATE TABLE `pms_product_attribute_value` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`product_attribute_id` bigint NULL DEFAULT NULL COMMENT '商品属性id',
|
||
`value` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手动添加规格或参数的值，参数单值，规格有多个时以逗号隔开',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 258 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '存储产品参数信息的表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_attribute_value
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_category`;
|
||
CREATE TABLE `pms_product_category` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT ' 主键id',
|
||
`parent_id` bigint NULL DEFAULT NULL COMMENT '上机分类的编号：0表示一级分类',
|
||
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分类名称',
|
||
`level` int NULL DEFAULT NULL COMMENT '分类级别：0->1级；1->2级',
|
||
`product_count` int NULL DEFAULT NULL COMMENT '产品数量',
|
||
`product_unit` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '产品单位',
|
||
`nav_status` int NULL DEFAULT NULL COMMENT '是否显示在导航栏：0->不显示；1->显示',
|
||
`show_status` int NULL DEFAULT NULL COMMENT '显示状态：0->不显示；1->显示',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序号',
|
||
`icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图标',
|
||
`keywords` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
|
||
`description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '描述',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品分类' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_category
|
||
-- ----------------------------
|
||
INSERT INTO `pms_product_category` VALUES (7, 1, '外套', 1, 100, '件', 1, 1, 0, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20190519/5ac4780cN6087feb5.jpg', '外套', '外套');
|
||
INSERT INTO `pms_product_category` VALUES (60, 0, '数码', 0, 0, '', 1, 1, 0, '', '', '');
|
||
INSERT INTO `pms_product_category` VALUES (61, 60, '电子产品', 1, 0, '', 1, 1, 0, '', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_category_attribute_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_category_attribute_relation`;
|
||
CREATE TABLE `pms_product_category_attribute_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类id',
|
||
`product_attribute_id` bigint NULL DEFAULT NULL COMMENT '商品属性id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品的分类和属性的关系表，用于设置分类筛选条件（只支持一级分类）' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_category_attribute_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_full_reduction
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_full_reduction`;
|
||
CREATE TABLE `pms_product_full_reduction` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`full_price` decimal(10, 2) NULL DEFAULT NULL,
|
||
`reduce_price` decimal(10, 2) NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 74 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品满减表(只针对同商品)' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_full_reduction
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_ladder
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_ladder`;
|
||
CREATE TABLE `pms_product_ladder` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`count` int NULL DEFAULT NULL COMMENT '满足的商品数量',
|
||
`discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣',
|
||
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '折后价格',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '产品阶梯价格表(只针对同商品)' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_ladder
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_operate_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_operate_log`;
|
||
CREATE TABLE `pms_product_operate_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`price_old` decimal(10, 2) NULL DEFAULT NULL COMMENT '旧价',
|
||
`price_new` decimal(10, 2) NULL DEFAULT NULL COMMENT '新价',
|
||
`sale_price_old` decimal(10, 2) NULL DEFAULT NULL,
|
||
`sale_price_new` decimal(10, 2) NULL DEFAULT NULL,
|
||
`gift_point_old` int NULL DEFAULT NULL COMMENT '赠送的积分',
|
||
`gift_point_new` int NULL DEFAULT NULL,
|
||
`use_point_limit_old` int NULL DEFAULT NULL,
|
||
`use_point_limit_new` int NULL DEFAULT NULL,
|
||
`operate_man` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作人',
|
||
`create_time` datetime NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_operate_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_product_vertify_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_product_vertify_record`;
|
||
CREATE TABLE `pms_product_vertify_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`vertify_man` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '审核人',
|
||
`status` int NULL DEFAULT NULL COMMENT '审核状态',
|
||
`detail` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '反馈详情',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品审核记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_product_vertify_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pms_sku_stock
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pms_sku_stock`;
|
||
CREATE TABLE `pms_sku_stock` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`sku_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'sku编码',
|
||
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
|
||
`stock` int NULL DEFAULT 0 COMMENT '库存',
|
||
`low_stock` int NULL DEFAULT NULL COMMENT '预警库存',
|
||
`sp1` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性1',
|
||
`sp2` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性2',
|
||
`sp3` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '销售属性3',
|
||
`pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '展示图片',
|
||
`sale` int NULL DEFAULT NULL COMMENT '销量',
|
||
`promotion_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '单品促销价格',
|
||
`lock_stock` int NULL DEFAULT 0 COMMENT '锁定库存',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 190 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'sku的库存' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of pms_sku_stock
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_coupon
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_coupon`;
|
||
CREATE TABLE `sms_coupon` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`type` int NULL DEFAULT NULL COMMENT '优惠卷类型；0->全场赠券；1->会员赠券；2->购物赠券；3->注册赠券',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '优惠卷名称',
|
||
`platform` int NULL DEFAULT NULL COMMENT '使用平台：0->全部；1->移动；2->PC',
|
||
`count` int NULL DEFAULT NULL COMMENT '数量',
|
||
`amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
|
||
`per_limit` int NULL DEFAULT NULL COMMENT '每人限领张数',
|
||
`min_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '使用门槛；0表示无门槛',
|
||
`start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
|
||
`use_type` int NULL DEFAULT NULL COMMENT '使用类型：0->全场通用；1->指定分类；2->指定商品',
|
||
`note` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`publish_count` int NULL DEFAULT NULL COMMENT '发行数量',
|
||
`use_count` int NULL DEFAULT NULL COMMENT '已使用数量',
|
||
`receive_count` int NULL DEFAULT NULL COMMENT '领取数量',
|
||
`enable_time` datetime NULL DEFAULT NULL COMMENT '可以领取的日期',
|
||
`code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '优惠码',
|
||
`member_level` int NULL DEFAULT NULL COMMENT '可领取的会员类型：0->无限时',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优惠卷表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_coupon
|
||
-- ----------------------------
|
||
INSERT INTO `sms_coupon` VALUES (22, 0, '121', 0, 11, 111.00, 1, 0.00, '2024-11-01 00:00:00', '2025-01-01 00:00:00', 0, NULL, 11, 0, 0, NULL, NULL, NULL);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_coupon_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_coupon_history`;
|
||
CREATE TABLE `sms_coupon_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`coupon_id` bigint NULL DEFAULT NULL COMMENT '优惠卷id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`coupon_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '优惠码',
|
||
`member_nickname` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '领取人昵称',
|
||
`get_type` int NULL DEFAULT NULL COMMENT '获取类型：0->后台赠送；1->主动获取',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`use_status` int NULL DEFAULT NULL COMMENT '使用状态：0->未使用；1->已使用；2->已过期',
|
||
`use_time` datetime NULL DEFAULT NULL COMMENT '使用时间',
|
||
`order_id` bigint NULL DEFAULT NULL COMMENT '订单编号',
|
||
`order_sn` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单号码',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_member_id`(`member_id` ASC) USING BTREE,
|
||
INDEX `idx_coupon_id`(`coupon_id` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优惠券使用、领取历史表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_coupon_history
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_coupon_product_category_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_coupon_product_category_relation`;
|
||
CREATE TABLE `sms_coupon_product_category_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`coupon_id` bigint NULL DEFAULT NULL COMMENT '优惠卷id',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类id',
|
||
`product_category_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '产品分类名称',
|
||
`parent_category_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '父分类名称',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优惠券和产品分类关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_coupon_product_category_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_coupon_product_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_coupon_product_relation`;
|
||
CREATE TABLE `sms_coupon_product_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`coupon_id` bigint NULL DEFAULT NULL COMMENT '优惠卷id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`product_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`product_sn` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品编码',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '优惠券和产品的关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_coupon_product_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_flash_promotion
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_flash_promotion`;
|
||
CREATE TABLE `sms_flash_promotion` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`start_date` date NULL DEFAULT NULL COMMENT '开始日期',
|
||
`end_date` date NULL DEFAULT NULL COMMENT '结束日期',
|
||
`status` int NULL DEFAULT NULL COMMENT '上下线状态',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '秒杀时间段名称',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '限时购表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_flash_promotion
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_flash_promotion_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_flash_promotion_log`;
|
||
CREATE TABLE `sms_flash_promotion_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` int NULL DEFAULT NULL COMMENT '会员id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`member_phone` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员电话',
|
||
`product_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`subscribe_time` datetime NULL DEFAULT NULL COMMENT '会员订阅时间',
|
||
`send_time` datetime NULL DEFAULT NULL COMMENT '通知时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '限时购通知记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_flash_promotion_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_flash_promotion_product_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_flash_promotion_product_relation`;
|
||
CREATE TABLE `sms_flash_promotion_product_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`flash_promotion_id` bigint NULL DEFAULT NULL COMMENT '限时购id',
|
||
`flash_promotion_session_id` bigint NULL DEFAULT NULL COMMENT '编号',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`flash_promotion_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '限时购价格',
|
||
`flash_promotion_count` int NULL DEFAULT NULL COMMENT '限时购数量',
|
||
`flash_promotion_limit` int NULL DEFAULT NULL COMMENT '每人限购数量',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品限时购与商品关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_flash_promotion_product_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_flash_promotion_session
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_flash_promotion_session`;
|
||
CREATE TABLE `sms_flash_promotion_session` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
|
||
`name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场次名称',
|
||
`start_time` time NULL DEFAULT NULL COMMENT '每日开始时间',
|
||
`end_time` time NULL DEFAULT NULL COMMENT '每日结束时间',
|
||
`status` int NULL DEFAULT NULL COMMENT '启用状态：0->不启用；1->启用',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '限时购场次表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_flash_promotion_session
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_home_advertise
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_home_advertise`;
|
||
CREATE TABLE `sms_home_advertise` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`type` int NULL DEFAULT NULL COMMENT '轮播位置：0->PC首页轮播；1->app首页轮播',
|
||
`pic` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
|
||
`start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
|
||
`status` int NULL DEFAULT NULL COMMENT '上下线状态：0->下线；1->上线',
|
||
`click_count` int NULL DEFAULT NULL COMMENT '点击数',
|
||
`order_count` int NULL DEFAULT NULL COMMENT '下单数',
|
||
`url` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '链接地址',
|
||
`detail_desc` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述',
|
||
`note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序',
|
||
`background_color` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片背景色',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '首页轮播广告表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_home_advertise
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_home_brand
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_home_brand`;
|
||
CREATE TABLE `sms_home_brand` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`brand_id` bigint NULL DEFAULT NULL COMMENT '品牌id',
|
||
`brand_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌名称',
|
||
`recommend_status` int NULL DEFAULT NULL COMMENT '推荐状态（0->未推荐；1->已推荐）',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '首页推荐品牌表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_home_brand
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_home_new_product
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_home_new_product`;
|
||
CREATE TABLE `sms_home_new_product` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`product_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`recommend_status` int NULL DEFAULT NULL COMMENT '推荐状态（0->未推荐；1->已推荐）',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '新鲜好物表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_home_new_product
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_home_recommend_product
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_home_recommend_product`;
|
||
CREATE TABLE `sms_home_recommend_product` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`product_id` bigint NULL DEFAULT NULL COMMENT '商品id',
|
||
`product_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
|
||
`recommend_status` int NULL DEFAULT NULL COMMENT '推荐状态（0->未推荐；1->已推荐）',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '人气推荐商品表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_home_recommend_product
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sms_home_recommend_subject
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sms_home_recommend_subject`;
|
||
CREATE TABLE `sms_home_recommend_subject` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`subject_id` bigint NULL DEFAULT NULL COMMENT '专题id',
|
||
`subject_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '专题名称',
|
||
`recommend_status` int NULL DEFAULT NULL COMMENT '推荐状态（0->未推荐；1->已推荐）',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '首页推荐专题表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of sms_home_recommend_subject
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_admin`;
|
||
CREATE TABLE `ums_admin` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`username` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
|
||
`password` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
|
||
`email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
|
||
`nick_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '昵称',
|
||
`note` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注信息',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`login_time` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
|
||
`status` int NULL DEFAULT 1 COMMENT '帐号启用状态：0->禁用；1->启用',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_admin
|
||
-- ----------------------------
|
||
INSERT INTO `ums_admin` VALUES (4, 'aa', '$2a$10$T.AODb7ug.hGq7LKxkX/P.Y4WV0jHJxgwH0l5TJuO3f4uqMtq0.YG', 'aa', 'aa', 'aa', 'aa', '2024-12-01 17:44:04', NULL, 1);
|
||
INSERT INTO `ums_admin` VALUES (5, 'aaaaaa', '$2a$10$7qAVzktdXYJfXZZl4nKf8.pU5ydtdVL2smj7y1fMlct2Qw1/z12oK', 'aa', 'aa', 'aaaaaa', 'aaaaaa', '2024-12-01 17:47:12', NULL, 1);
|
||
INSERT INTO `ums_admin` VALUES (6, 'admin', '$2a$10$VGaxpzulf8Vt1p35dQA.mOcLxbLXPNGKcgL40/cfMrLiiX.WnqNqy', 'aa', 'aa', 'aaaaaa', 'aaaaaa', '2024-12-01 17:50:26', NULL, 1);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_admin_login_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_admin_login_log`;
|
||
CREATE TABLE `ums_admin_login_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`admin_id` bigint NULL DEFAULT NULL COMMENT '管理员用户id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`ip` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '登录ip',
|
||
`address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '登录地址',
|
||
`user_agent` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '浏览器登录类型',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 115 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户登录日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_admin_login_log
|
||
-- ----------------------------
|
||
INSERT INTO `ums_admin_login_log` VALUES (111, 6, '2024-12-01 17:50:58', '0:0:0:0:0:0:0:1', NULL, NULL);
|
||
INSERT INTO `ums_admin_login_log` VALUES (112, 6, '2024-12-02 11:07:34', '0:0:0:0:0:0:0:1', NULL, NULL);
|
||
INSERT INTO `ums_admin_login_log` VALUES (113, 6, '2024-12-02 11:21:59', '0:0:0:0:0:0:0:1', NULL, NULL);
|
||
INSERT INTO `ums_admin_login_log` VALUES (114, 6, '2024-12-02 13:05:32', '127.0.0.1', NULL, NULL);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_admin_permission_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_admin_permission_relation`;
|
||
CREATE TABLE `ums_admin_permission_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`admin_id` bigint NULL DEFAULT NULL COMMENT '管理员id',
|
||
`permission_id` bigint NULL DEFAULT NULL COMMENT '权限id',
|
||
`type` int NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户和权限关系表(除角色中定义的权限以外的加减权限)' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_admin_permission_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_admin_role_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_admin_role_relation`;
|
||
CREATE TABLE `ums_admin_role_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`admin_id` bigint NULL DEFAULT NULL COMMENT '管理员id',
|
||
`role_id` bigint NULL DEFAULT NULL COMMENT '角色id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户和角色关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_admin_role_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_area
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_area`;
|
||
CREATE TABLE `ums_area` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
|
||
`area_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '地区编码',
|
||
`area_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '地区名',
|
||
`level` int NULL DEFAULT -1 COMMENT '地区级别（1:省份province,2:市city,3:区县district,4:街道street）',
|
||
`city_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '城市编码',
|
||
`center` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '城市中心点（即：经纬度坐标）',
|
||
`parent_id` int NULL DEFAULT -1 COMMENT '地区父节点（-1表示没有上级）',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `areaCode`(`area_code` ASC) USING BTREE,
|
||
INDEX `parentId`(`parent_id` ASC) USING BTREE,
|
||
INDEX `level`(`level` ASC) USING BTREE,
|
||
INDEX `areaName`(`area_name` ASC) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '地区码表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_area
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_growth_change_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_growth_change_history`;
|
||
CREATE TABLE `ums_growth_change_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`change_type` int NULL DEFAULT NULL COMMENT '改变类型：0->增加；1->减少',
|
||
`change_count` int NULL DEFAULT NULL COMMENT '积分改变数量',
|
||
`operate_man` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作人员',
|
||
`operate_note` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作备注',
|
||
`source_type` int NULL DEFAULT NULL COMMENT '积分来源：0->购物；1->管理员修改',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '成长值变化历史记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_growth_change_history
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_integration_change_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_integration_change_history`;
|
||
CREATE TABLE `ums_integration_change_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`change_type` int NULL DEFAULT NULL COMMENT '改变类型：0->增加；1->减少',
|
||
`change_count` int NULL DEFAULT NULL COMMENT '积分改变数量',
|
||
`operate_man` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作人员',
|
||
`operate_note` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作备注',
|
||
`source_type` int NULL DEFAULT NULL COMMENT '积分来源：0->购物；1->管理员修改',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '积分变化历史记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_integration_change_history
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_integration_consume_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_integration_consume_setting`;
|
||
CREATE TABLE `ums_integration_consume_setting` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`deduction_per_amount` int NULL DEFAULT NULL COMMENT '每一元需要抵扣的积分数量',
|
||
`max_percent_per_order` int NULL DEFAULT NULL COMMENT '每笔订单最高抵用百分比',
|
||
`use_unit` int NULL DEFAULT NULL COMMENT '每次使用积分最小单位100',
|
||
`coupon_status` int NULL DEFAULT NULL COMMENT '是否可以和优惠券同用；0->不可以；1->可以',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '积分消费设置' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_integration_consume_setting
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member`;
|
||
CREATE TABLE `ums_member` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_level_id` bigint NULL DEFAULT 0 COMMENT '会员等级id',
|
||
`member_level` int NULL DEFAULT 0 COMMENT '分销会员等级（0->普通用户；1->vip会员；2->店长；3->代理；4->市代；5->中级合作商；6->高级合作商；7->特级合作商））',
|
||
`username` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
|
||
`password` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
||
`phone` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机号码',
|
||
`status` int NULL DEFAULT NULL COMMENT '帐号启用状态:0->禁用；1->启用',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '注册时间',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
|
||
`gender` int NULL DEFAULT NULL COMMENT '性别：0->未知；1->男；2->女',
|
||
`birthday` date NULL DEFAULT NULL COMMENT '生日',
|
||
`city` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所在城市',
|
||
`job` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业',
|
||
`personalized_signature` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '个性签名',
|
||
`source_type` int NULL DEFAULT 1 COMMENT '用户来源=>1:线上，2:线下',
|
||
`integration` int NULL DEFAULT NULL COMMENT '积分',
|
||
`growth` int NULL DEFAULT NULL COMMENT '成长值',
|
||
`luckey_count` int NULL DEFAULT NULL COMMENT '剩余抽奖次数',
|
||
`history_integration` int NULL DEFAULT NULL COMMENT '历史积分数量',
|
||
`invitation_code` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '12位邀请码',
|
||
`store_status` int NULL DEFAULT 0 COMMENT '分销实体店状态（0->未开店；1->已开店）',
|
||
`balance` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '余额',
|
||
`freeze` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '冻结余额',
|
||
`order_status` int NULL DEFAULT 0 COMMENT '排队状态:0->未排队；1->排队中',
|
||
`detail_address` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详细地址',
|
||
`real_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `idx_username`(`username` ASC) USING BTREE,
|
||
UNIQUE INDEX `idx_invitation_code`(`invitation_code` ASC) USING BTREE,
|
||
UNIQUE INDEX `idx_phone`(`phone` ASC) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member
|
||
-- ----------------------------
|
||
INSERT INTO `ums_member` VALUES (14, 1, 0, '15198261111', '$2a$10$m5712WC.dwOqYzZGniPjr.m5Lui634h4xSpzQ8wNcmZgDwWbk6vmi', NULL, '15198261111', 1, '2024-11-25 12:02:52', NULL, 0, NULL, NULL, NULL, NULL, 1, 0, 0, NULL, NULL, '123456789012345', 0, 0.00, 0.00, 0, NULL, NULL);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_account_transaction
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_account_transaction`;
|
||
CREATE TABLE `ums_member_account_transaction` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT 0 COMMENT '会员id',
|
||
`order_id` bigint NULL DEFAULT 0 COMMENT '订单id',
|
||
`revenue_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '进帐金额',
|
||
`transaction_state` int NULL DEFAULT 0 COMMENT '转账状态 0 未转账，1 转账， 2 退款',
|
||
`remarks` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`commission_ratio` int NULL DEFAULT 0 COMMENT '提成比例',
|
||
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`transfer_payment_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '转账时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员账户流水' ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_account_transaction
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_level
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_level`;
|
||
CREATE TABLE `ums_member_level` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '会员名称',
|
||
`growth_point` int NULL DEFAULT NULL COMMENT '会员等级升级点',
|
||
`default_status` int NULL DEFAULT NULL COMMENT '0->线上会员；1->线下会员',
|
||
`free_freight_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '免运费标准',
|
||
`comment_growth_point` int NULL DEFAULT NULL COMMENT '每次评价获取的成长值',
|
||
`priviledge_free_freight` int NULL DEFAULT NULL COMMENT '是否有免邮特权',
|
||
`priviledge_sign_in` int NULL DEFAULT NULL COMMENT '是否有签到特权',
|
||
`priviledge_comment` int NULL DEFAULT NULL COMMENT '是否有评论获奖励特权',
|
||
`priviledge_promotion` int NULL DEFAULT NULL COMMENT '是否有专享活动特权',
|
||
`priviledge_member_price` int NULL DEFAULT NULL COMMENT '是否有会员价格特权',
|
||
`priviledge_birthday` int NULL DEFAULT NULL COMMENT '是否有生日特权',
|
||
`note` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '注释',
|
||
`commission_ratio` int NULL DEFAULT 0 COMMENT '提成比例',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员等级表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_level
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_login_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_login_log`;
|
||
CREATE TABLE `ums_member_login_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`ip` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
|
||
`city` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '登录城市',
|
||
`login_type` int NULL DEFAULT NULL COMMENT '登录类型：0->PC；1->android;2->ios;3->小程序',
|
||
`province` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '省份',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员登录记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_login_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_member_tag_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_member_tag_relation`;
|
||
CREATE TABLE `ums_member_member_tag_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`tag_id` bigint NULL DEFAULT NULL COMMENT '标签id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户和标签关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_member_tag_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_order_queue
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_order_queue`;
|
||
CREATE TABLE `ums_member_order_queue` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT 0 COMMENT '会员id',
|
||
`order_id` bigint NULL DEFAULT 0 COMMENT '订单id',
|
||
`order_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '订单金额',
|
||
`queue_index` bigint NULL DEFAULT 0 COMMENT '队列位置',
|
||
`quit_queue_mark` int NULL DEFAULT 0 COMMENT '0 未退出，1 退出队列',
|
||
`queue_type` int NULL DEFAULT 0 COMMENT '0 普通队列，1 加速队列',
|
||
`accelerate_switch` int NULL DEFAULT 0 COMMENT '加速开关：0 未被加速，1 已帮助加速',
|
||
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员订单队列' ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_order_queue
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_product_category_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_product_category_relation`;
|
||
CREATE TABLE `ums_member_product_category_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`product_category_id` bigint NULL DEFAULT NULL COMMENT '商品分类id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员与产品分类关系表（用户喜欢的分类）' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_product_category_relation
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_receive_address
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_receive_address`;
|
||
CREATE TABLE `ums_member_receive_address` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人名称',
|
||
`phone_number` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机号码',
|
||
`default_status` int NULL DEFAULT NULL COMMENT '是否为默认',
|
||
`post_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮政编码',
|
||
`area_id` int NULL DEFAULT NULL COMMENT '地区码表id',
|
||
`province` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '省份/直辖市',
|
||
`city` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '城市',
|
||
`region` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '区',
|
||
`detail_address` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '详细地址(街道)',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员收货地址表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_receive_address
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_relation_tree
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_relation_tree`;
|
||
CREATE TABLE `ums_member_relation_tree` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT 0 COMMENT '会员id',
|
||
`higher_level_id` bigint NULL DEFAULT 0 COMMENT '上级会员id',
|
||
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员关系树' ROW_FORMAT = DYNAMIC;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_relation_tree
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_rule_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_rule_setting`;
|
||
CREATE TABLE `ums_member_rule_setting` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`continue_sign_day` int NULL DEFAULT NULL COMMENT '连续签到天数',
|
||
`continue_sign_point` int NULL DEFAULT NULL COMMENT '连续签到赠送数量',
|
||
`consume_per_point` decimal(10, 2) NULL DEFAULT NULL COMMENT '每消费多少元获取1个点',
|
||
`low_order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '最低获取点数的订单金额',
|
||
`max_point_per_order` int NULL DEFAULT NULL COMMENT '每笔订单最高获取点数',
|
||
`type` int NULL DEFAULT NULL COMMENT '类型：0->积分规则；1->成长值规则',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员积分成长规则表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_rule_setting
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_statistics_info
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_statistics_info`;
|
||
CREATE TABLE `ums_member_statistics_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
||
`consume_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '累计消费金额',
|
||
`order_count` int NULL DEFAULT NULL COMMENT '订单数量',
|
||
`coupon_count` int NULL DEFAULT NULL COMMENT '优惠券数量',
|
||
`comment_count` int NULL DEFAULT NULL COMMENT '评价数',
|
||
`return_order_count` int NULL DEFAULT NULL COMMENT '退货数量',
|
||
`login_count` int NULL DEFAULT NULL COMMENT '登录次数',
|
||
`attend_count` int NULL DEFAULT NULL COMMENT '关注数量',
|
||
`fans_count` int NULL DEFAULT NULL COMMENT '粉丝数量',
|
||
`collect_product_count` int NULL DEFAULT NULL COMMENT '收藏商品数量',
|
||
`collect_subject_count` int NULL DEFAULT NULL COMMENT '收藏专题数量',
|
||
`collect_topic_count` int NULL DEFAULT NULL COMMENT '收藏话题数量',
|
||
`collect_comment_count` int NULL DEFAULT NULL COMMENT '收藏评论数量',
|
||
`invite_friend_count` int NULL DEFAULT NULL COMMENT '邀请朋友数量',
|
||
`recent_order_time` datetime NULL DEFAULT NULL COMMENT '最后一次下订单时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员统计信息' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_statistics_info
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_tag
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_tag`;
|
||
CREATE TABLE `ums_member_tag` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '标签名称',
|
||
`finish_order_count` int NULL DEFAULT NULL COMMENT '自动打标签完成订单数量',
|
||
`finish_order_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '自动打标签完成订单金额',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户标签表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_tag
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_member_task
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_member_task`;
|
||
CREATE TABLE `ums_member_task` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '任务名称',
|
||
`growth` int NULL DEFAULT NULL COMMENT '赠送成长值',
|
||
`intergration` int NULL DEFAULT NULL COMMENT '赠送积分',
|
||
`type` int NULL DEFAULT NULL COMMENT '任务类型：0->新手任务；1->日常任务',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '会员任务表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_member_task
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_permission
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_permission`;
|
||
CREATE TABLE `ums_permission` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`pid` bigint NULL DEFAULT NULL COMMENT '父级权限id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`value` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '权限值',
|
||
`icon` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图标',
|
||
`type` int NULL DEFAULT NULL COMMENT '权限类型：0->目录；1->菜单；2->按钮（接口绑定权限）',
|
||
`uri` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '前端资源路径',
|
||
`status` int NULL DEFAULT NULL COMMENT '启用状态；0->禁用；1->启用',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`sort` int NULL DEFAULT NULL COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户权限表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_permission
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_role`;
|
||
CREATE TABLE `ums_role` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
|
||
`admin_count` int NULL DEFAULT NULL COMMENT '后台用户数量',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`status` int NULL DEFAULT 1 COMMENT '启用状态：0->禁用；1->启用',
|
||
`sort` int NULL DEFAULT 0 COMMENT '排序号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户角色表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_role
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ums_role_permission_relation
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ums_role_permission_relation`;
|
||
CREATE TABLE `ums_role_permission_relation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`role_id` bigint NULL DEFAULT NULL COMMENT '角色id',
|
||
`permission_id` bigint NULL DEFAULT NULL COMMENT '权限id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '后台用户角色和权限关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ums_role_permission_relation
|
||
-- ----------------------------
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|