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

zhangqiao/water-drop-mobile-mongoDB

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
water.sql 23.13 KB
一键复制 编辑 原始数据 按行查看 历史
qiao 提交于 2023-11-29 15:33 . courseList接口彻底完成
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
/*

 Navicat Premium Data Transfer



 Source Server         : 小龙的mysql

 Source Server Type    : MySQL

 Source Server Version : 50650 (5.6.50-log)

 Source Host           : 124.222.78.14:3306

 Source Schema         : water



 Target Server Type    : MySQL

 Target Server Version : 50650 (5.6.50-log)

 File Encoding         : 65001



 Date: 29/11/2023 10:35:27

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for card

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

DROP TABLE IF EXISTS `card`;

CREATE TABLE `card`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `createdAt` timestamp NOT NULL COMMENT '创建时间',

  `createdBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',

  `updatedAt` timestamp NULL DEFAULT NULL COMMENT '修改时间',

  `updatedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',

  `deletedAt` datetime(6) NULL DEFAULT NULL,

  `deletedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除者',

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

  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'time' COMMENT '卡类型',

  `time` int(11) NOT NULL DEFAULT 0 COMMENT '上课次数',

  `validityDay` int(11) NOT NULL DEFAULT 0 COMMENT '有效期',

  `courseId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `orgId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `FK_0b739c2e3573cc62ea799ba3e1d`(`courseId`) USING BTREE,

  INDEX `FK_2ddfcd5175843e1beae28b7e5df`(`orgId`) USING BTREE,

  CONSTRAINT `FK_0b739c2e3573cc62ea799ba3e1d` FOREIGN KEY (`courseId`) REFERENCES `course` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

  CONSTRAINT `FK_2ddfcd5175843e1beae28b7e5df` FOREIGN KEY (`orgId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of card

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

INSERT INTO `card` VALUES ('1', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, 'name', 'time', 0, 0, NULL, NULL);



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

-- Table structure for course

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

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `createdAt` timestamp NOT NULL COMMENT '创建时间',

  `createdBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',

  `updatedAt` timestamp NULL DEFAULT NULL COMMENT '修改时间',

  `updatedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',

  `deletedAt` datetime(6) NULL DEFAULT NULL,

  `deletedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除者',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程名称',

  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '课程描述',

  `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '适龄人群',

  `baseAbility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '适合基础',

  `limitNumber` int(11) NOT NULL COMMENT '限制上课人数',

  `duration` int(11) NOT NULL COMMENT '持续时间',

  `reserveInfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预约信息',

  `refundInfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '退款信息',

  `otherInfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其他说明信息',

  `reducibleTime` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '可约时间',

  `orgId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `FK_e29a2256e16530deb4cc8c78ec3`(`orgId`) USING BTREE,

  CONSTRAINT `FK_e29a2256e16530deb4cc8c78ec3` FOREIGN KEY (`orgId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of course

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

INSERT INTO `course` VALUES ('33d94c0d-e2d1-40cd-9356-ed02da940cbb', '2023-11-28 18:40:28', '1', '2023-11-28 18:40:45', '1', NULL, NULL, '成为帅比', '111', '16-25', 'react基础', 1, 1, '1', '1', '11', '[{\"week\":\"monday\",\"orderTime\":[{\"startTime\":\"12:00:00\",\"endTime\":\"12:30:00\",\"key\":1}]},{\"week\":\"tuesday\",\"orderTime\":[{\"startTime\":\"12:00:00\",\"endTime\":\"12:30:00\",\"key\":1}]},{\"week\":\"wednesday\",\"orderTime\":[{\"startTime\":\"12:00:00\",\"endTime\":\"12:30:00\",\"key\":1}]},{\"week\":\"thursday\",\"orderTime\":[{\"startTime\":\"12:00:00\",\"endTime\":\"12:30:00\",\"key\":1}]},{\"week\":\"friday\",\"orderTime\":[{\"startTime\":\"12:00:00\",\"endTime\":\"12:30:00\",\"key\":1}]}]', '05620b57-b402-4342-8301-51c506724eb8');

INSERT INTO `course` VALUES ('565054ab-88d7-42e7-8697-0d64da14f2ce', '2023-11-25 16:19:46', '3', '2023-11-25 16:20:13', '3', NULL, NULL, '理解帅比', '细细了解帅比的发展历程。', '18-80', '大胆开放、无所畏惧、会卖弄身姿', 16, 90, '随时预约', '不随时退款', '成为帅比，做一个大胆开放、无所畏惧、会卖弄身姿的帅比', '[{\"week\":\"monday\",\"orderTime\":[]},{\"week\":\"tuesday\",\"orderTime\":[]},{\"week\":\"wednesday\",\"orderTime\":[]},{\"week\":\"thursday\",\"orderTime\":[]},{\"week\":\"friday\",\"orderTime\":[]}]', 'ce1f07d1-be63-4b93-a287-ce2b03686608');

INSERT INTO `course` VALUES ('bb5e98dd-e037-4224-bdb2-87e229a0fa38', '2023-11-25 17:06:11', '3', '2023-11-25 17:31:23', '3', NULL, NULL, '成为帅比', '成为帅比', '16-25', '大胆开放、无所畏惧、会卖弄身姿', 5, 45, '随时预约', '不接受退款', '成为帅比，做一个大胆开放、无所畏惧、会卖弄身姿的帅比', '[{\"week\":\"monday\",\"orderTime\":[]},{\"week\":\"tuesday\",\"orderTime\":[]},{\"week\":\"wednesday\",\"orderTime\":[]},{\"week\":\"thursday\",\"orderTime\":[]},{\"week\":\"friday\",\"orderTime\":[]},{\"week\":\"saturday\",\"orderTime\":[]},{\"week\":\"sunday\",\"orderTime\":[]}]', 'ce1f07d1-be63-4b93-a287-ce2b03686608');

INSERT INTO `course` VALUES ('cd86c766-e3a6-47c1-a7e6-772dcabc04eb', '2023-11-25 15:42:17', NULL, '2023-11-25 15:42:17', '1', NULL, NULL, '课程名称', '课程描述', '适龄人群', '适合基础', 50, 2000, '预约信息', '退款信息', '其他说明信息', '[{\"week\":\"monday\",\"orderTime\":[]},{\"week\":\"tuesday\",\"orderTime\":[]},{\"week\":\"wednesday\",\"orderTime\":[]},{\"week\":\"thursday\",\"orderTime\":[]},{\"week\":\"friday\",\"orderTime\":[]},{\"week\":\"saturday\",\"orderTime\":[]},{\"week\":\"sunday\",\"orderTime\":[]}]', '05620b57-b402-4342-8301-51c506724eb8');

INSERT INTO `course` VALUES ('df47f077-a5a2-45f2-893c-b285b616607c', '2023-11-25 16:18:28', '3', '2023-11-25 16:18:36', '3', NULL, NULL, '质疑帅比？', '提出问题：质疑帅有什么用。', '18-80', '大胆开放、无所畏惧、会卖弄身姿', 8, 120, '随时预约', '不随时退款', '芜湖芜湖芜湖', '[{\"week\":\"monday\",\"orderTime\":[]},{\"week\":\"tuesday\",\"orderTime\":[]},{\"week\":\"wednesday\",\"orderTime\":[]},{\"week\":\"thursday\",\"orderTime\":[]},{\"week\":\"friday\",\"orderTime\":[]}]', 'ce1f07d1-be63-4b93-a287-ce2b03686608');



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

-- Table structure for org_image

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

DROP TABLE IF EXISTS `org_image`;

CREATE TABLE `org_image`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地址',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'remark',

  `orgIdForFrontId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `orgIdForRoomId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  `orgIdForOtherId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `FK_63d62c57996b1fc20a02e80c508`(`orgIdForFrontId`) USING BTREE,

  INDEX `FK_8bae051d6ee0069e520df974433`(`orgIdForRoomId`) USING BTREE,

  INDEX `FK_21c6620c4a108142b673c70697a`(`orgIdForOtherId`) USING BTREE,

  CONSTRAINT `FK_21c6620c4a108142b673c70697a` FOREIGN KEY (`orgIdForOtherId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

  CONSTRAINT `FK_63d62c57996b1fc20a02e80c508` FOREIGN KEY (`orgIdForFrontId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

  CONSTRAINT `FK_8bae051d6ee0069e520df974433` FOREIGN KEY (`orgIdForRoomId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of org_image

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

INSERT INTO `org_image` VALUES ('30ecd56b-967d-44f0-b479-45a80f414790', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224321683-10.jpg', NULL, '1a1fd47f-e018-4ee1-9668-106476071eed', NULL, NULL);

INSERT INTO `org_image` VALUES ('39a420c3-dce9-4f19-8426-494ebece8423', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701219716921-12.jpg', NULL, NULL, 'ce1f07d1-be63-4b93-a287-ce2b03686608', NULL);

INSERT INTO `org_image` VALUES ('917dbffe-6fac-45f8-aec4-6913f87f31f1', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224983358-24.jpg', NULL, NULL, NULL, '05620b57-b402-4342-8301-51c506724eb8');

INSERT INTO `org_image` VALUES ('93fec382-77af-43ef-a852-20b258557d26', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224452623-10.jpg', NULL, NULL, '1a1fd47f-e018-4ee1-9668-106476071eed', NULL);

INSERT INTO `org_image` VALUES ('99680662-08bb-41e8-aca5-2c371082d1b3', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701155490832-21.jpg', NULL, NULL, '05620b57-b402-4342-8301-51c506724eb8', NULL);

INSERT INTO `org_image` VALUES ('a36e0783-8109-4539-957b-276f49d5d2aa', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224983358-22.jpg', NULL, NULL, '05620b57-b402-4342-8301-51c506724eb8', NULL);

INSERT INTO `org_image` VALUES ('b52027e3-42b8-483f-9593-6d6652aba9aa', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701221674387-37.jpg', NULL, '05620b57-b402-4342-8301-51c506724eb8', NULL, NULL);

INSERT INTO `org_image` VALUES ('b547ccec-1fb1-4552-bd74-aa69ff251d6f', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224321683-8.jpg', NULL, '1a1fd47f-e018-4ee1-9668-106476071eed', NULL, NULL);

INSERT INTO `org_image` VALUES ('b71d91ca-c235-49f6-820f-b1329b7f2f94', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701219716921-10.jpg', NULL, 'ce1f07d1-be63-4b93-a287-ce2b03686608', NULL, NULL);

INSERT INTO `org_image` VALUES ('cb88f94b-40b7-4abb-9cb8-4ed1fc77bf09', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224452623-8.jpg', NULL, NULL, '1a1fd47f-e018-4ee1-9668-106476071eed', NULL);



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

-- Table structure for organization

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

DROP TABLE IF EXISTS `organization`;

CREATE TABLE `organization`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `createdAt` timestamp NOT NULL COMMENT '创建时间',

  `createdBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',

  `updatedAt` timestamp NULL DEFAULT NULL COMMENT '修改时间',

  `updatedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',

  `deletedAt` datetime(6) NULL DEFAULT NULL,

  `deletedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除者',

  `businessLicense` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '营业执照',

  `identityCardFrontImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '法人身份证正面',

  `identityCardBackImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '法人身份证反面',

  `tags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标签 以，隔开',

  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '简介',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '机构名',

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

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

  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',

  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',

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

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of organization

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

INSERT INTO `organization` VALUES ('05620b57-b402-4342-8301-51c506724eb8', '2023-11-28 15:13:20', '1', '2023-11-28 15:16:50', '1', NULL, NULL, 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701155490832-13.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701155490832-15.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701155490832-17.jpg', '111', '11', '左哥传媒 ', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701155490832-11.png', '河北省保定市莲池区', '50', '50', '1008611');

INSERT INTO `organization` VALUES ('1a1fd47f-e018-4ee1-9668-106476071eed', '2023-11-29 09:35:53', '3', '2023-11-29 10:15:41', '3', NULL, NULL, 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701221729641-10.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701221729641-12.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701221729641-14.jpg', '1', '1', '左越', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224131618-8.jpg', '1', '1', '1', '15754834056');

INSERT INTO `organization` VALUES ('38d4fdb0-50f5-4660-8d1d-f3c1f7803cba', '2023-11-28 19:49:50', '3', '2023-11-28 20:21:45', '3', '2023-11-28 21:15:33.000000', '3', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701172166407-10.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701172166407-12.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701172166407-14.jpg', '1', '123', '左越', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701174096224-8.jpg', '内蒙古呼和浩特市回民区祥和四区', '110', '120', '15754834056');

INSERT INTO `organization` VALUES ('b6b98395-3653-434e-9511-1234ad65d5c1', '2023-11-28 21:15:20', '3', '2023-11-28 21:15:20', NULL, '2023-11-28 21:15:30.000000', '3', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701177269896-24.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701177269896-26.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701177269896-28.jpg', '1', '123123', '左越', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701177269896-22.jpg', '内蒙古呼和浩特市回民区祥和四区', '110', '120', '15754834056');

INSERT INTO `organization` VALUES ('ce1f07d1-be63-4b93-a287-ce2b03686608', '2023-11-25 16:12:44', '3', '2023-11-29 09:28:09', '3', NULL, NULL, 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701150763262-19.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701150763262-21.jpg', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701150763262-23.jpg', '帅到爆炸,帅到发昏,帅到宇宙,帅出自我', '丑的来、帅的也来、屌丝来、2b更要来', '小帅比养成教育', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701221278555-17.jpg', '帅比星球-帅比国-帅比市-帅比区-帅比府邸', '110', '120', '15754834056');



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

-- Table structure for product

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

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `createdAt` timestamp NOT NULL COMMENT '创建时间',

  `createdBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',

  `updatedAt` timestamp NULL DEFAULT NULL COMMENT '修改时间',

  `updatedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',

  `deletedAt` datetime(6) NULL DEFAULT NULL,

  `deletedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除者',

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

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

  `stock` int(11) NOT NULL DEFAULT 0 COMMENT '库存总数',

  `curStock` int(11) NOT NULL DEFAULT 0 COMMENT '当前库存',

  `buyNumber` int(11) NOT NULL DEFAULT 0 COMMENT '卖出去多少',

  `limitBuyNumber` int(11) NOT NULL DEFAULT -1 COMMENT '每人限购数量',

  `coverUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '封面图',

  `bannerUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头部banner图',

  `originalPrice` float NOT NULL COMMENT '原价',

  `preferentialPrice` float NOT NULL COMMENT '优惠价格',

  `orgId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `FK_4001796e6dec57fa1424e6ffe22`(`orgId`) USING BTREE,

  CONSTRAINT `FK_4001796e6dec57fa1424e6ffe22` FOREIGN KEY (`orgId`) REFERENCES `organization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of product

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

INSERT INTO `product` VALUES ('1', '2023-11-08 18:15:30', '4546', '2023-11-17 18:15:45', '787878', '2023-11-23 18:15:53.000000', '787', '哈哈哈哈哈', '即使对方焊接速度放缓', 800, 200, 50, 120, 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAHQArgMBIgACEQEDEQH/', 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAHQArgMBIgACEQEDEQH/', 110, 90, 'ce1f07d1-be63-4b93-a287-ce2b03686608');



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

-- Table structure for student

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

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student`  (

  `createdAt` timestamp NOT NULL COMMENT '创建时间',

  `createdBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',

  `updatedAt` timestamp NULL DEFAULT NULL COMMENT '修改时间',

  `updatedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',

  `deletedAt` datetime(6) NULL DEFAULT NULL,

  `deletedBy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除者',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',

  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',

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

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

  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账户',

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of student

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

INSERT INTO `student` VALUES ('2023-11-28 19:21:35', NULL, '2023-11-28 19:21:35', NULL, NULL, NULL, '左越', '15754834056', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/1701170584316.jpg', 'af26610db5e49dd014584b03cd4d3599', 'admin1', '618e69c6-6ae7-4b42-8221-a99ad2530a5e');



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

-- Table structure for user

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

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user`  (

  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',

  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',

  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',

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

  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验证码',

  `codeCreateTimeAt` datetime NULL DEFAULT NULL COMMENT '验证码生成时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;



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

-- Records of user

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

INSERT INTO `user` VALUES ('1', '张大帅比', '管理员', '19357227510', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701224507517-16.png', '1', '2023-11-29 15:57:22');

INSERT INTO `user` VALUES ('3', '左大帅逼', '管理员', '15754834056', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701218960306-3.jpg', '1024', '2023-11-30 16:07:18');

INSERT INTO `user` VALUES ('888', '李托克斯', '世界的终结者', '15232711419', 'http://water-drop-article-team.oss-cn-beijing.aliyuncs.com/images/rc-upload-1701166121255-2.jpg', '8888', '2023-11-29 14:41:58');



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/zhang--qiao/water-drop-mobile-mongo-db.git
git@gitee.com:zhang--qiao/water-drop-mobile-mongo-db.git
zhang--qiao
water-drop-mobile-mongo-db
water-drop-mobile-mongoDB
master
点此查找更多帮助

搜索帮助

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