-- ----------------------------
-- Table structure for dim_class
-- ----------------------------
DROP TABLE IF EXISTS `dim_class`;
CREATE TABLE `dim_class` (
                             `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
                             `class_name` varchar(50) NOT NULL COMMENT '班级名',
                             `class_person_number` int(11) DEFAULT NULL COMMENT '班级人数',
                             `course_name` varchar(200) NOT NULL COMMENT '课程名',
                             `course_type` int(11) DEFAULT NULL COMMENT '课程类型：1本科,2研究生,3其它',
                             `teacher_id` bigint(20) DEFAULT NULL COMMENT '老师id',
                             `term_id` bigint(20) DEFAULT NULL COMMENT '学期学年id',
                             `create_time` datetime DEFAULT NULL COMMENT '建立时间',
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of dim_class
-- ----------------------------
INSERT INTO `dim_class` VALUES ('1', '16计算机', '50', '中间件技术', '2', '1', '1', '2019-03-25 00:00:00');
INSERT INTO `dim_class` VALUES ('6', '16物联网', '40', 'Web开发技术', '1', '1', '2', '2019-03-26 00:00:00');
INSERT INTO `dim_class` VALUES ('7', '2016计算机', '61', '中间件', '1', '2', '1', '2019-04-16 00:00:00');
INSERT INTO `dim_class` VALUES ('8', '16级物联网', '40', 'WEB开发技术', '1', '2', '1', '2019-04-22 14:38:32');

-- ----------------------------
-- Table structure for dim_lab
-- ----------------------------
DROP TABLE IF EXISTS `dim_lab`;
CREATE TABLE `dim_lab` (
                           `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
                           `lab_name` varchar(50) DEFAULT NULL COMMENT '实验室名称',
                           `mc_number` int(11) DEFAULT NULL COMMENT '编号',
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of dim_lab
-- ----------------------------
INSERT INTO `dim_lab` VALUES ('1', '304', '23');

-- ----------------------------
-- Table structure for dim_lab_project
-- ----------------------------
DROP TABLE IF EXISTS `dim_lab_project`;
CREATE TABLE `dim_lab_project` (
                                   `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                   `course_name` varchar(255) DEFAULT NULL COMMENT '课程名',
                                   `course_project` varchar(255) DEFAULT NULL COMMENT '项目名',
                                   `project_index` int(255) DEFAULT NULL COMMENT '项目的顺序',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of dim_lab_project
-- ----------------------------
INSERT INTO `dim_lab_project` VALUES ('1', '多媒体技术基础', 'photoshop初探1', '1');
INSERT INTO `dim_lab_project` VALUES ('2', '多媒体技术基础', 'html5画布基础', '2');
INSERT INTO `dim_lab_project` VALUES ('3', 'WEB开发技术', 'html5', '1');

-- ----------------------------
-- Table structure for dim_term
-- ----------------------------
DROP TABLE IF EXISTS `dim_term`;
CREATE TABLE `dim_term` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
                            `name` varchar(50) DEFAULT NULL COMMENT '学期学年名',
                            `year` int(11) DEFAULT NULL COMMENT '年代',
                            `start_date` datetime DEFAULT NULL COMMENT '第一周的周一是什么日期',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of dim_term
-- ----------------------------
INSERT INTO `dim_term` VALUES ('1', '2018-2019年第二学期', '2019', '2019-02-25 00:00:00');
INSERT INTO `dim_term` VALUES ('2', '2019-2020年第一学期', '2019', null);
INSERT INTO `dim_term` VALUES ('3', '2019-2020年第二学期', '2020', null);
INSERT INTO `dim_term` VALUES ('4', '2020-2021年第一学期', '2020', null);

-- ----------------------------
-- Table structure for lab_log_info
-- ----------------------------
DROP TABLE IF EXISTS `lab_log_info`;
CREATE TABLE `lab_log_info` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `class_id` bigint(20) NOT NULL COMMENT '班级id,包括了学期，老师,课程',
                                `lab_id` bigint(20) DEFAULT NULL COMMENT '实验室id',
                                `project_name` varchar(200) NOT NULL COMMENT '项目名称',
                                `section_from` int(11) DEFAULT NULL COMMENT '开始节次',
                                `section_to` int(11) DEFAULT NULL COMMENT '结束节次',
                                `content` varchar(4000) DEFAULT NULL COMMENT '内容(2000字以内)',
                                `week` int(11) DEFAULT NULL COMMENT '第几周',
                                `day_of_week` int(11) DEFAULT NULL COMMENT '星期几',
                                `course_time` datetime DEFAULT NULL COMMENT '课程时间',
                                `request_type` varchar(255) DEFAULT NULL COMMENT '实验要求,1必须,2选修,3其它',
                                `lab_type` int(11) DEFAULT NULL COMMENT '实验类型,1演示,2验证,3综合,4设计,5其它',
                                `create_time` datetime DEFAULT NULL COMMENT '建立时间',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of lab_log_info
-- ----------------------------
INSERT INTO `lab_log_info` VALUES ('1', '1', '1', 'HTML入门', '3', '4', 'HTML的标签\r\n这是第二行\r\n这是第三行', '1', '2', '2019-04-01 00:00:00', '2', '2', '2019-04-01 00:00:00');
INSERT INTO `lab_log_info` VALUES ('2', '7', '1', '常用中间件', '3', '4', 'test', '1', '2', '2019-04-22 14:29:04', '2', '2', '2019-04-22 14:29:09');
INSERT INTO `lab_log_info` VALUES ('3', '7', '1', 'ab', '2', '3', '', '2', '2', null, '2', '2', '2019-04-22 21:48:11');
INSERT INTO `lab_log_info` VALUES ('4', '7', '1', 'test3', '5', '6', 'testadfsafdsa', '2', '3', null, '2', '2', '2019-04-22 21:55:17');
INSERT INTO `lab_log_info` VALUES ('5', '8', '1', 'web1', '2', '2', 'd', '9', '3', '2019-04-24 00:00:00', '2', '2', '2019-04-25 10:47:01');