/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3306
 Source Schema         : springcloud

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 23/10/2024 10:21:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_city
-- ----------------------------
DROP TABLE IF EXISTS `t_city`;
CREATE TABLE `t_city`  (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_city
-- ----------------------------
INSERT INTO `t_city` VALUES (4, '北京');
INSERT INTO `t_city` VALUES (5, '南京');
INSERT INTO `t_city` VALUES (6, '天津');
INSERT INTO `t_city` VALUES (7, '杭州');
INSERT INTO `t_city` VALUES (8, '合肥');

-- ----------------------------
-- Table structure for t_clazz
-- ----------------------------
DROP TABLE IF EXISTS `t_clazz`;
CREATE TABLE `t_clazz`  (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `path` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tagId` int(40) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_clazz
-- ----------------------------
INSERT INTO `t_clazz` VALUES (10, '2010班', '/20210531170642.png', 13);
INSERT INTO `t_clazz` VALUES (14, 'java2219', '3315ca56d63b4d44a316319aa907fe91.png', 13);
INSERT INTO `t_clazz` VALUES (15, 'java2320', '3315ca56d63b4d44a316319aa907fe91.png', 13);
INSERT INTO `t_clazz` VALUES (18, '测试班级', 'dfdf1c8e478740d4911e815a822568d2.png', 13);

-- ----------------------------
-- Table structure for t_group
-- ----------------------------
DROP TABLE IF EXISTS `t_group`;
CREATE TABLE `t_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createDate` date NULL DEFAULT NULL,
  `clazzId` int(30) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_group
-- ----------------------------
INSERT INTO `t_group` VALUES (5, '1组', '2021-05-31', 11);
INSERT INTO `t_group` VALUES (6, '2组', '2021-05-31', 10);
INSERT INTO `t_group` VALUES (7, '3组', '2023-01-12', 11);
INSERT INTO `t_group` VALUES (10, '2组', '2023-04-29', 13);
INSERT INTO `t_group` VALUES (11, '第三组', '2023-07-08', 11);
INSERT INTO `t_group` VALUES (12, '第一组', '2023-09-12', 15);
INSERT INTO `t_group` VALUES (13, '4组', '2024-05-09', 11);
INSERT INTO `t_group` VALUES (15, '1组', '2024-07-31', 10);

-- ----------------------------
-- Table structure for t_student
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student`  (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(3) NULL DEFAULT NULL,
  `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `bir` date NULL DEFAULT NULL,
  `starts` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mark` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clazzId` int(11) NULL DEFAULT NULL,
  `groupId` int(11) NULL DEFAULT NULL,
  `cityId` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_student
-- ----------------------------
INSERT INTO `t_student` VALUES (15, '张三', 22, '123456', '1376665432', '2000-12-12', '射手座', '龙', '测试数据', 10, 5, 4);
INSERT INTO `t_student` VALUES (16, 'tom', 0, '88888888', '1234567', '2022-08-08', '狮子座', '虎', '测试备注', 10, 5, 19);
INSERT INTO `t_student` VALUES (17, 'xiaoming', 11, '344355', '01010533789', '2012-12-11', '射手座', '龙', '测试', 11, 5, 4);
INSERT INTO `t_student` VALUES (18, 'tom', 11, '344355@qq.com', '01010533789', '2012-12-12', '射手座', '龙', '测试备注', 11, 5, 4);
INSERT INTO `t_student` VALUES (19, 'xiaohei', 0, '123456@qq.com', '1561226544', '2023-04-29', '金牛座', '兔', '测试', 13, 5, 19);
INSERT INTO `t_student` VALUES (20, '张三', 24, '123456@qq.com', '1376665432', '2000-12-12', '射手座', '龙', '测试学生数据添加', 10, 5, 4);
INSERT INTO `t_student` VALUES (21, '张三', 24, '123456', '1376665432', '2000-12-12', '射手座', '龙', '测试数据', 10, 5, 4);

-- ----------------------------
-- Table structure for t_student_tag
-- ----------------------------
DROP TABLE IF EXISTS `t_student_tag`;
CREATE TABLE `t_student_tag`  (
  `sid` int(40) NOT NULL,
  `tid` int(40) NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_student_tag
-- ----------------------------
INSERT INTO `t_student_tag` VALUES (15, 16);
INSERT INTO `t_student_tag` VALUES (15, 17);
INSERT INTO `t_student_tag` VALUES (16, 13);
INSERT INTO `t_student_tag` VALUES (16, 14);
INSERT INTO `t_student_tag` VALUES (16, 15);
INSERT INTO `t_student_tag` VALUES (17, 16);
INSERT INTO `t_student_tag` VALUES (17, 17);
INSERT INTO `t_student_tag` VALUES (18, 3);
INSERT INTO `t_student_tag` VALUES (18, 16);
INSERT INTO `t_student_tag` VALUES (19, 3);
INSERT INTO `t_student_tag` VALUES (19, 6);
INSERT INTO `t_student_tag` VALUES (20, 16);
INSERT INTO `t_student_tag` VALUES (20, 17);
INSERT INTO `t_student_tag` VALUES (20, 23);
INSERT INTO `t_student_tag` VALUES (21, 3);
INSERT INTO `t_student_tag` VALUES (21, 6);
INSERT INTO `t_student_tag` VALUES (21, 16);

-- ----------------------------
-- Table structure for t_tag
-- ----------------------------
DROP TABLE IF EXISTS `t_tag`;
CREATE TABLE `t_tag`  (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createDate` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_tag
-- ----------------------------
INSERT INTO `t_tag` VALUES (3, '帅哥', '学生', '2021-05-24');
INSERT INTO `t_tag` VALUES (4, '美女', '学生', '2021-05-24');
INSERT INTO `t_tag` VALUES (6, '学渣', '学生', '2021-05-24');
INSERT INTO `t_tag` VALUES (13, '人数最多', '班级', '2021-05-31');
INSERT INTO `t_tag` VALUES (14, '坚持不懈', '班级', '2021-05-31');
INSERT INTO `t_tag` VALUES (15, '勤学好问', '班级', '2021-05-31');
INSERT INTO `t_tag` VALUES (16, '聪明', '学生', '2021-05-31');
INSERT INTO `t_tag` VALUES (17, '浪漫', '学生', '2021-05-31');
INSERT INTO `t_tag` VALUES (23, '三好学生', '学生', '2023-09-11');
INSERT INTO `t_tag` VALUES (24, '测试标签', '测试类型', '2024-07-30');

SET FOREIGN_KEY_CHECKS = 1;