ZdSoft.TCE
/
tecsystem2.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : tecsystem2

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

Date: 2017-11-20 16:05:40
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `classes`
-- ----------------------------
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` varchar(50) NOT NULL,
  `ClassNumber` int(11) NOT NULL,
  `DepartMentId` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `DepartMentId` (`DepartMentId`),
  CONSTRAINT `classes_ibfk_1` FOREIGN KEY (`DepartMentId`) REFERENCES `department` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of classes
-- ----------------------------
INSERT INTO `classes` VALUES ('1', 'JAVA1', '1490001', '1');
INSERT INTO `classes` VALUES ('2', 'JAVA2', '1490002', '1');
INSERT INTO `classes` VALUES ('3', 'JAVA3', '1490003', '1');
INSERT INTO `classes` VALUES ('4', 'JAVA4', '1490004', '1');
INSERT INTO `classes` VALUES ('5', 'JAVA5', '1490005', '1');
INSERT INTO `classes` VALUES ('6', 'JAVA6', '1490006', '1');
INSERT INTO `classes` VALUES ('7', 'C#', '1490007', '1');
INSERT INTO `classes` VALUES ('8', 'C#', '1490008', '1');

-- ----------------------------
-- Table structure for `department`
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DepartMentName` varchar(50) NOT NULL,
  `DepartMentNumber` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('1', '软件学院', '149000');
INSERT INTO `department` VALUES ('2', '电子信息学院', '149001');
INSERT INTO `department` VALUES ('3', '传媒艺术学院', '149002');
INSERT INTO `department` VALUES ('4', '管理学院', '149003');

-- ----------------------------
-- Table structure for `evaluate`
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `StartTime` datetime NOT NULL,
  `EndTime` datetime NOT NULL,
  `TeacherID` int(11) NOT NULL COMMENT '璇勪环鏁欏笀鐨処D',
  `RoleID` int(11) NOT NULL,
  `TargetID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `TeacherID` (`TeacherID`),
  KEY `RoleID` (`RoleID`),
  KEY `TargetID` (`TargetID`),
  CONSTRAINT `evaluate_ibfk_1` FOREIGN KEY (`TeacherID`) REFERENCES `users` (`ID`),
  CONSTRAINT `evaluate_ibfk_2` FOREIGN KEY (`RoleID`) REFERENCES `role` (`ID`),
  CONSTRAINT `evaluate_ibfk_3` FOREIGN KEY (`TargetID`) REFERENCES `target` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of evaluate
-- ----------------------------
INSERT INTO `evaluate` VALUES ('1', '2017-11-02 00:00:00', '2017-11-04 00:00:00', '3', '2', '3');
INSERT INTO `evaluate` VALUES ('2', '2017-11-02 00:00:00', '2017-11-04 00:00:00', '3', '2', '4');
INSERT INTO `evaluate` VALUES ('3', '2017-11-02 00:00:00', '2017-11-04 00:00:00', '3', '2', '5');
INSERT INTO `evaluate` VALUES ('4', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '3');
INSERT INTO `evaluate` VALUES ('5', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '4');
INSERT INTO `evaluate` VALUES ('6', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '5');
INSERT INTO `evaluate` VALUES ('7', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '6');
INSERT INTO `evaluate` VALUES ('8', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '7');
INSERT INTO `evaluate` VALUES ('9', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '8');
INSERT INTO `evaluate` VALUES ('10', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '9');
INSERT INTO `evaluate` VALUES ('11', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '10');
INSERT INTO `evaluate` VALUES ('12', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '11');
INSERT INTO `evaluate` VALUES ('13', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '12');
INSERT INTO `evaluate` VALUES ('14', '2017-11-19 00:00:00', '2017-11-22 00:00:00', '5', '2', '68');

-- ----------------------------
-- Table structure for `evaluationresult`
-- ----------------------------
DROP TABLE IF EXISTS `evaluationresult`;
CREATE TABLE `evaluationresult` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UsersID` int(11) NOT NULL,
  `EvaluateID` int(11) NOT NULL,
  `TotalResult` float(53,2) NOT NULL COMMENT '鎬诲垎',
  PRIMARY KEY (`ID`),
  KEY `UsersID` (`UsersID`) USING BTREE,
  KEY `TargetID` (`EvaluateID`) USING BTREE,
  CONSTRAINT `evaluationresult_ibfk_1` FOREIGN KEY (`UsersID`) REFERENCES `users` (`ID`),
  CONSTRAINT `evaluationresult_ibfk_2` FOREIGN KEY (`EvaluateID`) REFERENCES `evaluate` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of evaluationresult
-- ----------------------------
INSERT INTO `evaluationresult` VALUES ('1', '3', '1', '1.00');
INSERT INTO `evaluationresult` VALUES ('2', '3', '2', '1.00');
INSERT INTO `evaluationresult` VALUES ('3', '3', '3', '1.00');

-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `MenuName` varchar(50) NOT NULL,
  `ControllerName` varchar(50) NOT NULL,
  `ClassName` varchar(50) NOT NULL,
  `ParentID` int(11) DEFAULT NULL,
  `IsActive` bit(1) NOT NULL,
  `MenuUrl` varchar(100) NOT NULL,
  `Idx` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `ParentID` (`ParentID`),
  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`ParentID`) REFERENCES `menu` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '系统管理', 'Home', 'ZdSoft.TEC.Web.Controllers.HomeController', null, '', 'Index', '0');
