task.sql

开发的一个java web的任务管理系统。

/*
MySQL Data Transfer
Source Host: localhost
Source Database: datang
Target Host: localhost
Target Database: datang
Date: 2008-4-25 11:09:47
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for task
-- ----------------------------
CREATE TABLE `task` (
  `Id` int(8) NOT NULL auto_increment,
  `managerId` char(8) NOT NULL,
  `employeeId` char(8) NOT NULL,
  PRIMARY KEY  (`Id`),
  KEY `managerId` (`managerId`),
  KEY `employeeId` (`employeeId`),
  CONSTRAINT `managerId` FOREIGN KEY (`managerId`) REFERENCES `employee` (`Id`),
  CONSTRAINT `employeeId` FOREIGN KEY (`employeeId`) REFERENCES `employee` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*  本表中字段Id为任务Id，是八位自增长int类型，无需为其赋值；managerId为外键，与employee表中的Id字段关联，其必须是首字母为“M”的8位的char字段，且此字段在employee表中必须存在；employeeId为外键，与employee表中的Id字段关联，其必须是首字母为“E”的8位的char字段，且此字段在employee表中必须存在。 */
-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `task` VALUES ('1', 'M0000001', 'E0000001');
INSERT INTO `task` VALUES ('2', 'M0000001', 'E0000002');
INSERT INTO `task` VALUES ('3', 'M0000001', 'E0000001');
INSERT INTO `task` VALUES ('4', 'M0000002', 'E0000003');
INSERT INTO `task` VALUES ('5', 'M0000002', 'E0000004');
INSERT INTO `task` VALUES ('6', 'M0000002', 'E0000004');