/*
Navicat MySQL Data Transfer

Source Server         : he
Source Server Version : 50636
Source Host           : localhost:3306
Source Database       : hlb

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

Date: 2024-06-28 13:13:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for answer
-- ----------------------------
DROP TABLE IF EXISTS `answer`;
CREATE TABLE `answer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `replayId` int(11) DEFAULT NULL,
  `commentId` int(11) NOT NULL,
  `answerTime` date NOT NULL,
  `content` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk8` (`userId`) USING BTREE,
  KEY `fk11` (`commentId`) USING BTREE,
  KEY `fk10` (`replayId`) USING BTREE,
  CONSTRAINT `fk10` FOREIGN KEY (`replayId`) REFERENCES `answer` (`id`),
  CONSTRAINT `fk11` FOREIGN KEY (`commentId`) REFERENCES `comment` (`id`),
  CONSTRAINT `fk8` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of answer
-- ----------------------------
INSERT INTO `answer` VALUES ('1', '2', null, '8', '2018-08-23', '真乖');
INSERT INTO `answer` VALUES ('2', '5', '1', '8', '2018-08-23', '好漂亮');
INSERT INTO `answer` VALUES ('3', '3', '2', '8', '2019-09-06', '我也喜欢。');
INSERT INTO `answer` VALUES ('5', '1', null, '8', '2019-09-07', '太爱了。');
INSERT INTO `answer` VALUES ('6', '1', null, '8', '2019-09-07', '我也喜欢。');
INSERT INTO `answer` VALUES ('7', '1', null, '11', '2019-09-07', '我也喜欢。');
INSERT INTO `answer` VALUES ('8', '17', null, '8', '2019-09-08', '我也喜欢。');
INSERT INTO `answer` VALUES ('9', '17', null, '8', '2019-09-08', '好漂亮');
INSERT INTO `answer` VALUES ('10', '17', null, '12', '2019-09-09', '我也喜欢。');
INSERT INTO `answer` VALUES ('11', '17', null, '11', '2019-09-09', '我也喜欢。');
INSERT INTO `answer` VALUES ('12', '1', null, '3', '2024-06-26', '453311');
INSERT INTO `answer` VALUES ('13', '1', null, '3', '2024-06-26', '基地啊司机的驾驶的集结地阿三基地啊家是基督教按时间嗲是基地啊家是低价啊是第几点击洒几滴静安寺嗲是基地啊是近代世界的i大家说大家时间嗲是基地啊家上帝哦哦就基地啊是基地啊家上帝啊世界第几啊是哦对基地啊世界第哦啊降低哦骄傲地哦交大急啊多久啊是大家基地啊家低价圣诞节哦i阿娇级大神单价单价较低哦奥军第九的教师基地啊家嗲基地啊实际上都i静安寺军第哦啊世界第哦啊降低哦哦阿姐、基地啊司机的驾驶的集结地阿三基地啊家是基督教按时间嗲是基地啊家是基地啊司机的驾驶的集结地阿三基地啊家是基督教按时间嗲是基地啊家是');