INSERT INTO `menu` VALUES ('2', '角色管理', 'Role', 'ZdSoft.TEC.Web.Controllers.RoleController', '1', '', 'Index', '0');
INSERT INTO `menu` VALUES ('3', '用户管理', 'Users', 'ZdSoft.TEC.Web.Controllers.UsersController', '1', '', 'Index', '0');
INSERT INTO `menu` VALUES ('4', '班级管理', 'Classes', 'ZdSoft.TEC.Web.Controllers.ClassesController', null, '', 'Index', '0');
INSERT INTO `menu` VALUES ('5', '部门管理', 'Department', 'ZdSoft.TEC.Web.Controllers.DepartmentController', null, '', 'Index', '0');
INSERT INTO `menu` VALUES ('6', '评价管理', 'Evaluate', 'ZdSoft.TEC.Web.Controllers.EvaluateController', null, '', 'Index', '0');
INSERT INTO `menu` VALUES ('7', '指标管理', 'Target', 'ZdSoft.TEC.Web.Controllers.TargetController', null, '', 'Index', '0');
INSERT INTO `menu` VALUES ('8', '我的评价', '', '', null, '', '', '0');
INSERT INTO `menu` VALUES ('9', '添加评价表', 'Evaluate', 'ZdSoft.TEC.Web.Controllers.EvaluateController', '7', '', 'Create', '0');
INSERT INTO `menu` VALUES ('10', '未评价', 'UserEvaluate', 'ZdSoft.TEC.Web.Controllers.UserEvaluateController', '8', '', 'Index', '0');
INSERT INTO `menu` VALUES ('11', '评价结果', '', '', '8', '', '', '0');
INSERT INTO `menu` VALUES ('12', '其他', '', '', null, '', '', '0');
INSERT INTO `menu` VALUES ('13', '统计评价', '', '', '6', '', '', '0');
INSERT INTO `menu` VALUES ('14', '修改资料', 'Users', 'ZdSoft.TEC.Web.Controllers.UsersController', '12', '', 'EditThis', '0');
INSERT INTO `menu` VALUES ('15', '退出登录', 'Users', 'ZdSoft.TEC.Web.Controllers.UsersController', '12', '', 'Exite', '0');

