MyBatis_02_开发环境搭建_04_创建数据库表结构

CREATE DATABASE /*!32312 IF NOT EXISTS*/`school` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `school`;

/*Table structure for table `school_class_tbl` */

DROP TABLE IF EXISTS `school_class_tbl`;

CREATE TABLE `school_class_tbl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `class_name` varchar(50) DEFAULT NULL,
  `teacher_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `school_class_tbl` */

/*Table structure for table `school_student_tbl` */

DROP TABLE IF EXISTS `school_student_tbl`;

CREATE TABLE `school_student_tbl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(50) DEFAULT NULL,
  `sex` tinyint(4) DEFAULT NULL,
  `birthday` varchar(50) DEFAULT NULL,
  `height` double DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `class_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `school_student_tbl` */

/*Table structure for table `school_teacher_tbl` */

DROP TABLE IF EXISTS `school_teacher_tbl`;

CREATE TABLE `school_teacher_tbl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `teacher_name` varchar(50) DEFAULT NULL,
  `sex` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;