/* 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;