代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50716
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50716
File Encoding : 65001
Date: 2021-06-10 07:14:16
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`dutyId` varchar(10) NOT NULL,
`dutyName` varchar(10) CHARACTER SET utf8 NOT NULL,
`dutyPhone` varchar(15) NOT NULL,
PRIMARY KEY (`dutyId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1735151', '黎莉', '15904922539');
-- ----------------------------
-- Table structure for logincount
-- ----------------------------
DROP TABLE IF EXISTS `logincount`;
CREATE TABLE `logincount` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`userId` varchar(10) COLLATE utf8_bin NOT NULL,
`loginCount` int(4) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_uniq_userId` (`userId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of logincount
-- ----------------------------
INSERT INTO `logincount` VALUES ('4', 'vincent', '26');
INSERT INTO `logincount` VALUES ('5', '1735151', '37');
INSERT INTO `logincount` VALUES ('6', '47ec7f', '10');
-- ----------------------------
-- Table structure for meeting
-- ----------------------------
DROP TABLE IF EXISTS `meeting`;
CREATE TABLE `meeting` (
`meetingid` int(11) NOT NULL AUTO_INCREMENT,
`meetingname` varchar(20) NOT NULL,
`meetingposition` varchar(20) DEFAULT NULL,
`meetinghost` varchar(10) DEFAULT NULL,
`meetingcontent` varchar(50) DEFAULT NULL,
`begintime` varchar(10) DEFAULT NULL,
`endtime` varchar(10) DEFAULT NULL,
PRIMARY KEY (`meetingid`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of meeting
-- ----------------------------
INSERT INTO `meeting` VALUES ('1', '科研成果分享会', '凌云楼3-1', '李现', '就科研学院的科研成果报告会', '2020-1-1', '2020-2-1');
INSERT INTO `meeting` VALUES ('2', '2021届就著作权探讨会', '心仪家', '何水浪', '本会就著作侵犯权开展相关会议', '2020-2-1', '2020-2-2');
INSERT INTO `meeting` VALUES ('19', '张三的会议', '暂等通知', '张三', '暂无', '2021-1-1', '2021-1-2');
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` varchar(10) NOT NULL,
`toUser` varchar(10) DEFAULT NULL COMMENT '收信人，给所有老师 allTeacher ,',
`fromUser` varchar(10) DEFAULT NULL COMMENT '发信人',
`message` varchar(1500) CHARACTER SET utf8 DEFAULT NULL COMMENT '消息内容',
`begin` int(11) DEFAULT NULL COMMENT '消息发送时间',
`end` int(11) DEFAULT NULL COMMENT '消息失效时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES ('12fdba1562', 'allTeacher', 'admin', '各位教师，请及时更新科研成果信息！', '20210101', '20210614');
INSERT INTO `message` VALUES ('135d5c5866', '47ec7f', 'admin', '你的项目《交直转换模块研究》被管理员，执行了：通过 操作。请进入有关页面进行查看。', '20210610', '20210617');
INSERT INTO `message` VALUES ('272b4bee28', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了：通过 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('449dceab46', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了： 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('48066702ec', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了： 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('5a2a048c7c', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了：通过 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('66bb33bce2', '47ec7f', 'admin', '你的项目《交直转换模块研究》被管理员，执行了： 操作。请进入有关页面进行查看。', '20210610', '20210617');
INSERT INTO `message` VALUES ('9431266564', '47ec7f', 'admin', '你的项目《交直转换模块研究》被管理员，执行了： 操作。请进入有关页面进行查看。', '20210610', '20210617');
INSERT INTO `message` VALUES ('bd81eba423', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了：通过 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('d7ee5b2257', '47ec7f', 'admin', '你的专利《自动扫地机器人》被管理员，执行了： 操作。请进入有关页面进行查看。', '20210609', '20210616');
INSERT INTO `message` VALUES ('fdfd282966', 'allTeacher', 'admin', '各位教师，请立即检查自己的个人信息！', '2021512', '2021515');
-- ----------------------------
-- Table structure for paper
-- ----------------------------
DROP TABLE IF EXISTS `paper`;
CREATE TABLE `paper` (
`resultUUid` varchar(10) CHARACTER SET utf8 NOT NULL,
`teacherId` varchar(10) DEFAULT NULL,
`firstName` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`allName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`endTime` varchar(12) DEFAULT NULL,
`paperName` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`paperTypeId` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT 'utf8',
`supportFun` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`checkFlag` int(4) DEFAULT '0' COMMENT '0:未经过审核 1 通过审核 2 被下架',
`score` int(4) DEFAULT '0',
PRIMARY KEY (`resultUUid`),
KEY `1` (`teacherId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of paper
-- ----------------------------
INSERT INTO `paper` VALUES ('15a971', '47ec7f', '何水浪', '何水浪/小二/小五', '2018-10-29', '基于C语言的CPU功率探究', '普通论文', '无', '1', '40');
INSERT INTO `paper` VALUES ('79dfea', '47ec7f', '何水浪', '何水浪/王小二', '2021-05-31', '基于Matlab的大数据搜索算法', 'EI论文', '计算机软件开源基金', '1', '80');
INSERT INTO `paper` VALUES ('8567e9', '47ec7f', '何水浪', '何水浪/小小/张三', '2018-12-01', '基于MATLAB的五子棋机器算法', '普通论文', '无', '3', '30');
INSERT INTO `paper` VALUES ('8c931d', '47ec7f', '何水浪', '何水浪/李四', '2018-12-10', '基于Java的大数据算法', '普通论文', '无', '3', '30');
INSERT INTO `paper` VALUES ('9a51cd', '47ec7f', '何水浪', '何水浪/小四/小五', '2018-10-25', '基于SSM的科研成果管理系统', '普通论文', '无', '1', '30');
INSERT INTO `paper` VALUES ('9e23e4', '47ec7f', '何水浪', '何水浪', '2021-5-4', '基于ASP.NET的职员管理系统', 'SCI论文', '无', '1', '80');
INSERT INTO `paper` VALUES ('b1a23f', 'vincent', '文森特', '文森特/马冬梅', '2018-11-10', '基于深度学习的微积分导论', '普通论文', '钢铁基金', '3', '30');
INSERT INTO `paper` VALUES ('d8d911', '47ec7f', '何水浪', '何水浪/李白', '2018-12-21', '基于前后端分离的电商系统', '普通论文', '无', '1', '30');
INSERT INTO `paper` VALUES ('e610a7', 'vincent', '何水浪', '何水浪/李四', '2021-07-28', '关于人民币国际化的若干思考', 'EI论文', '国际金融基金', '1', '80');
INSERT INTO `paper` VALUES ('e9f310', '47ec7f', '何水浪', '何水浪/牛二', '2021-05-31', '基于C#交友网站的设计与实现', '核心论文', '阿里巴巴软件基金', '3', '50');
INSERT INTO `paper` VALUES ('f39ccd', '47ec7f', '何水浪', '何水浪/林俊杰', '2021-05-29', '基于Go语言的二手交易平台', '核心论文', 'Apache开源基金', '1', '50');
INSERT INTO `paper` VALUES ('fbc46c', 'vincent', '王宝强', '王宝强', '2021-5-5', '基于SpringCloud的个人博客', 'SCI论文', '无', '1', '80');
-- ----------------------------
-- Table structure for patent
-- ----------------------------
DROP TABLE IF EXISTS `patent`;
CREATE TABLE `patent` (
`resultUUid` varchar(10) NOT NULL,
`teacherId` varchar(10) DEFAULT NULL,
`itemOwn` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '专利所有人',
`firstName` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '第一发明人',
`allName` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '所有发明人',
`endTime` varchar(12) DEFAULT NULL,
`patentType` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`patentId` varchar(30) DEFAULT NULL COMMENT '证书编号',
`patentName` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`checkFlag` int(4) DEFAULT '0' COMMENT '0:未经过审核 1 通过审核 2 被下架',
`score` int(4) DEFAULT '0',
PRIMARY KEY (`resultUUid`),
KEY `2` (`teacherId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of patent
-- ----------------------------
INSERT INTO `patent` VALUES ('0edae1', '47ec7f', '辽科大', '何水浪', '何水浪', '2018-10-19', '发明专利', 'RJZZ20180518911', '自动扫地机器人', '1', '80');
INSERT INTO `patent` VALUES ('e7657e', 'vincent', '攀枝花学院', '文森特', '文森特/张良量', '2021-2-1', '外观设计专利', 'RJZZ20180518912', '服装外观优化专利', '1', '80');
-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
`resultUUid` varchar(10) NOT NULL,
`teacherId` varchar(10) DEFAULT NULL,
`firstName` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`allName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`beginTime` varchar(12) DEFAULT NULL,
`endTime` varchar(12) DEFAULT NULL,
`projectRank` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`projectName` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`projectFunds` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`checkFlag` int(4) DEFAULT '0' COMMENT '0:未经过审核 1 通过审核 2 被下架',
`score` int(4) DEFAULT '0',
PRIMARY KEY (`resultUUid`),
KEY `3` (`teacherId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES ('0c89d3', '47ec7f', '何水浪', '何水浪/马洋/李亮', '2017-03-21', '2018-11-25', '校级项目', '交直转换模块研究', '10', '3', '50');
INSERT INTO `project` VALUES ('335db5', '47ec7f', '何水浪', '何水浪/马云云/马化化', '2017-5-25', '2018-12-10', '纵向项目', '基于大数据模式人脸识别项目', '20', '1', '80');
INSERT INTO `project` VALUES ('58dd74', 'vincent', '王宝强', '王宝强/黎阿明/刘阿华/郭阿程', '2021-5-12', '2021-5-13', '横向项目', '攀枝花炳草岗大桥建设', '10', '1', '60');
INSERT INTO `project` VALUES ('722a22', '47ec7f', '何水浪', '何水浪/李四/王五', '2017-10-15', '2018-12-20', '横向项目', '攀枝花市太阳能供应项目', '10', '1', '80');
-- ----------------------------
-- Table structure for scorestandard
-- ----------------------------
DROP TABLE IF EXISTS `scorestandard`;
CREATE TABLE `scorestandard` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`score` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of scorestandard
-- ----------------------------
INSERT INTO `scorestandard` VALUES ('1', '普通论文', '30');
INSERT INTO `scorestandard` VALUES ('2', '核心论文', '50');
INSERT INTO `scorestandard` VALUES ('3', 'SCI论文', '80');
INSERT INTO `scorestandard` VALUES ('4', 'EI论文', '80');
INSERT INTO `scorestandard` VALUES ('5', '校级项目', '50');
INSERT INTO `scorestandard` VALUES ('6', '横向项目', '80');
INSERT INTO `scorestandard` VALUES ('7', '纵向项目', '80');
INSERT INTO `scorestandard` VALUES ('8', '发明专利', '50');
INSERT INTO `scorestandard` VALUES ('9', '实用新型专利', '80');
INSERT INTO `scorestandard` VALUES ('10', '外观设计专利', '80');
-- ----------------------------
-- Table structure for source
-- ----------------------------
DROP TABLE IF EXISTS `source`;
CREATE TABLE `source` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`papername` varchar(100) NOT NULL,
`source` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`,`papername`),
UNIQUE KEY `unique_index` (`papername`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of source
-- ----------------------------
INSERT INTO `source` VALUES ('2', '关于人民币国际化的若干思考.doc', '/Users/beatrix/Desktop/teacher_science_system/target/ScientificInfo/./upload/');
-- ----------------------------
-- Table structure for takemeeting
-- ----------------------------
DROP TABLE IF EXISTS `takemeeting`;
CREATE TABLE `takemeeting` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`meetingid` int(11) NOT NULL,
`teacherId` varchar(10) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `for_meeting` (`meetingid`),
KEY `for_teacher` (`teacherId`),
CONSTRAINT `for_meeting` FOREIGN KEY (`meetingid`) REFERENCES `meeting` (`meetingid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `for_teacher` FOREIGN KEY (`teacherId`) REFERENCES `teacher` (`teacherId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of takemeeting
-- ----------------------------
INSERT INTO `takemeeting` VALUES ('1', '1', 'vincent');
INSERT INTO `takemeeting` VALUES ('6', '2', 'vincent');
INSERT INTO `takemeeting` VALUES ('7', '19', 'vincent');
INSERT INTO `takemeeting` VALUES ('8', '1', 'jack');
-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`teacherName` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`teacherId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`teacherIdentiCard` varchar(18) DEFAULT '',
`teacherSex` char(2) CHARACTER SET utf8 DEFAULT NULL,
`teacherBirth` varchar(12) DEFAULT NULL,
`teacherParty` int(4) DEFAULT '1' COMMENT '1 群众 2 中共党员 3 民革党员 4 民盟盟员',
`teacherStudy` int(4) DEFAULT '1' COMMENT '1 研究生硕士 2 博士研究生 3 其他',
`teacherAddress` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
`teacherAcademic` int(4) DEFAULT '1' COMMENT '1 讲师 2 副教授 3 教授 ',
`teacherPhone` varchar(15) DEFAULT NULL,
`teacherInTime` varchar(12) DEFAULT NULL,
`teacherQuitTime` varchar(12) DEFAULT '',
`teacherQuitReason` int(4) DEFAULT '0' COMMENT '0 未离校 1 辞职 2 异校进修 3 身体不适 4 离退',
`teacherStatu` int(4) DEFAULT '1' COMMENT '1 可用 2 注销',
`meetingid` int(11) DEFAULT NULL,
PRIMARY KEY (`teacherId`),
KEY `tea_id` (`teacherId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('何水浪', '47ec7f', '511623197625641357', '2', '1985-5-25', '1', '1', '攀枝花市攀枝花学院学府广场', '1', '13158565619', '2021-2-2', '', '0', '1', '1');
INSERT INTO `teacher` VALUES ('杰克', 'jack', '511623193625623357', '2', '1988-5-25', '2', '1', '炳草岗公寓', '2', '13158565454', '2021-2-2', '', '0', '1', '1');
INSERT INTO `teacher` VALUES ('文森特', 'vincent', '511623194625643357', '2', '1985-6-15', '3', '1', '攀钢公寓', '3', '13158568565', '2021-2-2', '', '0', '1', '1');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`user_id` varchar(10) NOT NULL,
`user_paswd` varchar(20) NOT NULL,
`user_type` int(4) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1735151', '1735151', '1');
INSERT INTO `user` VALUES ('47ec7f', '47ec7f', '3');
INSERT INTO `user` VALUES ('jack', 'jack', '3');
INSERT INTO `user` VALUES ('vincent', 'vincent', '3');
-- ----------------------------
-- Table structure for works
-- ----------------------------
DROP TABLE IF EXISTS `works`;
CREATE TABLE `works` (
`resultUUid` varchar(10) NOT NULL,
`teacherId` varchar(10) DEFAULT NULL,
`worksname` varchar(20) DEFAULT NULL,
`workspress` varchar(10) DEFAULT NULL,
`worksdate` varchar(12) DEFAULT NULL,
`editor` varchar(10) DEFAULT NULL,
`checkflag` int(4) DEFAULT '0',
PRIMARY KEY (`resultUUid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of works
-- ----------------------------
INSERT INTO `works` VALUES ('37118a', '47ec7f', '《农产品中真菌毒素的检测技术》', '化学工业出版社', '2006-1-2', '李三', '1');
INSERT INTO `works` VALUES ('a12318', '47ec7f', '《基于Java Web的开发著作》', '四川大学出版社', '2021-2-1', '李三', '1');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
