如花商城系统thinkphp6+uniapp,小程序直播拼团限时分销APP商城.zip

/* Navicat Premium Data Transfer Source Server : XamppSQl Source Server Type : MariaDB Source Server Version : 100414 Source Host : localhost:3306 Source Schema : ruhuasql Target Server Type : MariaDB Target Server Version : 100414 File Encoding : 65001 Date: 16/01/2021 10:50:55 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for rh_admin -- ---------------------------- DROP TABLE IF EXISTS `rh_admin`; CREATE TABLE `rh_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名', `password` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `group_id` tinyint(4) NOT NULL COMMENT '管理组ID', `ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `state` int(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `login_time` int(11) NOT NULL DEFAULT 0, `create_time` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_article -- ---------------------------- DROP TABLE IF EXISTS `rh_article`; CREATE TABLE `rh_article` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章编号', `type` int(11) NOT NULL COMMENT '0活动公告，1独立文章，3公告', `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题', `summary` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文章摘要', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章正文', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文章标题图片', `is_hidden` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示 1 显示 0 不显示', `author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布者用户名 ', `create_time` int(11) NULL DEFAULT 0 COMMENT '文章发布时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 6553 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'CMS文章表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_bank_card -- ---------------------------- DROP TABLE IF EXISTS `rh_bank_card`; CREATE TABLE `rh_bank_card` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id', `bk_uname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户主名', `bk_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行名称', `type` int(11) NOT NULL DEFAULT 0 COMMENT '类型0用户卡1商家卡', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, `card` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '卡号', `card_type` int(11) NOT NULL DEFAULT 0 COMMENT '0其他1人民银行2农业银行3工商银行3建设银行', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '银行卡表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_banner -- ---------------------------- DROP TABLE IF EXISTS `rh_banner`; CREATE TABLE `rh_banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Banner名称，通常作为标识', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Banner描述', `delete_time` int(11) NULL DEFAULT NULL, `update_time` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'banner管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of rh_banner -- ---------------------------- INSERT INTO `rh_banner` VALUES (1, 'index_banner', '首页banner位', NULL, NULL); -- ---------------------------- -- Table structure for rh_banner_item -- ---------------------------- DROP TABLE IF EXISTS `rh_banner_item`; CREATE TABLE `rh_banner_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `img_id` int(11) NOT NULL COMMENT '外键，关联image表', `key_word` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行关键字，根据不同的type含义不同', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '跳转类型', `jump_id` int(11) NOT NULL DEFAULT 0, `delete_time` int(11) NULL DEFAULT NULL, `banner_id` int(11) NOT NULL COMMENT '外键，关联banner表', `is_visible` int(11) NOT NULL DEFAULT 1 COMMENT '是否显示 1 显示 0 不显示', `sort` int(11) NULL DEFAULT NULL, `update_time` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'banner子项表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_category -- ---------------------------- DROP TABLE IF EXISTS `rh_category`; CREATE TABLE `rh_category` ( `category_id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称', `short_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品分类简称 ', `pid` int(11) NOT NULL DEFAULT 0, `level` tinyint(4) NOT NULL DEFAULT 0, `is_visible` int(11) NOT NULL DEFAULT 1 COMMENT '是否显示 1 显示 0 不显示', `sort` int(11) NULL DEFAULT NULL, `category_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品分类图片', PRIMARY KEY (`category_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 244 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_company -- ---------------------------- DROP TABLE IF EXISTS `rh_company`; CREATE TABLE `rh_company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位名称', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位地址', `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位负责人', `mobile` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话', `money` float NOT NULL DEFAULT 0 COMMENT '账户余额', `create_time` int(11) NULL DEFAULT NULL, `update_time` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '单位绑定表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for rh_coupon -- ---------------------------- DROP TABLE IF EXISTS `rh_coupon`; CREATE TABLE `rh_coupon` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL DEFAULT 3 COMMENT '类型1:店铺优惠券', `shop_id` int(11) NOT NULL DEFAULT 0 COMMENT '店铺ID', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券名称', `goods_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '可用商品ID集合，0为