登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 3 Fork 3

cino/花市集小程序

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
flower.sql 25.15 KB
一键复制 编辑 原始数据 按行查看 历史
cino 提交于 2024-01-09 11:05 . 第一个上传的项目(完整上传的)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343
/*

 Navicat Premium Data Transfer



 Source Server         : test1

 Source Server Type    : MySQL

 Source Server Version : 80030

 Source Host           : 127.0.0.1:3306

 Source Schema         : flower



 Target Server Type    : MySQL

 Target Server Version : 80030

 File Encoding         : 65001



 Date: 01/01/2024 15:28:48

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for address

-- ----------------------------

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '收货地址',

  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '收货人',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '收货地址表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of address

-- ----------------------------

INSERT INTO `address` VALUES (11, '广州市 天河区', '刘德华', '888999', 6);

INSERT INTO `address` VALUES (13, '广工校门口', '张某', '999', 10);

INSERT INTO `address` VALUES (14, '广州', '梁朝伟', '111', 6);



-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',

  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色标识',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',

  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES (1, 'admin', 'admin', '管理员', 'http://localhost:9090/files/1697438073596-avatar.png', 'ADMIN', '13677889922', 'admin@xm.com');



-- ----------------------------

-- Table structure for banner

-- ----------------------------

DROP TABLE IF EXISTS `banner`;

CREATE TABLE `banner`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片',

  `business_id` int NULL DEFAULT NULL COMMENT '商家ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '广告表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of banner

-- ----------------------------



-- ----------------------------

-- Table structure for business

-- ----------------------------

DROP TABLE IF EXISTS `business`;

CREATE TABLE `business`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',

  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账号',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'logo',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',

  `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简介',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址',

  `license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '营业执照',

  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '待审核' COMMENT '审核状态',

  `time_range` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '营业时间',

  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '类型',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商家表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of business

-- ----------------------------

INSERT INTO `business` VALUES (19, 'flower', '123', '一家鲜花店', 'http://localhost:9090/files/1702086242609-flower.jpg', 'BUSINESS', '111-111-111', '这是一家专门卖鲜花的外卖店！', '广东省广州市番禺区小谷围街广州大学城外环西路100号', NULL, '通过', '6:00-24:00', '鲜花花束');

INSERT INTO `business` VALUES (20, 'green', '123', '一家绿植店', 'http://localhost:9090/files/1702035096797-green1.jpg', 'BUSINESS', '222-222-222', '这是一家专门做绿植外卖的店', '广东省广州市番禺区小谷围街广州大学城外环西路101号', NULL, '通过', '6:00-24:00', '盆栽绿植');

INSERT INTO `business` VALUES (21, 'pan', '123', '一家花盆店', 'http://localhost:9090/files/1702035213178-pan1.jpg', 'BUSINESS', '333-333-333', '这是一家专门卖花盆花瓶的外卖店', '广东省广州市番禺区小谷围街广州大学城外环西路103号', NULL, '通过', '6：00-24：00', '花瓶花盆');

INSERT INTO `business` VALUES (22, 'jifen', '123', '积分中心', NULL, 'BUSINESS', NULL, NULL, NULL, NULL, '通过', NULL, '积分中心');

INSERT INTO `business` VALUES (24, '666', '123', '漂亮鲜花', NULL, 'BUSINESS', NULL, NULL, NULL, NULL, '通过', NULL, '鲜花花束');



-- ----------------------------

-- Table structure for cart

-- ----------------------------

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `goods_id` int NULL DEFAULT NULL COMMENT '商品ID',

  `num` int NULL DEFAULT NULL COMMENT '数量',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  `business_id` int NULL DEFAULT NULL COMMENT '商家ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 88 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '购物车' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of cart

-- ----------------------------



-- ----------------------------

-- Table structure for category

-- ----------------------------

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category`  (

  `id` int NOT NULL AUTO_INCREMENT,

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  `business_id` int NULL DEFAULT NULL COMMENT '商家ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商品分类' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of category

-- ----------------------------

INSERT INTO `category` VALUES (12, '玫瑰花束', 19);

INSERT INTO `category` VALUES (13, '单只鲜花', 19);

INSERT INTO `category` VALUES (14, '家用绿植', 20);

INSERT INTO `category` VALUES (15, '商用绿植', 20);

INSERT INTO `category` VALUES (16, '塑料花盆', 21);

INSERT INTO `category` VALUES (17, '陶瓷花盆', 21);

INSERT INTO `category` VALUES (20, '花盆', 22);

INSERT INTO `category` VALUES (21, '种子', 22);



-- ----------------------------

-- Table structure for collect

-- ----------------------------

DROP TABLE IF EXISTS `collect`;

CREATE TABLE `collect`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `business_id` int NULL DEFAULT NULL COMMENT '商家ID',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '收藏时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户收藏' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of collect

-- ----------------------------

INSERT INTO `collect` VALUES (24, 19, 10, '2023-12-23 00:03:09');



-- ----------------------------

-- Table structure for comment

-- ----------------------------

DROP TABLE IF EXISTS `comment`;

CREATE TABLE `comment`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论',

  `star` double(10, 1) NULL DEFAULT 0.0 COMMENT '评分',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  `business_id` int NULL DEFAULT NULL COMMENT '商家iD',

  `order_id` int NULL DEFAULT NULL COMMENT '订单ID',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '时间',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `user_id`(`user_id` ASC, `order_id` ASC) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '评价表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of comment

-- ----------------------------

INSERT INTO `comment` VALUES (9, 'nice!', 5.0, 6, 19, 37, '2023-12-22 23:04:40');

INSERT INTO `comment` VALUES (10, '太赞啦！', 5.0, 6, 19, 38, '2023-12-22 23:04:47');

INSERT INTO `comment` VALUES (11, 'good', 5.0, 6, 19, 39, '2023-12-22 23:04:54');

INSERT INTO `comment` VALUES (12, '！', 5.0, 6, 19, 40, '2023-12-22 23:04:58');

INSERT INTO `comment` VALUES (13, '赞', 5.0, 10, 19, 58, '2023-12-23 00:31:22');

INSERT INTO `comment` VALUES (14, 'nice!', 5.0, 6, 19, 59, '2023-12-26 23:33:07');



-- ----------------------------

-- Table structure for goods

-- ----------------------------

DROP TABLE IF EXISTS `goods`;

CREATE TABLE `goods`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',

  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片',

  `num` int NULL DEFAULT NULL COMMENT '库存量',

  `descr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',

  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '上架日期',

  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '上架' COMMENT '上架状态',

  `discount` double(11, 1) NULL DEFAULT 1.0 COMMENT '折扣',

  `business_id` int NULL DEFAULT NULL COMMENT '商家ID',

  `category_id` int NULL DEFAULT NULL COMMENT '分类ID',

  `score` int NULL DEFAULT NULL COMMENT '商品积分',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商品信息' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of goods

-- ----------------------------

INSERT INTO `goods` VALUES (10, '11朵分玫瑰花束(小香风花束)', 133.00, 'http://localhost:9090/files/1702036486562-p1.jpg', 3, '粉粉的哪个女生谁不喜欢呢！', '2023-12-15', '上架', 0.5, 19, 12, 133);

INSERT INTO `goods` VALUES (11, '11朵红玫瑰花【Romantic】', 88.00, 'http://localhost:9090/files/1702036545496-r1.jpg', 2, '情人节送女朋友最佳选择！', '2023-12-15', '上架', 0.6, 19, 12, 88);

INSERT INTO `goods` VALUES (12, '单只白玫瑰一朵玫瑰花', 12.80, 'http://localhost:9090/files/1702094122917-bai.jpg', 3, '家居花单只白玫瑰', '2023-12-15', '上架', 0.9, 19, 13, 13);

INSERT INTO `goods` VALUES (13, '粉荔枝1枝家用花', 9.00, 'http://localhost:9090/files/1702094192924-fenlizhi.jpg', 3, '神仙姐姐同款', '2023-12-15', '上架', 1.0, 19, 13, 9);

INSERT INTO `goods` VALUES (14, '粉色郁金香1枝', 28.00, 'http://localhost:9090/files/1702094252444-yu.jpg', 2, '郁金香的季节~家居鲜花', '2023-12-15', '上架', 0.6, 19, 13, 28);

INSERT INTO `goods` VALUES (15, '白色郁金香单枝', 48.00, 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', 1, '白色郁金香 家居单只鲜花', '2023-12-15', '上架', 0.4, 19, 13, 48);

INSERT INTO `goods` VALUES (16, '苹果种子', 0.00, 'http://localhost:9090/files/1702823095162-apple.jpg', 1, '这可是限定的苹果种子噢！', '2023-12-22', '上架', 1.0, 22, 21, 300);

INSERT INTO `goods` VALUES (17, '白玫瑰茉莉', 69.00, 'http://localhost:9090/files/1703258824611-白玫瑰和茉莉.jpg', 5, '白白绿绿的颜色！爱！', '2023-12-22', '上架', 0.9, 19, 12, 69);

INSERT INTO `goods` VALUES (18, '曼塔乌梅子酱', 55.00, 'http://localhost:9090/files/1703258903669-曼塔乌梅子酱.jpg', 7, '紫白相间，绝！', '2023-12-22', '上架', 0.9, 19, 12, 55);

INSERT INTO `goods` VALUES (19, '招财进宝', 300.00, 'http://localhost:9090/files/1703259261052-green1.jpg', 2, '开业发财树,开业花', '2023-12-27', '上架', 0.9, 20, 15, 300);

INSERT INTO `goods` VALUES (20, '幸福树', 399.00, 'http://localhost:9090/files/1703259314191-green2.jpg', 2, '放一盆在公司会幸福噢', '2023-12-26', '上架', 0.8, 20, 15, 399);

INSERT INTO `goods` VALUES (21, '盆满钵满', 499.00, 'http://localhost:9090/files/1703259367238-green3.jpg', 3, '放在公司发大财！', '2023-12-30', '上架', 0.7, 20, 15, 499);

INSERT INTO `goods` VALUES (22, '金钱树', 349.00, 'http://localhost:9090/files/1703259412038-green4.jpg', 1, '发财发财发财！', '2023-12-31', '上架', 0.8, 20, 15, 349);

INSERT INTO `goods` VALUES (23, '薄荷盆栽', 19.00, 'http://localhost:9090/files/1703259577896-lv4.jpg', 10, '可食用薄荷！', '2023-12-25', '上架', 1.0, 20, 14, 25);

INSERT INTO `goods` VALUES (24, '仙人掌盆栽', 14.90, 'http://localhost:9090/files/1703259651281-lv3.jpg', 15, '聚财仙人掌客厅绿植花卉室内桌面好养', '2023-12-14', '上架', 0.9, 20, 14, 15);

INSERT INTO `goods` VALUES (25, '观叶吻住盆栽', 25.90, 'http://localhost:9090/files/1703259746903-lv1.jpg', 3, '净化空气，简约，可摆茶几', '2023-12-26', '上架', 0.9, 20, 14, 30);

INSERT INTO `goods` VALUES (26, '山青竹金钻大叶', 13.00, 'http://localhost:9090/files/1703259829460-lv.jpg', 10, '去甲醛，吸毒王！', '2023-12-31', '上架', 0.9, 20, 14, 13);

INSERT INTO `goods` VALUES (27, '复古做旧花盆', 59.00, 'http://localhost:9090/files/1703260101916-taoci.png', 6, '复古做旧逼格拉满', '2023-12-26', '上架', 0.9, 21, 17, 60);

INSERT INTO `goods` VALUES (28, '青花瓷花盆', 79.00, 'http://localhost:9090/files/1703260156264-taoci1.png', 3, '青花瓷系列复古', '2023-12-27', '上架', 0.9, 21, 17, 80);

INSERT INTO `goods` VALUES (29, '红色塑料花盆', 1.00, 'http://localhost:9090/files/1703260229687-suoliao1.jpg', 99, '红色塑料花盆简单好用', '2023-12-28', '上架', 1.0, 21, 16, 1);

INSERT INTO `goods` VALUES (30, '爱丽丝花盆', 0.90, 'http://localhost:9090/files/1703260272246-爱丽思花盆.jpg', 999, '白色简约用坏不心疼', '2023-12-19', '上架', 1.0, 21, 16, 1);

INSERT INTO `goods` VALUES (31, '白色小花盆', 0.00, 'http://localhost:9090/files/1703260424822-爱丽思花盆.jpg', 30, '简单好看', '2023-12-27', '上架', 1.0, 22, 20, 300);

INSERT INTO `goods` VALUES (32, '草莓种子', 0.00, 'http://localhost:9090/files/1703260508956-草莓种子.jpg', 15, '好看又好吃！', '2023-12-27', '上架', 1.0, 22, 21, 500);

INSERT INTO `goods` VALUES (33, '香梨籽', 0.00, 'http://localhost:9090/files/1703260552984-香梨籽.jpg', 19, '种出来的是香香的香梨！', '2023-12-28', '上架', 1.0, 22, 21, 399);

INSERT INTO `goods` VALUES (34, '查拉皮塔辣椒种子', 0.00, 'http://localhost:9090/files/1703260673049-查拉皮塔辣椒种子.jpg', 19, '查拉皮塔辣椒很少见吧？嘿嘿', '2023-12-31', '上架', 1.0, 22, 21, 500);



-- ----------------------------

-- Table structure for notice

-- ----------------------------

DROP TABLE IF EXISTS `notice`;

CREATE TABLE `notice`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标题',

  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建时间',

  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '公告信息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of notice

-- ----------------------------

INSERT INTO `notice` VALUES (1, '今天系统正式上线，开始内测', '今天系统正式上线，开始内测', '2023-12-15', 'admin');

INSERT INTO `notice` VALUES (4, '欢迎来到花市集后台管理系统，商家们自行操作！', '欢迎来到花市集后台管理系统，商家们自行操作！', '2023-12-08', 'admin');



-- ----------------------------

-- Table structure for orders

-- ----------------------------

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '订单编号',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '下单时间',

  `pay_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '支付时间',

  `pay_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '订单状态',

  `business_id` int NULL DEFAULT NULL COMMENT '接单商家ID',

  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '收货人',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '收货人电话',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '送货地址',

  `user_id` int NULL DEFAULT NULL COMMENT '下单人ID',

  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总价',

  `discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠金额',

  `actual` decimal(10, 2) NULL DEFAULT NULL COMMENT '实付款',

  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',

  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '缩略图',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of orders

-- ----------------------------

INSERT INTO `orders` VALUES (37, '1733473001837436928', '2023-12-09 21:05:42', '2023-12-22 22:41:22', '支付宝', '已完成', 19, '刘德华', '999', '广州 天河', 6, 96.00, 57.60, 38.40, '', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', '白色郁金香单枝等2件商品');

INSERT INTO `orders` VALUES (38, '1733475454951628800', '2023-12-09 21:15:29', '2023-12-22 22:41:23', '支付宝', '已完成', 19, '刘德华', '999', '广州 天河', 6, 48.00, 28.80, 19.20, '', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', '白色郁金香单枝等1件商品');

INSERT INTO `orders` VALUES (39, '1736248085400608768', '2023-12-17 12:52:54', '2023-12-22 22:41:24', '支付宝', '已完成', 19, '刘德华', '888999', '广州市 天河区', 6, 48.00, 28.80, 19.20, '', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', '白色郁金香单枝等1件商品');

INSERT INTO `orders` VALUES (40, '1736251946978861056', '2023-12-17 13:08:16', '2023-12-22 22:41:25', '支付宝', '已完成', 19, '刘德华', '888999', '广州市 天河区', 6, 48.00, 28.80, 19.20, '', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', '白色郁金香单枝等1件商品');

INSERT INTO `orders` VALUES (51, '1736416118718951424', '2023-12-18 00:00:36', '2023-12-18 00:03:23', NULL, '待收货', 22, '刘德华', '888999', '广州市 天河区', 6, NULL, NULL, NULL, '', 'http://localhost:9090/files/1702823095162-apple.jpg', '苹果种子');

INSERT INTO `orders` VALUES (52, '1736417195845595136', '2023-12-18 00:04:53', NULL, NULL, '待收货', 22, '刘德华', '888999', '广州市 天河区', 6, NULL, NULL, NULL, '', 'http://localhost:9090/files/1702823095162-apple.jpg', '苹果种子');

INSERT INTO `orders` VALUES (58, '1738235644913766400', '2023-12-23 00:30:45', '2023-12-23 00:30:57', '微信支付', '已完成', 19, '张某', '999', '广工校门口', 10, 88.00, 35.20, 52.80, '12.23 17-18点', 'http://localhost:9090/files/1702036545496-r1.jpg', '11朵红玫瑰花【Romantic】等1件商品');

INSERT INTO `orders` VALUES (59, '1739670233683099648', '2023-12-26 23:31:18', '2023-12-26 23:31:33', '支付宝', '已完成', 19, '梁朝伟', '111', '广州', 6, 28.00, 11.20, 16.80, '12.28 17-18点', 'http://localhost:9090/files/1702094252444-yu.jpg', '粉色郁金香1枝等1件商品');



-- ----------------------------

-- Table structure for orders_item

-- ----------------------------

DROP TABLE IF EXISTS `orders_item`;

CREATE TABLE `orders_item`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `order_id` int NULL DEFAULT NULL COMMENT '订单ID',

  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '商品名称',

  `goods_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '商品图片',

  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品价格',

  `num` int NULL DEFAULT NULL COMMENT '购买数量',

  `goods_id` int NULL DEFAULT NULL COMMENT '商品id',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '订单详情表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of orders_item

-- ----------------------------

INSERT INTO `orders_item` VALUES (16, 37, '白色郁金香单枝', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', 19.20, 2, 15);

INSERT INTO `orders_item` VALUES (17, 38, '白色郁金香单枝', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', 19.20, 1, 15);

INSERT INTO `orders_item` VALUES (18, 39, '白色郁金香单枝', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', 19.20, 1, 15);

INSERT INTO `orders_item` VALUES (19, 40, '白色郁金香单枝', 'http://localhost:9090/files/1702094308892-yujinxiang.jpg', 19.20, 1, 15);

INSERT INTO `orders_item` VALUES (30, 52, '苹果种子', 'http://localhost:9090/files/1702823095162-apple.jpg', NULL, -1, 16);

INSERT INTO `orders_item` VALUES (36, 58, '11朵红玫瑰花【Romantic】', 'http://localhost:9090/files/1702036545496-r1.jpg', 52.80, 1, 11);

INSERT INTO `orders_item` VALUES (37, 59, '粉色郁金香1枝', 'http://localhost:9090/files/1702094252444-yu.jpg', 16.80, 1, 14);



-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '账号',

  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',

  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',

  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色',

  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '性别',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',

  `score` int NULL DEFAULT 1 COMMENT '用户积分',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES (6, 'cino', '123', '刘德华', 'http://localhost:9090/files/1700557122491-背景2.png', 'USER', '男', '18888889800', 129);

INSERT INTO `user` VALUES (10, 'zhang', '123', 'zhang', 'http://localhost:9090/files/1697438073596-avatar.png', 'USER', NULL, NULL, 89);



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/cino333/flower.git
git@gitee.com:cino333/flower.git
cino333
flower
花市集小程序
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部