/*
Navicat MySQL Data Transfer

Source Server         : Mysql
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : umbrella

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2021-11-08 22:29:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for affliation
-- ----------------------------
DROP TABLE IF EXISTS `affliation`;
CREATE TABLE `affliation` (
  `comment_id` bigint(20) NOT NULL,
  `story_id` bigint(20) NOT NULL,
  `date` varchar(50) NOT NULL,
  `direction` bigint(20) NOT NULL,
  PRIMARY KEY (`comment_id`,`story_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of affliation
-- ----------------------------
INSERT INTO `affliation` VALUES ('1', '1', '2021.1.1', '1012');
INSERT INTO `affliation` VALUES ('2', '1', '2021.1.1', '1012');
INSERT INTO `affliation` VALUES ('3', '1', '2021.1.3', '1012');
INSERT INTO `affliation` VALUES ('5', '3', '2021.11.1', '1012');

-- ----------------------------
-- Table structure for babysitter
-- ----------------------------
DROP TABLE IF EXISTS `babysitter`;
CREATE TABLE `babysitter` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(10) NOT NULL COMMENT '姓名',
  `description` varchar(100) NOT NULL COMMENT '描述',
  `score` double(10,1) NOT NULL DEFAULT '2.5' COMMENT '评分',
  `photo` varchar(30) NOT NULL COMMENT '照片',
  `status` bigint(20) NOT NULL DEFAULT '0' COMMENT '状态 1代表已工作 0代表未工作',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of babysitter
-- ----------------------------
INSERT INTO `babysitter` VALUES ('1', '李芳', '是三个孩子的母亲，有丰富的月嫂经验。体贴负责，被誉为“温暖的港湾”', '2.9', '/res/images/number1.jpg', '1');
INSERT INTO `babysitter` VALUES ('2', '王玉兰', '温柔贴心', '4.0', '/res/images/number2.jpg', '0');
INSERT INTO `babysitter` VALUES ('3', '林燕', '耐心，考虑全面', '4.0', '/res/images/number3.jpg', '0');
INSERT INTO `babysitter` VALUES ('4', '王凤', '做事干练不拖沓，不会给您造成负担', '4.8', '/res/images/number4.jpg', '0');
INSERT INTO `babysitter` VALUES ('5', '唐悠悠', '非常能干，照顾宝宝能手', '4.5', '/res/images/number5.jpg', '0');
INSERT INTO `babysitter` VALUES ('6', '张月一', '雇佣过的人都说好', '4.4', '/res/images/number6.jpg', '0');
INSERT INTO `babysitter` VALUES ('7', '宋素梅', '带着爱来工作', '4.1', '/res/images/number7.jpg', '0');
INSERT INTO `babysitter` VALUES ('8', '肖月飞', '身体健康，照顾工作不在话下', '2.9', '/res/images/number8.jpg', '0');
INSERT INTO `babysitter` VALUES ('9', '黄英', '勤奋稳重', '2.5', '/res/images/number9.jpg', '0');
INSERT INTO `babysitter` VALUES ('13', '金秋菊', '踏实认真', '2.5', '/res/images/number10.jpg', '0');

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `consumer_id` bigint(20) NOT NULL COMMENT '普通用户ID',
  `commodity_id` bigint(20) NOT NULL COMMENT '商品ID',
  `style` varchar(40) DEFAULT NULL COMMENT '商品选项',
  `price` double(20,0) NOT NULL COMMENT '单价 有选项则为选项的单价',
  `count` bigint(20) NOT NULL COMMENT '数量',
  `img` varchar(40) NOT NULL COMMENT '商品图片',
  `name` varchar(20) NOT NULL COMMENT '商品名称',
  `status` bigint(20) NOT NULL DEFAULT '0' COMMENT '状态 1为选中 0为未选中',
  `amount` bigint(20) NOT NULL COMMENT '库存',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cart
-- ----------------------------
INSERT INTO `cart` VALUES ('24', '1000', '1', '蓝色', '24', '2', '/res/images/feeder.jpg', '尚迩丝奶瓶', '0', '9');
INSERT INTO `cart` VALUES ('25', '1000', '2', '红色', '37', '1', '/res/images/feeder2.jpg', '运智贝玻璃奶瓶', '0', '56');
INSERT INTO `cart` VALUES ('31', '1000', '9', null, '106', '1', '/res/images/naifen2.jpg', '关山奶粉', '0', '498');

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` varchar(100) NOT NULL,
  `consumer_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('1', '刚怀孕时，人体内的绒毛膜促性腺素(HCG)含量开始升高，所以会有孕吐反应。大多数女性，受孕1个月之后出现，少数女性整个孕期都不会。', '1014');
INSERT INTO `comment` VALUES ('2', '受孕激素影响，乳房在怀孕4-6周后开始增大并变得更加敏感孕妇的身体会产生许多雌激素和黄体酮。', '1013');
INSERT INTO `comment` VALUES ('3', '怀孕后体内雌激素随着妊娠月份增大而逐渐增多，雌激素能促进子宫颈及子宫内膜腺体分泌黏液，孕妇的阴部、阴道、子宫颈这些部位血流量旺盛，组织水分增多，因而分泌物也增多，白带也随之增多。', '1012');
INSERT INTO `comment` VALUES ('5', '学到了', '1000');

-- ----------------------------
-- Table structure for commodity
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `name` varchar(40) NOT NULL COMMENT '商品名称',
  `price` double NOT NULL COMMENT '商品价格',
  `amount` bigint(20) NOT NULL COMMENT '商品余量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES ('1', '尚迩丝奶瓶', '22', '40');
INSERT INTO `commodity` VALUES ('2', '运智贝玻璃奶瓶', '37', '60');
INSERT INTO `commodity` VALUES ('3', '飞利浦新安怡奶瓶', '55.9', '21');
INSERT INTO `commodity` VALUES ('4', '嘟嘟婴儿车', '140', '124');
INSERT INTO `commodity` VALUES ('6', '米奇乐圆孔奶嘴', '2', '173');
INSERT INTO `commodity` VALUES ('8', '新西兰爱必达奶粉', '94', '80');
INSERT INTO `commodity` VALUES ('9', '关山奶粉', '106', '498');
INSERT INTO `commodity` VALUES ('11', '安力聪奶粉', '110', '110');
INSERT INTO `commodity` VALUES ('12', '巴卜巴宝宝汤勺', '8', '1360');
INSERT INTO `commodity` VALUES ('13', '丁丁牌奶瓶', '27', '90');
INSERT INTO `commodity` VALUES ('16', '七田真胎教法', '69', '1');
INSERT INTO `commodity` VALUES ('17', '美奈斯婴儿车', '129', '137');
INSERT INTO `commodity` VALUES ('25', '太空奶嘴', '2', '35');

-- ----------------------------
-- Table structure for commodityinfo
-- ----------------------------
DROP TABLE IF EXISTS `commodityinfo`;
CREATE TABLE `commodityinfo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `description` varchar(100) NOT NULL COMMENT '商品描述',
  `img` varchar(40) NOT NULL COMMENT '封面图片',
  `option1` varchar(20) DEFAULT NULL COMMENT '选项1',
  `img1` varchar(40) DEFAULT NULL COMMENT '选项1的图片',
  `price1` double DEFAULT '0' COMMENT '选项1的价格',
  `option2` varchar(20) DEFAULT NULL COMMENT '选项2',
  `img2` varchar(40) DEFAULT NULL COMMENT '选项2的图片',
  `price2` double DEFAULT '0' COMMENT '选项2的价格',
  `option3` varchar(20) DEFAULT NULL COMMENT '选项3',
  `img3` varchar(40) DEFAULT NULL COMMENT '选项3的图片',
  `price3` double DEFAULT '0' COMMENT '选项3的价格',
  `amount1` bigint(20) DEFAULT '0' COMMENT '选项一的余量',
  `amount2` bigint(20) DEFAULT '0' COMMENT '选项二的余量',
  `amount3` bigint(20) DEFAULT '0' COMMENT '选项三的余量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of commodityinfo
-- ----------------------------
INSERT INTO `commodityinfo` VALUES ('1', '卫生环保，呵护宝宝的健康', '/res/images/feeder.jpg', '粉色', '/res/images/feeder.jpg', '22', '蓝色', '/res/images/feeder.jpg', '24', null, null, '0', '32', '8', '0');
INSERT INTO `commodityinfo` VALUES ('2', '瓶底底温变色，方便妈妈感知水温', '/res/images/feeder2.jpg', '红色', null, '37', '蓝色', null, '37', '紫色', null, '37', '56', '4', '0');
INSERT INTO `commodityinfo` VALUES ('3', '进口奶瓶，由高纯净玻璃制造', '/res/images/feeder3.jpg', null, null, '0', null, null, '0', null, null, '0', '0', '0', '0');
INSERT INTO `commodityinfo` VALUES ('4', '安全稳重，材料无害，不会对宝宝健康造成影响', '/res/images/car1.jpg', '绿色', '/res/images/car1.jpg', '140', '蓝色', '/res/images/car1_1.jpg', '140', null, null, '0', '61', '63', '0');
INSERT INTO `commodityinfo` VALUES ('6', '由硅胶所制', '/res/images/naizui1.jpg', null, null, '0', null, null, '0', null, null, '0', '0', '0', '0');
INSERT INTO `commodityinfo` VALUES ('8', '源于新西兰，奶粉醇香可口，还有安眠的效果哦！', '/res/images/naifen1.jpg', '奶粉1kg', null, '94', '奶粉1.5kg', null, '138', null, null, '0', '30', '50', '0');
INSERT INTO `commodityinfo` VALUES ('9', '采用纯正的羊奶，经过专家们悉心研究所制成的安全奶粉。', '/res/images/naifen2.jpg', null, null, '0', null, null, '0', null, null, '0', '0', '0', '0');
INSERT INTO `commodityinfo` VALUES ('11', '醇香可口', '/res/images/naifen3.jpg', '奶粉1kg', null, '110', '奶粉1.5kg', null, '170', null, null, '0', '41', '69', '0');
INSERT INTO `commodityinfo` VALUES ('12', '喝汤专用，非常适合宝宝。', '/res/images/tangshi1_2.jpg', '陶瓷版', '/res/images/tangshi1_2.jpg', '8', '不锈钢版', '/res/images/tangshi1_1.jpg', '12', null, null, '0', '1110', '250', '0');
INSERT INTO `commodityinfo` VALUES ('13', '有着充满童趣的外表。', '/res/images/feeder4_1.jpg', '黄色双把', '/res/images/feeder4_1.jpg', '27', '白色朴素', '/res/images/feeder4_2.jpg', '28', '花样年华', '/res/images/feeder4_3.jpg', '35', '60', '10', '20');
INSERT INTO `commodityinfo` VALUES ('16', '科学胎教', '/res/images/book1.jpg', null, null, '0', null, null, '0', null, null, '0', '0', '0', '0');
INSERT INTO `commodityinfo` VALUES ('17', '安全实用，值得拥有', '/res/images/car2.jpg', '黄色', '/res/images/car2.jpg', '129', '蓝色', '/res/images/car2_1.jpg', '130', '红色', '/res/images/car2_2.jpg', '132', '35', '37', '65');
INSERT INTO `commodityinfo` VALUES ('25', '安全', '/res/images/naizui2.jpg', null, null, '0', null, null, '0', null, null, '0', '0', '0', '0');

-- ----------------------------
-- Table structure for complaint
-- ----------------------------
DROP TABLE IF EXISTS `complaint`;
CREATE TABLE `complaint` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投诉信箱ID',
  `consumer_id` bigint(20) NOT NULL COMMENT '普通用户ID',
  `babysitter_name` varchar(10) NOT NULL COMMENT '月嫂姓名',
  `time` varchar(20) NOT NULL COMMENT '投诉日期',
  `content` varchar(200) NOT NULL COMMENT '投诉内容',
  `status` bigint(20) NOT NULL DEFAULT '0' COMMENT '投诉审阅状态 0表示未审阅 1表示已审阅',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of complaint
-- ----------------------------
INSERT INTO `complaint` VALUES ('1', '1000', '王玉兰', '2020-12-04 20:46:01', '对待宝宝太粗暴了！', '1');
INSERT INTO `complaint` VALUES ('6', '1000', '林燕', '2020-12-06 12:37:26', '经常开小差', '1');
INSERT INTO `complaint` VALUES ('7', '1000', '宋素梅', '2020-12-14 10:36:12', '有点懒', '1');
INSERT INTO `complaint` VALUES ('8', '1000', '黄英', '2020-12-18 10:23:47', '太粗鲁', '1');
INSERT INTO `complaint` VALUES ('9', '1000', '王玉兰', '2020-12-31 10:28:24', '笨手笨脚', '0');
INSERT INTO `complaint` VALUES ('10', '1000', '金苏菊', '2021-02-01 14:06:22', '心不在焉', '1');
INSERT INTO `complaint` VALUES ('15', '1000', '王凤', '2021-06-03 20:32:37', '粗略', '0');
INSERT INTO `complaint` VALUES ('16', '1000', '林燕', '2021-06-04 09:15:52', '粗鲁', '1');

-- ----------------------------
-- Table structure for consumer
-- ----------------------------
DROP TABLE IF EXISTS `consumer`;
CREATE TABLE `consumer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(10) NOT NULL COMMENT '昵称',
  `age` int(11) NOT NULL COMMENT '年龄',
  `phone` varchar(11) NOT NULL COMMENT '电话',
  `password` varchar(32) NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1015 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of consumer
-- ----------------------------
INSERT INTO `consumer` VALUES ('1000', '章越', '27', '18048492046', '96e79218965eb72c92a549dd5a330112');  #加密前为111111
INSERT INTO `consumer` VALUES ('1012', '华沙', '29', '18111111111', 'e10adc3949ba59abbe56e057f20f883e');  #加密前为123456
INSERT INTO `consumer` VALUES ('1013', '伯伯', '31', '14725836999', '96e79218965eb72c92a549dd5a330112');  #加密前为111111
INSERT INTO `consumer` VALUES ('1014', '丁丁', '29', '11111000102', '96e79218965eb72c92a549dd5a330112');  #加密前为111111

-- ----------------------------
-- Table structure for employment
-- ----------------------------
DROP TABLE IF EXISTS `employment`;
CREATE TABLE `employment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `consumer_id` bigint(20) NOT NULL COMMENT '普通用户ID',
  `babysitter_id` bigint(20) NOT NULL COMMENT '月嫂ID',
  `days` bigint(20) NOT NULL COMMENT '雇佣天数',
  `beginning` varchar(50) NOT NULL COMMENT '起始时间',
  `ending` varchar(50) NOT NULL COMMENT '结束时间',
  `status` bigint(20) NOT NULL DEFAULT '0' COMMENT '状态 0表示进行中 1表示已结束 2表示试用中',
  `good_reputation` bigint(20) NOT NULL DEFAULT '0' COMMENT '是否给好评 0表示未给 1表示已给',
  `negative_comment` bigint(20) NOT NULL DEFAULT '0' COMMENT '是否给差评 0表示未给 1表示已给',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of employment
-- ----------------------------
INSERT INTO `employment` VALUES ('1', '1000', '4', '3', '2021-03-15 16:11:56', '2021-03-18 16:11:56', '1', '1', '1');
INSERT INTO `employment` VALUES ('2', '1000', '1', '3', '2021-03-15 16:18:38', '2021-03-18 16:18:38', '1', '1', '0');
INSERT INTO `employment` VALUES ('3', '1000', '5', '30', '2021-03-30 15:40:32', '2021-04-29 15:40:32', '1', '1', '1');
INSERT INTO `employment` VALUES ('4', '1000', '6', '3', '2021-03-30 15:41:32', '2021-04-02 15:41:32', '1', '1', '0');
INSERT INTO `employment` VALUES ('5', '1000', '6', '33', '2021-03-30 15:41:32', '2021-05-02 15:41:32', '1', '1', '0');
INSERT INTO `employment` VALUES ('6', '1000', '2', '3', '2021-04-19 14:49:43', '2021-04-22 14:49:43', '1', '1', '0');
INSERT INTO `employment` VALUES ('12', '1000', '2', '30', '2021-06-01 16:37:42', '2021-06-31 16:37:42', '1', '1', '0');

-- ----------------------------
-- Table structure for essay
-- ----------------------------
DROP TABLE IF EXISTS `essay`;
CREATE TABLE `essay` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '短文编号',
  `title` varchar(20) NOT NULL COMMENT '短文标题',
  `content` varchar(600) NOT NULL COMMENT '短文内容',
  `type` bigint(20) NOT NULL COMMENT '类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3010 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of essay
-- ----------------------------
INSERT INTO `essay` VALUES ('3000', '月子的定义', '所谓“月子”，在医学上是指产褥期，即是从分娩结束到产妇身体恢复至孕前状态的这段时间。在正常的妊娠过程中，胎儿及胎盘娩出后，子宫就需要有所恢复，而胎盘剥离的创面完全愈合大概需要六周的时间，因此把产褥期定到产后的六周，也就是产妇生产后的六周叫做产褥期，俗称为“月子”', '1');
INSERT INTO `essay` VALUES ('3001', '伞车适合几个月大的宝宝使用', '六个月以上，因为六个月以下的宝宝由于颈部脊椎发育未成熟，还不能自己坐稳，所以须六个月以上的婴儿才能使用。', '3');
INSERT INTO `essay` VALUES ('3002', '婴儿多大可以学步车？', '6-8个月以后，婴儿不宜过早学走，婴儿从卧到坐，从爬到立需要12个月左右。并不是越早越好的，不满周岁的孩子，骨骼和肌肉发育不健全，还很软，过早的站立行走，足部负荷过重，会对脚造成损伤，严重的影响脚的形成，出现扁平足，下肢也会因负担过重，小脚变形，特别是胖孩子，更不宜过早走路.', '3');
INSERT INTO `essay` VALUES ('3003', '父亲情绪会影响婴儿', '研究表明，爸爸情绪坏，更容易影响到婴儿的情绪。看样子，婴儿的情绪是易受父亲的感染多，所以，建议新手爸爸们多注意控制自己的情绪哦。', '3');
INSERT INTO `essay` VALUES ('3004', '怀孕前父亲的准备', '丈夫要做到不偏食。精子的生成需要优质蛋白质、钙、锌等矿物质和微量元素、精氨酸、多种维生素等。如果偏食，饮食中缺少这些营养素，精子的生成会受到影响，或会产生一些低质精子。', '1');
INSERT INTO `essay` VALUES ('3005', '怀孕初期表现', '1、月经停止，2、乳房有刺痛﹑膨胀和搔痒感，3、常有恶心﹑呕吐的感觉，4、皮肤颜色有变化，5、阴道黏膜变色，6、容易疲倦，7、频尿一般月经推迟7天之内都是正常的现象的，会受精神因素的影响的。建议，首先是月经推迟超过7天，并且在怀孕6周之后会有早孕的反应，有嗜睡的症状的。', '2');
INSERT INTO `essay` VALUES ('3006', '以下食物可能会导致流产或宝宝变傻', '螃蟹；甲鱼；罐头食品；菠菜；巧克力；山楂；猪肝；久存的土豆；热性作物；西瓜；味精；石榴；桂圆荔枝', '2');
INSERT INTO `essay` VALUES ('3007', '孕妇的肚子不可以随便摸', '孕妇怀孕不到36周，千万不用频繁摸肚皮，这样会引起子宫收缩，可能导致婴儿早产。不当手法还可造成胎位不正。', '2');
INSERT INTO `essay` VALUES ('3009', '生完小孩后保养方法1', '产后4-6小时之内一定要解小便，因为在孕期宝宝一直顶着膀胱，一旦宝宝出生，膀胱压力以下减少，它就会毫无知觉膨胀。', '4');

-- ----------------------------
-- Table structure for exam
-- ----------------------------
DROP TABLE IF EXISTS `exam`;
CREATE TABLE `exam` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '试题编号',
  `expert_id` bigint(20) NOT NULL COMMENT '专家ID',
  `name` varchar(20) NOT NULL COMMENT '试题名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5002 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of exam
-- ----------------------------
INSERT INTO `exam` VALUES ('5000', '2000', '养胎试题1');
INSERT INTO `exam` VALUES ('5001', '2000', '宝宝试题1');

-- ----------------------------
-- Table structure for expert
-- ----------------------------
DROP TABLE IF EXISTS `expert`;
CREATE TABLE `expert` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(10) NOT NULL COMMENT '姓名',
  `sex` varchar(3) NOT NULL COMMENT '性别',
  `phone` varchar(11) NOT NULL COMMENT '电话',
  `password` varchar(32) NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2006 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of expert
-- ----------------------------
INSERT INTO `expert` VALUES ('2000', '杜丽凌', '女', '18222222222', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111
INSERT INTO `expert` VALUES ('2001', '方明明', '女', '18222222220', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111
INSERT INTO `expert` VALUES ('2002', '李明', '男', '18222222228', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111
INSERT INTO `expert` VALUES ('2003', '杨天', '女', '18711111111', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111
INSERT INTO `expert` VALUES ('2004', '李鹏', '男', '18048492049', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111
INSERT INTO `expert` VALUES ('2005', '王归', '男', '11221111100', '96e79218965eb72c92a549dd5a330112');  # 加密前为111111

-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
  `consumer_id` bigint(20) NOT NULL COMMENT '普通用户ID',
  `exam_id` bigint(20) NOT NULL COMMENT '试题ID',
  `score` double NOT NULL COMMENT '得分',
  `answer1` varchar(20) DEFAULT NULL COMMENT '第一题所填选项',
  `answer2` varchar(20) DEFAULT NULL COMMENT '第二题所填选项',
  `answer3` varchar(20) DEFAULT NULL COMMENT '第三题所填选项',
  `answer4` varchar(20) DEFAULT NULL COMMENT '第四题所填选项',
  `answer5` varchar(20) DEFAULT NULL COMMENT '第五题所填选项',
  PRIMARY KEY (`consumer_id`,`exam_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of grade
-- ----------------------------
INSERT INTO `grade` VALUES ('1000', '5000', '20', '正确', '正确', '炸鸡腿', '钙和锌同时补', '骨头汤');

-- ----------------------------
-- Table structure for ident
-- ----------------------------
DROP TABLE IF EXISTS `ident`;
CREATE TABLE `ident` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `consumer_id` bigint(20) NOT NULL COMMENT '普通用户ID',
  `commodity_name` varchar(40) NOT NULL COMMENT '商品名称',
  `style` varchar(20) DEFAULT NULL COMMENT '商品样式',
  `count` bigint(20) NOT NULL COMMENT '商品数量',
  `payment` double NOT NULL COMMENT '支付金额',
  `pay_time` varchar(40) NOT NULL COMMENT '支付日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6022 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of ident
-- ----------------------------
INSERT INTO `ident` VALUES ('6000', '1000', '尚迩丝奶瓶', '红色', '1', '20', '2020-12-20 11:31:42');
INSERT INTO `ident` VALUES ('6001', '1000', '尚迩丝奶瓶', '粉色', '1', '20', '2020-12-17 14:32:34');
INSERT INTO `ident` VALUES ('6002', '1000', '尚迩丝奶瓶', '蓝色', '1', '20', '2020-12-17 15:07:46');
INSERT INTO `ident` VALUES ('6003', '1000', '美奈斯折叠婴儿车', '蓝色', '1', '130', '2020-12-17 15:19:55');
INSERT INTO `ident` VALUES ('6004', '1000', '尚迩丝奶瓶', '蓝色', '1', '20', '2020-12-17 16:29:36');
INSERT INTO `ident` VALUES ('6005', '1000', '运智贝玻璃奶瓶', '红色', '2', '74', '2020-12-17 16:29:36');
INSERT INTO `ident` VALUES ('6006', '1000', '飞利浦新安怡奶瓶', '', '1', '55.9', '2020-12-18 10:36:35');
INSERT INTO `ident` VALUES ('6007', '1000', '飞利浦新安怡奶瓶', '', '2', '111.8', '2020-12-18 10:39:59');
INSERT INTO `ident` VALUES ('6008', '1000', '飞利浦新安怡奶瓶', '', '1', '55.9', '2020-12-18 10:45:10');
INSERT INTO `ident` VALUES ('6009', '1000', '飞利浦新安怡奶瓶', '', '1', '55.9', '2020-12-18 14:43:27');
INSERT INTO `ident` VALUES ('6011', '1000', '飞利浦新安怡奶瓶', '', '1', '55.9', '2020-12-18 14:54:31');
INSERT INTO `ident` VALUES ('6012', '1000', '米奇乐圆孔奶嘴', '', '4', '8', '2020-12-18 14:56:30');
INSERT INTO `ident` VALUES ('6013', '1000', '美奈斯折叠婴儿车', '蓝色', '2', '260', '2020-12-18 15:38:13');
INSERT INTO `ident` VALUES ('6014', '1000', '尚迩丝奶瓶', '蓝色', '2', '40', '2020-12-18 16:25:24');
INSERT INTO `ident` VALUES ('6015', '1000', '运智贝玻璃奶瓶', '红色', '1', '37', '2020-12-18 16:25:24');
INSERT INTO `ident` VALUES ('6016', '1000', '七田真胎教书', '', '1', '67', '2021-02-01 14:08:58');
INSERT INTO `ident` VALUES ('6017', '1000', '七田真胎教书', '', '1', '67', '2021-02-01 14:09:49');
INSERT INTO `ident` VALUES ('6018', '1000', '运智贝玻璃奶瓶', '红色', '1', '37', '2021-06-03 20:34:00');
INSERT INTO `ident` VALUES ('6019', '1000', '关山奶粉', '', '1', '106', '2021-06-03 20:34:00');
INSERT INTO `ident` VALUES ('6020', '1000', '尚迩丝奶瓶', '粉色', '1', '21', '2021-06-04 09:29:24');
INSERT INTO `ident` VALUES ('6021', '1000', '七田真胎教法', '', '1', '69', '2021-06-04 14:31:38');

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(10) NOT NULL COMMENT '管理员名字',
  `password` varchar(10) NOT NULL COMMENT '密码',
  `phone` bigint(13) DEFAULT NULL COMMENT '电话',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of manager
-- ----------------------------
INSERT INTO `manager` VALUES ('1', '小张', '123456', '15882058074', '2021-09-25 16:51:26');

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
  `id` bigint(20) NOT NULL COMMENT '月嫂ID',
  `wage` decimal(10,0) NOT NULL COMMENT '月嫂每日工资',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of salary
-- ----------------------------
INSERT INTO `salary` VALUES ('1', '200');
INSERT INTO `salary` VALUES ('2', '150');
INSERT INTO `salary` VALUES ('3', '170');
INSERT INTO `salary` VALUES ('4', '235');
INSERT INTO `salary` VALUES ('5', '220');
INSERT INTO `salary` VALUES ('6', '170');
INSERT INTO `salary` VALUES ('7', '185');
INSERT INTO `salary` VALUES ('8', '210');
INSERT INTO `salary` VALUES ('9', '350');
INSERT INTO `salary` VALUES ('13', '160');

-- ----------------------------
-- Table structure for sharing
-- ----------------------------
DROP TABLE IF EXISTS `sharing`;
CREATE TABLE `sharing` (
  `consumer_id` bigint(20) NOT NULL,
  `story_id` bigint(20) NOT NULL,
  `date` varchar(50) NOT NULL,
  PRIMARY KEY (`consumer_id`,`story_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of sharing
-- ----------------------------
INSERT INTO `sharing` VALUES ('1000', '5', '2021.1.6');
INSERT INTO `sharing` VALUES ('1000', '6', '2021.11.2');
INSERT INTO `sharing` VALUES ('1000', '7', '2021.11.2');
INSERT INTO `sharing` VALUES ('1000', '8', '2021.1.1');
INSERT INTO `sharing` VALUES ('1012', '3', '2021.1.3');
INSERT INTO `sharing` VALUES ('1012', '4', '2021.1.4');

-- ----------------------------
-- Table structure for story
-- ----------------------------
DROP TABLE IF EXISTS `story`;
CREATE TABLE `story` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` varchar(600) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of story
-- ----------------------------
INSERT INTO `story` VALUES ('3', '在怀孕初期，腹部还不大，此时怎么睡都可以。从怀孕中期开始，腹部一天天的增大了，睡觉的时候会受到子宫的压迫，很容易失 眠，因此建议采用左侧卧位睡觉，这样能睡得更香哦。');
INSERT INTO `story` VALUES ('4', '在孕早期，由于胎儿还不够稳定的缘故，建议不要进行x生活；而在孕中期，胎儿已经比较稳定了，早孕反应也过去，就可以适当的进行；在孕晚期也是可以的，只是要有节制。');
INSERT INTO `story` VALUES ('5', '通过胎动，可以得知宝宝是否健康。为了避免胎心胎动异常，妈妈要做到下面三点：一是要避免情绪波动过大，二要避免发烧生病，三要避免喝浓茶和咖啡。');
INSERT INTO `story` VALUES ('6', '孕妇也应该适当的锻炼身体，一些大幅度的活动是不能做的，身体允许的情况下可以做做孕妇瑜伽， 下载G动 进行盆底肌的锻炼，帮助孕妈顺利生产，预防产后漏尿。');
INSERT INTO `story` VALUES ('7', '爱美的孕妈妈还要学会保养，首先可以通过摄取营养来保养皮肤，当然也可以使用孕妇专用的护肤品，另外，沐浴露的选择也很重要，尤其是容易过敏的妈妈，还有就是要避免长时间的紫外线照射。');
INSERT INTO `story` VALUES ('8', '\n防辐射，电器太多，不得不防。不要住高楼，孕妇爬楼很累的，实在没办法的可以少下楼，适当走动。营养跟上，如果孕期反应很大的，吃不了东西的，可以买孕妈妈奶粉，不过要注意品牌');

-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '题目编号',
  `question` varchar(40) NOT NULL COMMENT '题目描述',
  `answer` varchar(10) NOT NULL COMMENT '正确答案',
  `type` bigint(20) NOT NULL COMMENT '题型 0表示判断题 1表示选择题',
  `affiliation` bigint(20) NOT NULL COMMENT '归属试题编号',
  `answer1` varchar(20) DEFAULT NULL COMMENT '选项一',
  `answer2` varchar(20) DEFAULT NULL COMMENT '选项二',
  `answer3` varchar(20) DEFAULT NULL COMMENT '选项3',
  `answer4` varchar(20) DEFAULT NULL COMMENT '选项四',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of topic
-- ----------------------------
INSERT INTO `topic` VALUES ('1', '可以用水果代替蔬菜', '错误', '0', '5000', null, null, null, null);
INSERT INTO `topic` VALUES ('2', '怀孕可以染发', '正确', '0', '5000', null, null, null, null);
INSERT INTO `topic` VALUES ('3', '准妈妈建议食用以下哪种食品', '燕麦片', '1', '5000', '炸鸡腿', '奶茶', '烧烤', '燕麦片');
INSERT INTO `topic` VALUES ('4', '关于元素钙和锌的补充', '钙和锌分开补', '1', '5000', '钙和锌同时补', '钙和锌分开补', '不用补锌', '不用补钙');
INSERT INTO `topic` VALUES ('5', '哪种食品补钙效果最佳', '钙片', '1', '5000', '骨头汤', '鱼', '牛奶', '钙片');
INSERT INTO `topic` VALUES ('6', '新生儿皮肤干燥是正常的么', '正确', '0', '5001', null, null, null, null);
INSERT INTO `topic` VALUES ('7', '宝宝应该多晒太阳', '错误', '0', '5001', null, null, null, null);
INSERT INTO `topic` VALUES ('8', '宝宝睡觉时间越长越好', '错误', '0', '5001', null, null, null, null);
INSERT INTO `topic` VALUES ('9', '以下哪项不是宝宝哭泣想表达的含义', '困了', '1', '5001', '困了', '寒冷', '尿湿', '饥饿');
INSERT INTO `topic` VALUES ('10', '宝宝睡觉哭泣的正确解决方式', '轻拍安抚', '1', '5001', '抱起来安抚', '轻拍安抚', '拿玩具逗', '摇晃宝宝');

-- ----------------------------
-- Table structure for writting
-- ----------------------------
DROP TABLE IF EXISTS `writting`;
CREATE TABLE `writting` (
  `id` bigint(20) NOT NULL COMMENT '短文编号',
  `expert_id` bigint(20) NOT NULL COMMENT '专家ID',
  `date` varchar(20) NOT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`,`expert_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of writting
-- ----------------------------
INSERT INTO `writting` VALUES ('3000', '2000', '2020-12-03 10:18:14');
INSERT INTO `writting` VALUES ('3001', '2000', '2020-12-03 12:18:14');
INSERT INTO `writting` VALUES ('3002', '2000', '2020-12-03 13:18:14');
INSERT INTO `writting` VALUES ('3003', '2000', '2020-12-04 10:18:14');
INSERT INTO `writting` VALUES ('3004', '2000', '2020-12-04 14:22:14');
INSERT INTO `writting` VALUES ('3005', '2001', '2020-12-04 15:18:14');
INSERT INTO `writting` VALUES ('3006', '2001', '2020-12-04 20:08:14');
INSERT INTO `writting` VALUES ('3007', '2000', '2020-12-04 21:18:14');
INSERT INTO `writting` VALUES ('3009', '2001', '2020-12-05 20:18:14');