-- ----------------------------
-- Table structure for `option`
-- ----------------------------
DROP TABLE IF EXISTS `option`;
CREATE TABLE `option` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `OptionName` varchar(50) NOT NULL,
  `Weight` float(53,2) NOT NULL,
  `TargetID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `TargetID` (`TargetID`),
  CONSTRAINT `TargetID` FOREIGN KEY (`TargetID`) REFERENCES `target` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=220 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of option
-- ----------------------------
INSERT INTO `option` VALUES ('1', '语言精练，深入浅出，讲解明确', '1.00', '3');
INSERT INTO `option` VALUES ('2', '讲解清晰，容易接受', '0.85', '3');
INSERT INTO `option` VALUES ('3', '讲解基本准确，但不易接受', '0.65', '3');
INSERT INTO `option` VALUES ('4', '概念紊乱，时有差错', '0.45', '3');
INSERT INTO `option` VALUES ('5', '重点突出，讲清难点，举一反三', '1.00', '4');
INSERT INTO `option` VALUES ('6', '能把握重点、难点，但讲解不够明确', '0.85', '4');
INSERT INTO `option` VALUES ('7', '重点不明显，难点讲不透', '0.65', '4');
INSERT INTO `option` VALUES ('8', '重点一言而过，难点草率了事', '0.45', '4');
INSERT INTO `option` VALUES ('9', '层次分明，融会贯通', '1.00', '5');
INSERT INTO `option` VALUES ('10', '条目较清楚，有分析归纳', '0.85', '5');
INSERT INTO `option` VALUES ('11', '平淡叙述，缺乏连贯性', '0.65', '5');
INSERT INTO `option` VALUES ('12', '杂乱无章，前后矛盾', '0.45', '5');
INSERT INTO `option` VALUES ('13', '讲解方法新颖，举例生动，有吸引力', '1.00', '6');
INSERT INTO `option` VALUES ('14', '讲解较熟练，语言通俗', '0.65', '6');
INSERT INTO `option` VALUES ('15', '讲解平淡，语言单调', '0.85', '6');
INSERT INTO `option` VALUES ('16', '讲解生疏，远离课题，语言枯燥', '0.45', '6');
INSERT INTO `option` VALUES ('17', '简繁适度，清楚醒目', '1.00', '7');
INSERT INTO `option` VALUES ('18', '条目明白，书写整洁', '0.85', '7');
INSERT INTO `option` VALUES ('19', '布局较差，详略失当', '0.65', '7');
INSERT INTO `option` VALUES ('20', '次序凌乱，书写潦草', '0.45', '7');
INSERT INTO `option` VALUES ('21', '辅导及时、并指导课外阅读', '1.00', '8');
INSERT INTO `option` VALUES ('22', '定期辅导，并布置课外阅读', '0.85', '8');
INSERT INTO `option` VALUES ('23', '辅导较少', '0.65', '8');
INSERT INTO `option` VALUES ('24', '没有辅导', '0.45', '8');
INSERT INTO `option` VALUES ('25', '选题得当，批改及时，注意讲评', '1.00', '9');
INSERT INTO `option` VALUES ('26', '作业适量，批改及时', '0.85', '9');
INSERT INTO `option` VALUES ('27', '作业量时轻时重，批改不够及时', '0.65', '9');
INSERT INTO `option` VALUES ('28', '选题随便，批改马虎', '0.45', '9');
INSERT INTO `option` VALUES ('29', '思路开阔，鼓励创新，注意能力培养、效果明显', '1.00', '10');
INSERT INTO `option` VALUES ('30', '注意学生能力培养，并在教学中有所体现', '0.85', '10');
INSERT INTO `option` VALUES ('31', '能提出能力培养的要求，但缺乏具体的办法', '0.65', '10');
INSERT INTO `option` VALUES ('32', '忽视能力培养，单纯灌输书本知识', '0.45', '10');
INSERT INTO `option` VALUES ('33', '全面关心学生，经常接触学生，亲切、严格', '1.00', '11');
INSERT INTO `option` VALUES ('34', '关心学生的学业，引导学生学好本门课程', '0.85', '11');
INSERT INTO `option` VALUES ('35', '单纯完成上课任务，与同学接触较少', '0.65', '11');
INSERT INTO `option` VALUES ('36', '对学生漠不关心，放任自流', '0.45', '11');
INSERT INTO `option` VALUES ('38', '严于律己，以身作则，堪称楷模', '1.00', '12');
INSERT INTO `option` VALUES ('39', '举止文明，待人热情', '0.85', '12');
INSERT INTO `option` VALUES ('40', '注意礼貌，待人和气', '0.65', '12');
INSERT INTO `option` VALUES ('41', '要求不严，言谈失当', '0.45', '12');
INSERT INTO `option` VALUES ('42', '教学组织安排得当，气氛活跃，纪律良好', '1.00', '13');
INSERT INTO `option` VALUES ('43', '注意学生动态，教学有条不紊', '0.85', '13');
INSERT INTO `option` VALUES ('44', '忽视教学步骤，师生双边活动较差', '0.65', '13');
INSERT INTO `option` VALUES ('45', '只顾自己讲，不管学生情况', '0.45', '13');
INSERT INTO `option` VALUES ('46', '切合教学大纲要求与实际，内容组织科学严密', '1.00', '14');
INSERT INTO `option` VALUES ('47', '符合教学大纲要求，内容正确', '0.85', '14');
INSERT INTO `option` VALUES ('48', '基本达到教学大纲要求，内容偶有差错', '0.65', '14');
INSERT INTO `option` VALUES ('49', '降低教学标准，内容时有差错', '0.45', '14');
INSERT INTO `option` VALUES ('50', '语言精练，深入浅出，讲解准确', '1.00', '15');
INSERT INTO `option` VALUES ('51', '讲解清晰，容易接受', '0.85', '15');
INSERT INTO `option` VALUES ('52', '讲解基本准确，但不易接受', '0.65', '15');
INSERT INTO `option` VALUES ('53', '概念紊乱，时有差错', '0.45', '15');
INSERT INTO `option` VALUES ('54', '重点突出，讲清难点，举一反三', '1.00', '16');
INSERT INTO `option` VALUES ('55', '能把握重点、难点，但讲解不够明确', '0.85', '16');
INSERT INTO `option` VALUES ('56', '重点不明显，难点讲不透', '0.65', '16');
INSERT INTO `option` VALUES ('57', '重点一言而过，难点草率了事', '0.45', '16');
INSERT INTO `option` VALUES ('58', '讲解方法新颖，举例生动，有吸引力', '1.00', '17');
INSERT INTO `option` VALUES ('59', '讲解较熟练，语言通俗', '0.85', '17');
INSERT INTO `option` VALUES ('60', '讲解平淡，语言单调', '0.65', '17');
INSERT INTO `option` VALUES ('61', '讲解生疏，远离课题，语言枯燥', '0.45', '17');
INSERT INTO `option` VALUES ('62', '教具使用合理，板书清晰，示教形象、直观', '1.00', '18');
INSERT INTO `option` VALUES ('63', '注意直观教学，板书条目明白、整洁', '0.85', '18');
INSERT INTO `option` VALUES ('64', '教具使用失当，板书布局较差', '0.65', '18');
INSERT INTO `option` VALUES ('65', '忽视直观教学，板书凌乱', '0.45', '18');
INSERT INTO `option` VALUES ('66', '运用各种方法，调动学生积极思维，注重能力培养', '1.00', '19');
INSERT INTO `option` VALUES ('67', '注意调动学生思维和能力培养，方法和效果欠佳', '0.85', '19');
INSERT INTO `option` VALUES ('68', '缺乏启发式方法和能力培养手段', '0.65', '19');
INSERT INTO `option` VALUES ('69', '照本宣科，不搞启发式教学', '0.45', '19');
INSERT INTO `option` VALUES ('70', '理论与实例、实验、实际密切结合', '1.00', '20');
INSERT INTO `option` VALUES ('71', '理论能结合实际进行教学', '0.85', '20');
INSERT INTO `option` VALUES ('72', '理论与实际结合不理想', '0.65', '20');
INSERT INTO `option` VALUES ('73', '理论与实际严重脱节', '0.45', '20');
INSERT INTO `option` VALUES ('74', '科学的处理教材，繁简增删适当，收事半功倍之效', '1.00', '21');
INSERT INTO `option` VALUES ('75', '对教材的处理，有助于学生理解和掌握内在联系', '0.85', '21');
INSERT INTO `option` VALUES ('76', '基本按照教材讲课，没有给学生什么新东西', '0.65', '21');
INSERT INTO `option` VALUES ('77', '对教材毫无处理，完全重复课本内容', '0.45', '21');
INSERT INTO `option` VALUES ('78', '语言精练，深入浅出，讲解准确', '1.00', '23');
INSERT INTO `option` VALUES ('79', '讲解清晰，容易接受', '0.85', '23');
INSERT INTO `option` VALUES ('80', '讲解基本准确，但不易接受', '0.65', '23');
INSERT INTO `option` VALUES ('81', '概念紊乱，时有差错', '0.45', '23');
INSERT INTO `option` VALUES ('82', '重点突出，讲清难点，举一反三', '1.00', '24');
INSERT INTO `option` VALUES ('83', '能把握重点、难点，但讲解不够明确', '0.85', '24');
INSERT INTO `option` VALUES ('84', '重点不明显，难点讲不透', '0.65', '24');
INSERT INTO `option` VALUES ('85', '重点一言而过，难点草率了事', '0.45', '24');
INSERT INTO `option` VALUES ('86', '层次分明，融会贯通', '1.00', '25');
INSERT INTO `option` VALUES ('87', '条目较清楚，有分析归纳', '0.85', '25');
INSERT INTO `option` VALUES ('88', '平淡叙述，缺乏连贯性', '0.65', '25');
INSERT INTO `option` VALUES ('89', '杂乱无章，前后矛盾', '0.45', '25');
INSERT INTO `option` VALUES ('90', '讲解方法新颖，举例生动，有吸引力', '1.00', '26');
INSERT INTO `option` VALUES ('91', '讲解较熟练，语言通俗', '0.85', '26');
INSERT INTO `option` VALUES ('92', '讲解平淡，语言单调', '0.65', '26');
INSERT INTO `option` VALUES ('93', '讲解生疏，远离课题，语言枯燥', '0.45', '26');
INSERT INTO `option` VALUES ('94', '简繁适度，清楚醒目', '1.00', '27');
INSERT INTO `option` VALUES ('95', '条目明白，书写整洁', '0.85', '27');
INSERT INTO `option` VALUES ('96', '布局较差，详略适当', '0.65', '27');
INSERT INTO `option` VALUES ('97', '次序凌乱，书写潦草', '0.45', '27');
INSERT INTO `option` VALUES ('98', '思路开阔，鼓励创新，注意能力培养、效果明显', '1.00', '28');
INSERT INTO `option` VALUES ('99', '注意学生能力培养，并在教学中有所体现', '0.85', '28');
INSERT INTO `option` VALUES ('100', '能提出能力培养的要求，但缺乏具体的办法', '0.65', '28');
INSERT INTO `option` VALUES ('101', '忽视能力培养，单纯灌输书本知识', '0.45', '28');
INSERT INTO `option` VALUES ('102', '理论紧密联系当前实际', '1.00', '29');
INSERT INTO `option` VALUES ('103', '理论能联系具体事例', '0.85', '29');
INSERT INTO `option` VALUES ('104', '联系实际较勉强', '0.65', '29');
INSERT INTO `option` VALUES ('105', '只有理论没有实际', '0.45', '29');
INSERT INTO `option` VALUES ('106', '辅导及时、并指导课外阅读', '1.00', '30');
INSERT INTO `option` VALUES ('107', '定期辅导，并布置课外阅读', '0.85', '30');
INSERT INTO `option` VALUES ('108', '辅导较少', '0.65', '30');
INSERT INTO `option` VALUES ('109', '没有辅导', '0.45', '30');
INSERT INTO `option` VALUES ('110', '选题得当，批改及时，注意讲评', '1.00', '31');
INSERT INTO `option` VALUES ('111', '作业适量，批改及时', '0.85', '31');
INSERT INTO `option` VALUES ('112', '作业量时轻时重，批改不够及时', '0.65', '31');
INSERT INTO `option` VALUES ('113', '选题随便，批改马虎', '0.45', '31');
INSERT INTO `option` VALUES ('114', '勇挑重担', '1.00', '32');
INSERT INTO `option` VALUES ('115', '主动承担', '0.85', '32');
INSERT INTO `option` VALUES ('116', '一    般', '0.65', '32');
INSERT INTO `option` VALUES ('117', '较    差', '0.45', '32');
INSERT INTO `option` VALUES ('118', '及时在教学中体现', '1.00', '33');
INSERT INTO `option` VALUES ('119', '教学中注意联系新信息新技术', '0.85', '33');
INSERT INTO `option` VALUES ('120', '教学中联系新信息新技术不够', '0.65', '33');
INSERT INTO `option` VALUES ('121', '教学中根本不联系新信息新技术', '0.45', '33');
INSERT INTO `option` VALUES ('122', '开出有一定水平的选修课、讲座、院级公开课或指导兴趣小组有成效', '1.00', '34');
INSERT INTO `option` VALUES ('123', '开出选修课、讲座、系内公开课或指导兴趣小组活动', '0.85', '34');
INSERT INTO `option` VALUES ('124', '承担室内研究课、协助开出讲座或配合指导学生课外活动', '0.65', '34');
INSERT INTO `option` VALUES ('125', '无', '0.45', '34');
INSERT INTO `option` VALUES ('126', '出主意、提建议、协助室主任搞好教研活动', '1.00', '35');
INSERT INTO `option` VALUES ('127', '积极参加讨论', '0.85', '35');
INSERT INTO `option` VALUES ('128', '能按时参加活动', '0.65', '35');
INSERT INTO `option` VALUES ('129', '参加活动不正常', '0.45', '35');
INSERT INTO `option` VALUES ('130', '超工作量', '1.00', '38');
INSERT INTO `option` VALUES ('131', '满工作量', '0.85', '38');
INSERT INTO `option` VALUES ('132', '接近完成（70%）', '0.65', '38');
INSERT INTO `option` VALUES ('133', '差距较大', '0.45', '38');
INSERT INTO `option` VALUES ('134', '担任教研室主任', '1.00', '39');
INSERT INTO `option` VALUES ('135', '担任办公室、工作室主任', '0.85', '39');
INSERT INTO `option` VALUES ('136', '担任专业班主任（辅导员）等其他工作', '0.65', '39');
INSERT INTO `option` VALUES ('137', '未承担', '0.45', '39');
INSERT INTO `option` VALUES ('138', '任4个班级以上，或双进度', '1.00', '40');
INSERT INTO `option` VALUES ('139', '任3个班级', '0.85', '40');
INSERT INTO `option` VALUES ('140', '任2个班级', '0.65', '40');
INSERT INTO `option` VALUES ('141', '任1个班级', '0.45', '40');
INSERT INTO `option` VALUES ('142', '勇挑重担', '1.00', '43');
INSERT INTO `option` VALUES ('143', '主动承担', '0.85', '43');
INSERT INTO `option` VALUES ('144', '一    般', '0.65', '43');
INSERT INTO `option` VALUES ('145', '较    差', '0.45', '43');
INSERT INTO `option` VALUES ('146', '清晰', '1.00', '45');
INSERT INTO `option` VALUES ('147', '完整', '0.85', '45');
INSERT INTO `option` VALUES ('148', '一般', '0.65', '45');
INSERT INTO `option` VALUES ('149', '潦草', '0.45', '45');
INSERT INTO `option` VALUES ('150', '完整', '1.00', '46');
INSERT INTO `option` VALUES ('151', '缺一项', '0.85', '46');
INSERT INTO `option` VALUES ('152', '缺二项', '0.65', '46');
INSERT INTO `option` VALUES ('153', '缺二项以上', '0.45', '46');
INSERT INTO `option` VALUES ('154', '一周以上', '1.00', '47');
INSERT INTO `option` VALUES ('155', '一周', '0.85', '47');
INSERT INTO `option` VALUES ('156', '接近一周', '0.65', '47');
INSERT INTO `option` VALUES ('157', '没有余量', '0.45', '47');
INSERT INTO `option` VALUES ('158', '清楚、准确', '1.00', '48');
INSERT INTO `option` VALUES ('159', '正确、及时', '0.85', '48');
INSERT INTO `option` VALUES ('160', '填写缺项', '0.65', '48');
INSERT INTO `option` VALUES ('161', '填写马虎', '0.45', '48');
INSERT INTO `option` VALUES ('162', '认真且有见解', '1.00', '49');
INSERT INTO `option` VALUES ('163', '详尽、整洁', '0.85', '49');
INSERT INTO `option` VALUES ('164', '正确', '0.65', '49');
INSERT INTO `option` VALUES ('165', '潦草、拖拉', '0.45', '49');
INSERT INTO `option` VALUES ('166', '每周有辅导', '1.00', '50');
INSERT INTO `option` VALUES ('167', '辅导较经常', '0.85', '50');
INSERT INTO `option` VALUES ('168', '辅导较少', '0.65', '50');
INSERT INTO `option` VALUES ('169', '不辅导', '0.45', '50');
INSERT INTO `option` VALUES ('170', '严格', '1.00', '51');
INSERT INTO `option` VALUES ('171', '较严格', '0.85', '51');
INSERT INTO `option` VALUES ('172', '一般', '0.65', '51');
INSERT INTO `option` VALUES ('173', '出现教学事故', '0.45', '51');
INSERT INTO `option` VALUES ('174', '副教授', '1.00', '54');
INSERT INTO `option` VALUES ('175', '副教授', '0.85', '54');
INSERT INTO `option` VALUES ('176', '助教', '0.65', '54');
INSERT INTO `option` VALUES ('177', '未评职称', '0.45', '54');
INSERT INTO `option` VALUES ('178', '开出有一定水平的选修课、讲座、院级公开课或指导兴趣小组有成效', '1.00', '55');
INSERT INTO `option` VALUES ('179', '开出选修课、讲座、科内公开课或指导兴趣小组活动', '0.85', '55');
INSERT INTO `option` VALUES ('180', '承担室内研究课、协助开出讲座或配合指导学生课外活动', '0.65', '55');
INSERT INTO `option` VALUES ('181', '无', '0.45', '55');
INSERT INTO `option` VALUES ('182', '在核心刊物上发表、教材正式出版（三年内）', '1.00', '56');
INSERT INTO `option` VALUES ('183', '在公开刊物上发表，教材兄弟院校使用（二年内）', '0.85', '56');
INSERT INTO `option` VALUES ('184', '在内部刊上发表，教材在校内使用（一年内）', '0.65', '56');
INSERT INTO `option` VALUES ('185', '无', '0.45', '56');
INSERT INTO `option` VALUES ('186', '高质量完成', '1.00', '57');
INSERT INTO `option` VALUES ('187', '及时完成', '0.85', '57');
INSERT INTO `option` VALUES ('188', '基本完成', '0.65', '57');
INSERT INTO `option` VALUES ('189', '完不成', '0.45', '57');
INSERT INTO `option` VALUES ('190', '显著提高', '1.00', '58');
INSERT INTO `option` VALUES ('191', '有所提高', '0.85', '58');
INSERT INTO `option` VALUES ('192', '变化很小', '0.65', '58');
INSERT INTO `option` VALUES ('193', '下降', '0.45', '58');
INSERT INTO `option` VALUES ('194', '优秀', '1.00', '59');
INSERT INTO `option` VALUES ('195', '良好', '0.85', '59');
INSERT INTO `option` VALUES ('196', '一般', '0.65', '59');
INSERT INTO `option` VALUES ('197', '较差', '0.45', '59');
INSERT INTO `option` VALUES ('198', '思路开阔，鼓励创新，注意能力培养、效果明显', '1.00', '60');
INSERT INTO `option` VALUES ('199', '注意学生能力培养，并在教学中有所体现', '0.85', '60');
INSERT INTO `option` VALUES ('201', '能提出能力培养的要求，但缺乏具体的办法', '0.65', '60');
INSERT INTO `option` VALUES ('202', '忽视能力培养，单纯灌输书本知识', '0.45', '60');
INSERT INTO `option` VALUES ('204', '及时在教学中体现', '1.00', '61');
INSERT INTO `option` VALUES ('206', '教学中注意联系新信息新技术', '0.85', '61');
INSERT INTO `option` VALUES ('207', '教学中联系新信息新技术不够', '0.65', '61');
INSERT INTO `option` VALUES ('208', '教学中根本不联系新信息新技术', '0.45', '61');
INSERT INTO `option` VALUES ('209', '试题的水平、题型、题量、分布、覆盖面符合教学目标的要求；难度适中，区分度适当；表述准确、严密、简洁。', '1.00', '62');
INSERT INTO `option` VALUES ('210', '有2项不符合要求', '0.85', '62');
INSERT INTO `option` VALUES ('211', '有3项不符合要求', '0.65', '62');
INSERT INTO `option` VALUES ('212', '有3项以上（不含3项）不符合要求', '0.45', '62');
INSERT INTO `option` VALUES ('216', '非常幽默', '1.00', '68');
INSERT INTO `option` VALUES ('217', '很般幽默', '0.85', '68');
INSERT INTO `option` VALUES ('218', '一般幽默', '0.65', '68');
INSERT INTO `option` VALUES ('219', '不幽默', '0.45', '68');

-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RoleName` varchar(50) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '管理员');
INSERT INTO `role` VALUES ('2', '学生');
INSERT INTO `role` VALUES ('3', '教师');
INSERT INTO `role` VALUES ('4', '领导');
INSERT INTO `role` VALUES ('5', '教研室');
INSERT INTO `role` VALUES ('6', '系部');

