基于SpringBoot的企业技术员工测评考试管理系统

/* Navicat MySQL Data Transfer Source Server : mysql168 Source Server Version : 50642 Source Host : 192.168.0.168:3306 Source Database : staffexam Target Server Type : MYSQL Target Server Version : 50642 File Encoding : 65001 Date: 2021-04-25 08:13:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for QX_COURSE -- ---------------------------- DROP TABLE IF EXISTS `QX_COURSE`; CREATE TABLE `QX_COURSE` ( `COURSE_ID` varchar(100) NOT NULL, `CODE` varchar(255) DEFAULT NULL COMMENT '编码', `NAME` varchar(255) DEFAULT NULL COMMENT '名称', `CONTENT` varchar(255) DEFAULT NULL COMMENT '内容', `ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`COURSE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of QX_COURSE -- ---------------------------- INSERT INTO `QX_COURSE` VALUES ('19c554eee90b4b7a865f85df3191cc99', '04240001', '高等数学', '111', '2021-04-23 16:34:06'); INSERT INTO `QX_COURSE` VALUES ('814a4ba53cdc458ba9d2019dc68e29fd', '040203001', '英语', '英语', '2021-04-24 13:40:39'); INSERT INTO `QX_COURSE` VALUES ('81e9daafac454dee9b6ecefabecde345', '0424002', '文学创作', '222', '2021-04-23 16:34:13'); -- ---------------------------- -- Table structure for QX_PAPER -- ---------------------------- DROP TABLE IF EXISTS `QX_PAPER`; CREATE TABLE `QX_PAPER` ( `PAPER_ID` varchar(100) NOT NULL, `COURSE_KEY` varchar(255) DEFAULT NULL COMMENT '绉戠洰ID', `TITLE` varchar(255) DEFAULT NULL COMMENT '鏍囬', `ADD_DATE` varchar(255) DEFAULT NULL COMMENT '娣诲姞鏃堕棿', PRIMARY KEY (`PAPER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of QX_PAPER -- ---------------------------- INSERT INTO `QX_PAPER` VALUES ('1aa1bd5984324d31bf6e2c3cb832ae2b', '814a4ba53cdc458ba9d2019dc68e29fd', '英语第一次考试', '2021-04-24 13:41:23'); INSERT INTO `QX_PAPER` VALUES ('9d0c1727b5a341fdb36c058039830330', '81e9daafac454dee9b6ecefabecde345', '汉语言文学第二学期期中考试', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER` VALUES ('aa2da04adc44468398cc3fdf09c6f55b', '81e9daafac454dee9b6ecefabecde345', '第一学期期末考试', '2021-04-24 09:59:47'); INSERT INTO `QX_PAPER` VALUES ('b2dd029fe7be423bbb625581c76d8d3c', '19c554eee90b4b7a865f85df3191cc99', '2131', '2021-04-23 17:34:09'); -- ---------------------------- -- Table structure for QX_PAPER_ANSWER -- ---------------------------- DROP TABLE IF EXISTS `QX_PAPER_ANSWER`; CREATE TABLE `QX_PAPER_ANSWER` ( `PAPER_ANSWER_ID` varchar(100) NOT NULL, `QUESTION_KEY` varchar(255) DEFAULT NULL COMMENT '璇曢ID', `ANSWER` varchar(255) DEFAULT NULL COMMENT '绛旀', `ADD_DATE` varchar(255) DEFAULT NULL COMMENT '娣诲姞鏃堕棿', `PAPER_KEY` varchar(255) DEFAULT NULL, `USER_KEY` varchar(255) DEFAULT NULL, PRIMARY KEY (`PAPER_ANSWER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of QX_PAPER_ANSWER -- ---------------------------- INSERT INTO `QX_PAPER_ANSWER` VALUES ('299ebcf65ec0425998a839afcc677fb3', '72149c46c34b4f1585e01e704300ae45', 'C', '2021-04-24 11:00:19', 'aa2da04adc44468398cc3fdf09c6f55b', 'f6b7b1908c67467892705fdf97512eed'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('29a81d2eec49465e9958d457304755a6', '9c659ae9dd5f452586bc8d2d5308e724', 'A', '2021-04-24 11:00:19', 'aa2da04adc44468398cc3fdf09c6f55b', 'f6b7b1908c67467892705fdf97512eed'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('34ef22b050c149f98f863d4687980744', 'a0d948dbd81a45ae890b5efdb33b9706', 'B', '2021-04-24 13:42:57', '1aa1bd5984324d31bf6e2c3cb832ae2b', 'e6d6b61e03904fc7b9ee3bbaf7547d47'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('74bc5c8bdd4348ccb1fd9613e252a4ac', '7a86f81fc6bb49fb88bba28d5441b7cb', '32142141', '2021-04-24 11:30:32', 'b2dd029fe7be423bbb625581c76d8d3c', 'f6b7b1908c67467892705fdf97512eed'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('8d42b3acd9ac461b8335ae8e520cec13', '03b01d6b2f1e4df692fe9703e08bc785', 'B', '2021-04-24 11:00:19', 'aa2da04adc44468398cc3fdf09c6f55b', 'f6b7b1908c67467892705fdf97512eed'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('9588cc6c46954bed9cf0a66961cb2a2e', '7a86f81fc6bb49fb88bba28d5441b7cb', '111', '2021-04-24 13:42:57', '1aa1bd5984324d31bf6e2c3cb832ae2b', 'e6d6b61e03904fc7b9ee3bbaf7547d47'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('ad2b433bd66c4a989e80f538e7097a31', '9c659ae9dd5f452586bc8d2d5308e724', 'B', '2021-04-24 13:42:57', '1aa1bd5984324d31bf6e2c3cb832ae2b', 'e6d6b61e03904fc7b9ee3bbaf7547d47'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('b53fb5c46f4244ff9165aa482e77776e', 'a0d948dbd81a45ae890b5efdb33b9706', 'B', '2021-04-24 11:00:19', 'aa2da04adc44468398cc3fdf09c6f55b', 'f6b7b1908c67467892705fdf97512eed'); INSERT INTO `QX_PAPER_ANSWER` VALUES ('e290654b4cdb4b7594cb81b0d04ec6c7', '5e410128c96a4ddf8319b3fe5b55eb3b', 'C', '2021-04-24 13:42:57', '1aa1bd5984324d31bf6e2c3cb832ae2b', 'e6d6b61e03904fc7b9ee3bbaf7547d47'); -- ---------------------------- -- Table structure for QX_PAPER_QUESTION -- ---------------------------- DROP TABLE IF EXISTS `QX_PAPER_QUESTION`; CREATE TABLE `QX_PAPER_QUESTION` ( `PAPER_QUESTION_ID` varchar(100) NOT NULL, `PAPER_KEY` varchar(255) DEFAULT NULL COMMENT '题型', `QUESTION_KEY` varchar(255) DEFAULT NULL COMMENT '试题ID', `ADD_DATE` varchar(255) DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`PAPER_QUESTION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of QX_PAPER_QUESTION -- ---------------------------- INSERT INTO `QX_PAPER_QUESTION` VALUES ('115e736b250a4b48bcc4ee7ce98a7625', 'aa2da04adc44468398cc3fdf09c6f55b', '3ffa968dbf4646e8925cb68488dce827', '2021-04-24 09:59:47'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('11b7522535834a7ca5b142cd8dfd258b', '1aa1bd5984324d31bf6e2c3cb832ae2b', 'a0d948dbd81a45ae890b5efdb33b9706', '2021-04-24 13:41:23'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('1746245376ad45e0861b18221c952532', 'aa2da04adc44468398cc3fdf09c6f55b', '7a86f81fc6bb49fb88bba28d5441b7cb', '2021-04-24 09:59:47'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('2abbc5549aad4a42902104e8aaf57e34', '9d0c1727b5a341fdb36c058039830330', '3ffa968dbf4646e8925cb68488dce827', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('3980edf95af74145afc63b8ac8f6adc3', '1aa1bd5984324d31bf6e2c3cb832ae2b', '5e410128c96a4ddf8319b3fe5b55eb3b', '2021-04-24 13:41:23'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('407c199545e349feb8773db2012b96e2', 'aa2da04adc44468398cc3fdf09c6f55b', '72149c46c34b4f1585e01e704300ae45', '2021-04-24 09:59:47'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('61466f71cde546ea8c3c69953dd2962e', '9d0c1727b5a341fdb36c058039830330', '72149c46c34b4f1585e01e704300ae45', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('6f096262c7c843dca2ea7f48562e9c4e', '9d0c1727b5a341fdb36c058039830330', '9c659ae9dd5f452586bc8d2d5308e724', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('75ee553a88c84501a56276a3fd8f3055', '9d0c1727b5a341fdb36c058039830330', '7a86f81fc6bb49fb88bba28d5441b7cb', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('7eccd469f2fa4a53bccc5a3627408cd2', '1aa1bd5984324d31bf6e2c3cb832ae2b', '7a86f81fc6bb49fb88bba28d5441b7cb', '2021-04-24 13:41:23'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('89ab8729d75b4a3fbddc594ce6b03549', 'aa2da04adc44468398cc3fdf09c6f55b', '9c659ae9dd5f452586bc8d2d5308e724', '2021-04-24 09:59:47'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('8ebd9584e9e74e20afddcf5600e2f61d', '9d0c1727b5a341fdb36c058039830330', 'a0d948dbd81a45ae890b5efdb33b9706', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('a954a2ed6ee648d089214d195ae16b44', '9d0c1727b5a341fdb36c058039830330', '03b01d6b2f1e4df692fe9703e08bc785', '2021-04-24 13:39:18'); INSERT INTO `QX_PAPER_QUESTION` VALUES ('b9c9005b94c64e0c8d237d67a22e4417', 'b2d