/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50723
Source Host           : localhost:3306
Source Database       : ctbujsj

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

Date: 2018-11-22 16:03:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tb_area`
-- ----------------------------
DROP TABLE IF EXISTS `tb_area`;
CREATE TABLE `tb_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `area_name` varchar(50) DEFAULT NULL COMMENT '地区名',
  `area_code` varchar(16) DEFAULT NULL COMMENT '地区代码',
  `parent_id` int(11) DEFAULT NULL COMMENT '父节点',
  `level` int(11) DEFAULT NULL COMMENT '等级',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_area
-- ----------------------------
INSERT INTO `tb_area` VALUES ('1', '重庆', '400000', '0', '1');
INSERT INTO `tb_area` VALUES ('2', '四川', '600000', '0', '1');
INSERT INTO `tb_area` VALUES ('3', '南岸区', '400000', '1', '2');
INSERT INTO `tb_area` VALUES ('4', '渝中区', '400000', '1', '2');
INSERT INTO `tb_area` VALUES ('5', '成都', '600100', '2', '2');
INSERT INTO `tb_area` VALUES ('6', '绵阳市', '600600', '2', '2');

-- ----------------------------
-- Table structure for `tb_class`
-- ----------------------------
DROP TABLE IF EXISTS `tb_class`;
CREATE TABLE `tb_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `grade` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_class
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_student`
-- ----------------------------
DROP TABLE IF EXISTS `tb_student`;
CREATE TABLE `tb_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `true_name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL,
  `birthday` datetime DEFAULT NULL,
  `class_name` varchar(255) DEFAULT NULL,
  `classid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_student
-- ----------------------------
INSERT INTO `tb_student` VALUES ('1', '李四', '李武', '234', '2', '2018-11-02 20:02:39', '16计算机', '1');
INSERT INTO `tb_student` VALUES ('2', '王二', '王二', '326', '1', '2018-11-15 22:21:05', '16计算机', '2');
INSERT INTO `tb_student` VALUES ('3', '张三', '张二', '123', '1', '2018-11-02 20:01:04', '16计算机', '2');