绩效考核系统

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50528 Source Host : localhost:3306 Source Database : performance Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2013-05-10 10:02:23 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `beiping_ping` -- ---------------------------- DROP TABLE IF EXISTS `beiping_ping`; CREATE TABLE `beiping_ping` ( `beipingid` char(9) NOT NULL, `pingid` char(9) NOT NULL, PRIMARY KEY (`beipingid`), KEY `pingid` (`pingid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of beiping_ping -- ---------------------------- INSERT INTO `beiping_ping` VALUES ('091313503', '091313502'); INSERT INTO `beiping_ping` VALUES ('091313501', '091313512'); INSERT INTO `beiping_ping` VALUES ('091313504', '091313512'); -- ---------------------------- -- Table structure for `department` -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `departmentid` char(3) NOT NULL, `departmentname` varchar(8) NOT NULL, `duty` varchar(50) DEFAULT NULL, PRIMARY KEY (`departmentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of department -- ---------------------------- INSERT INTO `department` VALUES ('201', '技术部', '写代码写到死也绝不说半个“不”字'); INSERT INTO `department` VALUES ('202', '销售部', '别人再拒绝你也绝不皱一下眉毛'); INSERT INTO `department` VALUES ('203', '设计部', '把网面设计得让人忍不住想用脸贴一下'); INSERT INTO `department` VALUES ('300', '公司总部', '管理各个部门'); -- ---------------------------- -- Table structure for `grade` -- ---------------------------- DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `grade` varchar(8) NOT NULL, `from` tinyint(4) NOT NULL, `to` tinyint(4) NOT NULL, `award` int(11) DEFAULT NULL, PRIMARY KEY (`grade`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of grade -- ---------------------------- INSERT INTO `grade` VALUES ('优秀', '88', '100', null); INSERT INTO `grade` VALUES ('待开除', '0', '60', null); INSERT INTO `grade` VALUES ('良好', '75', '87', null); INSERT INTO `grade` VALUES ('还行', '60', '74', null); -- ---------------------------- -- Table structure for `position` -- ---------------------------- DROP TABLE IF EXISTS `position`; CREATE TABLE `position` ( `positionid` char(3) NOT NULL, `positionname` varchar(14) NOT NULL, `duty` varchar(50) DEFAULT NULL, `basicsalary` varchar(8) DEFAULT NULL, PRIMARY KEY (`positionid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of position -- ---------------------------- INSERT INTO `position` VALUES ('01', '职工', '职工的本职工作就是加班。晚上加班，周末加班，关键还不加钱。偶也。这个可以', '3200'); INSERT INTO `position` VALUES ('10', '部门经理', '部门经理的职责就是混日子，混啊混，混啊混，混啊混……', '8000'); INSERT INTO `position` VALUES ('20', 'CEO', '老大，全职找小三。', '20000'); -- ---------------------------- -- Table structure for `privilege` -- ---------------------------- DROP TABLE IF EXISTS `privilege`; CREATE TABLE `privilege` ( `privilegeid` char(2) NOT NULL DEFAULT '', `privilegename` varchar(20) DEFAULT NULL, `url` varchar(30) DEFAULT NULL, PRIMARY KEY (`privilegeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of privilege -- ---------------------------- INSERT INTO `privilege` VALUES ('01', '用户管理', 'alluser.jsp'); INSERT INTO `privilege` VALUES ('02', '部门管理', 'alldept.jsp'); INSERT INTO `privilege` VALUES ('03', '岗位管理', 'allpost.jsp'); INSERT INTO `privilege` VALUES ('04', '角色管理', 'allrole.jsp'); INSERT INTO `privilege` VALUES ('05', '方案管理', 'project.jsp'); INSERT INTO `privilege` VALUES ('06', '模板管理', 'moban.jsp'); INSERT INTO `privilege` VALUES ('07', '指标管理', 'indicator.jsp'); INSERT INTO `privilege` VALUES ('08', '打分', 'score.jsp'); INSERT INTO `privilege` VALUES ('09', '查看自己成绩以便申诉', 'mymark.jsp'); INSERT INTO `privilege` VALUES ('10', '申诉处理', 'allappeal.jsp'); INSERT INTO `privilege` VALUES ('11', '结果审核', 'shenhe.jsp'); INSERT INTO `privilege` VALUES ('12', '查看自己的申诉', 'myappeal.jsp'); INSERT INTO `privilege` VALUES ('13', '权限管理', 'allprivilege.jsp'); INSERT INTO `privilege` VALUES ('14', '为用户分配角色', 'userrole.jsp'); -- ---------------------------- -- Table structure for `project` -- ---------------------------- DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `pingid` char(9) NOT NULL, `templateid` char(1) NOT NULL, `begintime` date NOT NULL, `deadtime` date DEFAULT NULL, `beipingscope` varchar(250) DEFAULT NULL, PRIMARY KEY (`pingid`), KEY `projectTemplate` (`templateid`), CONSTRAINT `projectTemplate` FOREIGN KEY (`templateid`) REFERENCES `template` (`templateid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of project -- ---------------------------- INSERT INTO `project` VALUES ('091313502', '3', '2013-05-05', '2013-08-05', '091313503余波<br>'); INSERT INTO `project` VALUES ('091313512', '1', '2013-05-06', '2013-06-06', '091313501孙腾飞<br>091313504陈潇雨<br>'); -- ---------------------------- -- Table structure for `role` -- ---------------------------- DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `roleid` char(1) NOT NULL DEFAULT '0', `rolename` varchar(5) NOT NULL, `privilegescope` varchar(80) DEFAULT NULL, PRIMARY KEY (`roleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of role -- ---------------------------- INSERT INTO `role` VALUES ('1', '被评估对象', '1、查看并修改个人信息<br>2、用户管理<br>3、查看自己成绩以便申诉<br>4、查看自己的申诉'); INSERT INTO `role` VALUES ('2', '评估人', '1、查看并修改个人信息<br>2、打分'); INSERT INTO `role` VALUES ('3', '处理申诉人', '1、查看并修改个人信息<br>2、申诉处理'); INSERT INTO `role` VALUES ('4', '审核人', '1、查看并修改个人信息<br>2、结果审核'); INSERT INTO `role` VALUES ('5', '绩效专员', '1、查看并修改个人信息<br>2、方案管理<br>3、模板管理<br>4、指标管理'); INSERT INTO `role` VALUES ('6', '系统管理员', '1、查看并修改个人信息<br>2、用户管理<br>3、部门管理<br>4、岗位管理<br>5、角色管理<br>6、权限管理<br>7、为用户分配角色'); -- ---------------------------- -- Table structure for `role_privilege` -- ---------------------------- DROP TABLE IF EXISTS `role_privilege`; CREATE TABLE `role_privilege` ( `privilegeid` char(2) NOT NULL DEFAULT '', `roleid` char(1) NOT NULL DEFAULT '', PRIMARY KEY (`privilegeid`,`roleid`), KEY `roleid` (`roleid`), CONSTRAINT `privilege` FOREIGN KEY (`privilegeid`) REFERENCES `privilege` (`privilegeid`), CONSTRAINT `role` FOREIGN KEY (`roleid`) REFERENCES `role` (`roleid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of role_privilege -- ---------------------------- INSERT INTO `role_privilege` VALUES ('01', '1'); INSERT INTO `role_privilege` VALUES ('09', '1'); INSERT INTO `role_privilege` VALUES ('12', '1'); INSERT INTO `role_privilege` VALUES ('08', '2'); INSERT INTO `role_privilege` VALUES ('10', '3'); INSERT INTO `role_privilege` VALUES ('11', '4'); INSERT INTO `role_privilege` VALUES ('05', '5'); INSERT INTO `role_privilege` VALUES ('06', '5');