text: /*
   Navicat Premium Data Transfer
  
   Source Server         : localhost
   Source Server Type    : MySQL
   Source Server Version : 50731
   Source Schema         : mybatis
  
   Target Server Type    : MySQL
   Target Server Version : 50731
   File Encoding         : 65001
  
   Date: 16/08/2020 12:02:36
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for tbl_user
  -- ----------------------------
  DROP TABLE IF EXISTS `tbl_user`;
  CREATE TABLE `tbl_user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
      `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
      `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
      `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
      `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
      `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
      `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
      PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for tbl_class
  -- ----------------------------
  DROP TABLE IF EXISTS `tbl_class`;
  CREATE TABLE `tbl_class`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '班级ID',
      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级名称',
      `grade` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '年级',
      PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for tbl_student
  -- ----------------------------
  DROP TABLE IF EXISTS `tbl_student`;
  CREATE TABLE `tbl_student`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生ID',
      `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '学生姓名',
      `age` int(3) NULL DEFAULT NULL COMMENT '年龄',
      `class_id` int(11) NOT NULL COMMENT '级别ID',
      PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '学生表' ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  