employee1.sql

来自「开发的一个java web的任务管理系统。」· SQL 代码 · 共 31 行

/*
MySQL Data Transfer
Source Host: localhost
Source Database: datang
Target Host: localhost
Target Database: datang
Date: 2008-4-25 10:44:38
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for employee
-- ----------------------------
CREATE TABLE `employee` (
  `Id` char(8) NOT NULL,
  `managerId` char(8) NOT NULL,
  PRIMARY KEY  (`Id`),
  KEY `hismanager` (`managerId`),
  CONSTRAINT `hismanager` FOREIGN KEY (`managerId`) REFERENCES `employee` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /* 此表中Id字段为人员属性(若此人是manager则首字母为“M”，他的managerId为空；若此人是employee则首字母为“E”，他的managerId必须是本表中已存在的managerId。)，managerId为人员的主管Id; */

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `employee` VALUES ('M0000001', null);
INSERT INTO `employee` VALUES ('M0000002', null);
INSERT INTO `employee` VALUES ('E0000001', 'M0000001');
INSERT INTO `employee` VALUES ('E0000002', 'M0000001');
INSERT INTO `employee` VALUES ('E0000003', 'M0000002');
INSERT INTO `employee` VALUES ('E0000004', 'M0000002');