CREATE TABLE `clazz_student` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `age` int(1) DEFAULT '0' COMMENT '年龄',
  `gender` int(1) DEFAULT '0' COMMENT '性别',
  `class_no` varchar(10) DEFAULT NULL COMMENT '班级',
  `invalid` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `clazz` (
  `id` varchar(32) NOT NULL,
  `class_no` varchar(10) DEFAULT NULL COMMENT '班级',
  `headmaster` varchar(20) DEFAULT NULL COMMENT '班主任',
  `invalid` int(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;