-- ----------------------------
-- Table structure for `rolemenu`
-- ----------------------------
DROP TABLE IF EXISTS `rolemenu`;
CREATE TABLE `rolemenu` (
  `RoleID` int(11) NOT NULL,
  `MenuID` int(11) NOT NULL,
  KEY `RoleID` (`RoleID`),
  KEY `MenuID` (`MenuID`),
  CONSTRAINT `rolemenu_ibfk_1` FOREIGN KEY (`RoleID`) REFERENCES `role` (`ID`),
  CONSTRAINT `rolemenu_ibfk_2` FOREIGN KEY (`MenuID`) REFERENCES `menu` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rolemenu
-- ----------------------------
INSERT INTO `rolemenu` VALUES ('1', '1');
INSERT INTO `rolemenu` VALUES ('1', '2');
INSERT INTO `rolemenu` VALUES ('1', '3');
INSERT INTO `rolemenu` VALUES ('1', '4');
INSERT INTO `rolemenu` VALUES ('1', '5');
INSERT INTO `rolemenu` VALUES ('1', '6');
INSERT INTO `rolemenu` VALUES ('1', '7');
INSERT INTO `rolemenu` VALUES ('2', '8');
INSERT INTO `rolemenu` VALUES ('2', '10');
INSERT INTO `rolemenu` VALUES ('2', '11');
INSERT INTO `rolemenu` VALUES ('2', '12');
INSERT INTO `rolemenu` VALUES ('2', '14');
INSERT INTO `rolemenu` VALUES ('2', '15');
INSERT INTO `rolemenu` VALUES ('1', '12');
INSERT INTO `rolemenu` VALUES ('1', '14');
INSERT INTO `rolemenu` VALUES ('1', '15');
INSERT INTO `rolemenu` VALUES ('4', '8');
INSERT INTO `rolemenu` VALUES ('4', '10');
INSERT INTO `rolemenu` VALUES ('4', '11');
INSERT INTO `rolemenu` VALUES ('4', '12');
INSERT INTO `rolemenu` VALUES ('4', '14');
INSERT INTO `rolemenu` VALUES ('4', '15');
INSERT INTO `rolemenu` VALUES ('5', '8');
INSERT INTO `rolemenu` VALUES ('5', '10');
INSERT INTO `rolemenu` VALUES ('5', '11');
INSERT INTO `rolemenu` VALUES ('5', '12');
INSERT INTO `rolemenu` VALUES ('5', '14');
INSERT INTO `rolemenu` VALUES ('5', '15');
INSERT INTO `rolemenu` VALUES ('6', '8');
INSERT INTO `rolemenu` VALUES ('6', '10');
INSERT INTO `rolemenu` VALUES ('6', '11');
INSERT INTO `rolemenu` VALUES ('6', '12');
INSERT INTO `rolemenu` VALUES ('6', '14');
INSERT INTO `rolemenu` VALUES ('6', '15');
INSERT INTO `rolemenu` VALUES ('4', '13');
INSERT INTO `rolemenu` VALUES ('3', '11');
INSERT INTO `rolemenu` VALUES ('3', '14');
INSERT INTO `rolemenu` VALUES ('3', '15');
INSERT INTO `rolemenu` VALUES ('3', '12');
INSERT INTO `rolemenu` VALUES ('3', '13');

-- ----------------------------
-- Table structure for `target`
-- ----------------------------
DROP TABLE IF EXISTS `target`;
CREATE TABLE `target` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TargetName` varchar(50) NOT NULL,
  `Weight` float(53,2) NOT NULL COMMENT '权重',
  `ParentID` int(11) DEFAULT NULL,
  `RoleID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `RoleID` (`RoleID`),
  KEY `ParentID` (`ParentID`),
  CONSTRAINT `RoleID` FOREIGN KEY (`RoleID`) REFERENCES `role` (`ID`),
  CONSTRAINT `target_ibfk_1` FOREIGN KEY (`ParentID`) REFERENCES `target` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of target
-- ----------------------------
INSERT INTO `target` VALUES ('3', '概念的讲解', '0.15', null, '2');
INSERT INTO `target` VALUES ('4', '重点和难点', '0.15', null, '2');
INSERT INTO `target` VALUES ('5', '逻辑性和条理性', '0.10', null, '2');
INSERT INTO `target` VALUES ('6', '趣味性和生动性', '0.10', null, '2');
INSERT INTO `target` VALUES ('7', '板书', '0.05', null, '2');
INSERT INTO `target` VALUES ('8', '辅导（阅读指导）', '0.08', null, '2');
INSERT INTO `target` VALUES ('9', '作业与批改', '0.10', null, '2');
INSERT INTO `target` VALUES ('10', '能力培养', '0.10', null, '2');
INSERT INTO `target` VALUES ('11', '教书育人', '0.10', null, '2');
INSERT INTO `target` VALUES ('12', '为人师表', '0.07', null, '2');
INSERT INTO `target` VALUES ('13', '组织教学', '0.15', null, '3');
INSERT INTO `target` VALUES ('14', '教学要求、教学内容', '0.15', null, '3');
INSERT INTO `target` VALUES ('15', '概念讲解', '0.10', null, '3');
INSERT INTO `target` VALUES ('16', '重点和难点', '0.10', null, '3');
INSERT INTO `target` VALUES ('17', '趣味性和生动性', '0.08', null, '3');
INSERT INTO `target` VALUES ('18', '直观教学与板书', '0.07', null, '3');
INSERT INTO `target` VALUES ('19', '智力能力的培养', '0.10', null, '3');
INSERT INTO `target` VALUES ('20', '理论联系实际', '0.10', null, '3');
INSERT INTO `target` VALUES ('21', '教材处理', '0.15', null, '3');
INSERT INTO `target` VALUES ('22', '教学环节', '0.60', null, '5');
INSERT INTO `target` VALUES ('23', '概念的讲解', '0.15', '22', '5');
INSERT INTO `target` VALUES ('24', '重点和难点', '0.15', '22', '5');
INSERT INTO `target` VALUES ('25', '逻辑性、条理性', '0.10', '22', '5');
INSERT INTO `target` VALUES ('26', '趣味性、生动性', '0.10', '22', '5');
INSERT INTO `target` VALUES ('27', '板书', '0.05', '22', '5');
INSERT INTO `target` VALUES ('28', '能力培养', '0.15', '22', '5');
INSERT INTO `target` VALUES ('29', '理论联系实际', '0.10', '22', '5');
INSERT INTO `target` VALUES ('30', '辅导（阅读指导）', '0.10', '22', '5');
INSERT INTO `target` VALUES ('31', '作业与批改', '0.10', '22', '5');
INSERT INTO `target` VALUES ('32', '接受任务', '0.10', null, '5');
INSERT INTO `target` VALUES ('33', '汲取新信息新技术', '0.10', null, '5');
INSERT INTO `target` VALUES ('34', '学术与研究水平', '0.10', null, '5');
INSERT INTO `target` VALUES ('35', '参加教研活动', '0.10', null, '5');
INSERT INTO `target` VALUES ('37', '量考核', '0.30', null, '6');
INSERT INTO `target` VALUES ('38', '教学工作量', '0.75', '37', '6');
INSERT INTO `target` VALUES ('39', '社会工作量', '0.15', '37', '6');
INSERT INTO `target` VALUES ('40', '任课班级', '0.10', '37', '6');
INSERT INTO `target` VALUES ('41', '质考核', '0.70', null, '6');
INSERT INTO `target` VALUES ('42', '工作态度', '0.40', '41', '6');
INSERT INTO `target` VALUES ('43', '接受任务态度', '0.10', '42', '6');
INSERT INTO `target` VALUES ('44', '教学常规', '0.90', '41', '6');
INSERT INTO `target` VALUES ('45', '授课计划的制定', '0.10', '44', '6');
INSERT INTO `target` VALUES ('46', '教案首页', '0.20', '44', '6');
INSERT INTO `target` VALUES ('47', '备课余量', '0.10', '44', '6');
INSERT INTO `target` VALUES ('48', '教学日志手册的填写', '0.10', '44', '6');
INSERT INTO `target` VALUES ('49', '教学表格的填写', '0.10', '44', '6');
INSERT INTO `target` VALUES ('50', '辅导', '0.20', '44', '6');
INSERT INTO `target` VALUES ('51', '教学秩序的掌握', '0.20', '44', '6');
INSERT INTO `target` VALUES ('53', '学术与研究水平', '0.15', '41', '6');
INSERT INTO `target` VALUES ('54', '职称', '0.10', '53', '6');
INSERT INTO `target` VALUES ('55', '运用新知识、新技术能力', '0.40', '53', '6');
INSERT INTO `target` VALUES ('56', '论文撰写、教材编写能力', '0.50', '53', '6');
INSERT INTO `target` VALUES ('57', '完成任务情况', '0.05', '41', '6');
INSERT INTO `target` VALUES ('58', '教学水平变化', '0.05', '41', '6');
INSERT INTO `target` VALUES ('59', '教学反映', '0.15', '41', '6');
INSERT INTO `target` VALUES ('60', '能力培养', '0.10', '41', '6');
INSERT INTO `target` VALUES ('61', '汲取新信息新技术', '0.05', '41', '6');
INSERT INTO `target` VALUES ('62', '考试命题', '0.05', '41', '6');
INSERT INTO `target` VALUES ('68', '是否幽默', '0.22', null, '2');

-- ----------------------------
-- Table structure for `userrole`
-- ----------------------------
DROP TABLE IF EXISTS `userrole`;
CREATE TABLE `userrole` (
  `UserID` int(11) NOT NULL,
  `RoleID` int(11) NOT NULL,
  KEY `UserID` (`UserID`),
  KEY `RoleID` (`RoleID`),
  CONSTRAINT `userrole_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `users` (`ID`),
  CONSTRAINT `userrole_ibfk_2` FOREIGN KEY (`RoleID`) REFERENCES `role` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userrole
-- ----------------------------
INSERT INTO `userrole` VALUES ('1', '1');
INSERT INTO `userrole` VALUES ('2', '1');
INSERT INTO `userrole` VALUES ('3', '3');
INSERT INTO `userrole` VALUES ('4', '2');
INSERT INTO `userrole` VALUES ('5', '3');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Account` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `ClassId` int(11) NOT NULL,
  `DepartMentID` int(11) NOT NULL,
  `UserImg` varchar(20000) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `DepartMentID` (`DepartMentID`),
  KEY `ClassId` (`ClassId`),
  CONSTRAINT `DepartMentID` FOREIGN KEY (`DepartMentID`) REFERENCES `department` (`ID`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`ClassId`) REFERENCES `classes` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', 'E10ADC3949BA59ABBE56E057F20F883E', '柳', '7', '1', '/Content/UserImg/4.jpg');
INSERT INTO `users` VALUES ('2', '123', 'E10ADC3949BA59ABBE56E057F20F883E', 'bbb', '3', '1', null);
INSERT INTO `users` VALUES ('3', 'dyc', 'E10ADC3949BA59ABBE56E057F20F883E', '丁允超', '8', '1', null);
INSERT INTO `users` VALUES ('4', 'lyq', 'E10ADC3949BA59ABBE56E057F20F883E', 'liuliu', '7', '1', null);
INSERT INTO `users` VALUES ('5', 'lyf', 'E10ADC3949BA59ABBE56E057F20F883E', '罗宇飞', '7', '1', null);