湖科大数据库课程设计--学生管理系统

/* Navicat Premium Data Transfer Source Server : local Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : workdb Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 29/06/2022 10:31:28 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for change_code -- ---------------------------- DROP TABLE IF EXISTS `change_code`; CREATE TABLE `change_code` ( `CODE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代码', `DESCRIPIONS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODE`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of change_code -- ---------------------------- INSERT INTO `change_code` VALUES ('0', '转系'); INSERT INTO `change_code` VALUES ('1', '休学'); INSERT INTO `change_code` VALUES ('2', '复学'); INSERT INTO `change_code` VALUES ('3', '退学'); INSERT INTO `change_code` VALUES ('4', '毕业'); -- ---------------------------- -- Table structure for class -- ---------------------------- DROP TABLE IF EXISTS `class`; CREATE TABLE `class` ( `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级编号', `CNAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `MONITOR` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `DepartmentID` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`MONITOR`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of class -- ---------------------------- INSERT INTO `class` VALUES ('01', '一班', '何炅', '0401'); INSERT INTO `class` VALUES ('01', '一班', '刘铮', '0201'); INSERT INTO `class` VALUES ('3', '七百', '度数', '0000'); INSERT INTO `class` VALUES ('05', '五班', '张博伟', '0101'); INSERT INTO `class` VALUES ('02', '二班', '李东丽', '0101'); INSERT INTO `class` VALUES ('03', '三班', '李潭', '0101'); INSERT INTO `class` VALUES ('01', '一班', '汪昊', '0101'); INSERT INTO `class` VALUES ('01', '一班', '辉煌', '0301'); INSERT INTO `class` VALUES ('04', '四班', '黄京', '0101'); -- ---------------------------- -- Table structure for department -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代号', `DNAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of department -- ---------------------------- INSERT INTO `department` VALUES ('0000', '生命科学'); INSERT INTO `department` VALUES ('0101', '计算机学院计科'); INSERT INTO `department` VALUES ('0201', '外国语学院翻译'); INSERT INTO `department` VALUES ('0301', '人文学院马克思'); INSERT INTO `department` VALUES ('0401', '体育学院篮球'); -- ---------------------------- -- Table structure for punish_levels -- ---------------------------- DROP TABLE IF EXISTS `punish_levels`; CREATE TABLE `punish_levels` ( `CODE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代码', `LEVELSS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODE`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of punish_levels -- ---------------------------- INSERT INTO `punish_levels` VALUES ('0', '警告'); INSERT INTO `punish_levels` VALUES ('1', '严重警告'); INSERT INTO `punish_levels` VALUES ('2', '记过'); INSERT INTO `punish_levels` VALUES ('3', '记大过'); INSERT INTO `punish_levels` VALUES ('4', '开除'); -- ---------------------------- -- Table structure for punishment -- ---------------------------- DROP TABLE IF EXISTS `punishment`; CREATE TABLE `punishment` ( `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '记录号', `STUDENTID` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LEVELS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `REC_TIME` date NOT NULL, `ENABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIPTION` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of punishment -- ---------------------------- INSERT INTO `punishment` VALUES ('1', '1702010101', '3', '2018-12-20', 'T', '经常旷课'); INSERT INTO `punishment` VALUES ('10', '1703010154', '3', '2018-12-20', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('11', '1111111', '1', '2018-12-20', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('3', '1703010105', '5', '2018-12-21', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('4', '1703010105', '5', '2018-12-20', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('5', '1703010105', '2', '2018-12-21', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('6', '1703010105', '7', '2018-12-21', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('7', '1703010105', '2', '2018-12-21', 'F', '表现良好暂时不生效'); INSERT INTO `punishment` VALUES ('8', '1703010154', '1', '2018-12-20', 'F', '表现良好暂时不生效'); -- ---------------------------- -- Table structure for reward -- ---------------------------- DROP TABLE IF EXISTS `reward`; CREATE TABLE `reward` ( `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '记录号', `STUDENTID` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号', `LEVELS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '级别代码', `REC_TIME` date NOT NULL COMMENT '记录时间', `DESCRIPTION` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of reward -- ---------------------------- INSERT INTO `reward` VALUES ('1', '1701010506', '0', '2018-12-27', '获得校特等奖学金'); INSERT INTO `reward` VALUES ('2', '1701010314', '1', '2018-12-27', '获得校一等奖学金'); INSERT INTO `reward` VALUES ('3', '1701010314', '1', '2018-12-27', '获得校一等奖学金'); -- ---------------------------- -- Table structure for reward_levels -- ---------------------------- DROP TABLE IF EXISTS `reward_levels`; CREATE TABLE `reward_levels` ( `CODE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代码', `LEVELSSS` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODE`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of reward_levels -- ---------------------------- INSERT INTO `reward_levels` VALUES ('0', '校特等奖学金'); INSERT INTO `reward_levels` VALUES ('1', '校一等奖学金'); INSERT INTO `reward_levels` VALUES ('2', '校二等奖学金'); INSERT INTO `reward_levels` VALUES ('3', '校三等奖学金'); INSE