表.txt

一个简单的人事管理系统 包含论文 虽然有些简单 但是对于一般的课程设计来说也可以了

CREATE TABLE "dba"."zwxxb" ("zwdh" char(10) NOT NULL DEFAULT NULL, "zwmc" char(20) NOT NULL DEFAULT NULL, "zwql" varchar(50) DEFAULT NULL, "zwgz" float NOT NULL DEFAULT NULL, "zwfl" char(10) DEFAULT NULL , PRIMARY KEY ("zwdh")) ;
CREATE TABLE "dba"."ygjbxxb" ("ygh" char(20) NOT NULL DEFAULT NULL, "ygxm" char(20) NOT NULL DEFAULT NULL, "ygxb" char(2) NOT NULL DEFAULT NULL, "csny" date DEFAULT NULL, "mz" char(15) DEFAULT NULL, "sfzh" char(18) NOT NULL DEFAULT NULL, "hyzk" char(4) DEFAULT NULL, "jkzk" char(8) DEFAULT NULL, "xx" char(2) DEFAULT NULL, "zzmm" char(8) DEFAULT NULL, "jtzz" char(30) NOT NULL DEFAULT NULL, "lxdh" char(15) DEFAULT NULL, "email" char(20) DEFAULT NULL, "gzbm" char(10) NOT NULL DEFAULT NULL, "zwdh" char(10) NOT NULL DEFAULT NULL, "ksgzsj" date NOT NULL DEFAULT NULL , PRIMARY KEY ("ygh") , FOREIGN KEY "[foreign key 1]" ("zwdh" ) REFERENCES "dba"."zwxxb" ON DELETE RESTRICT ) ;
CREATE TABLE "dba"."ygxlxxb" ("ygh" char(20) NOT NULL DEFAULT NULL, "ygxl" char(6) NOT NULL DEFAULT NULL, "ygzy" char(20) NOT NULL DEFAULT NULL, "byxx" char(20) NOT NULL DEFAULT NULL, "bysj" date NOT NULL DEFAULT NULL, "wy1" char(10) DEFAULT NULL, "wy2" char(10) DEFAULT NULL, "sp1" char(6) DEFAULT NULL, "sp2" char(6) DEFAULT NULL , PRIMARY KEY ("ygh") , FOREIGN KEY "[foreign key 1]" ("ygh" ) REFERENCES "dba"."ygjbxxb" ON DELETE RESTRICT ) ;
CREATE TABLE "dba"."ygjfxxb" ("ygh" char(20) NOT NULL DEFAULT NULL, "jfjl" varchar(40) NOT NULL DEFAULT NULL, "jfsj" date NOT NULL DEFAULT NULL, "yy" varchar(100) DEFAULT NULL , PRIMARY KEY ("ygh", "jfjl", "jfsj") , FOREIGN KEY "[foreign key 1]" ("ygh" ) REFERENCES "dba"."ygjbxxb" ON DELETE RESTRICT ) ;
CREATE TABLE "dba"."mima" ("ygxm" char(15) NOT NULL DEFAULT NULL, "ygh" char(20) NOT NULL DEFAULT NULL, "mima" char(16) NOT NULL DEFAULT NULL, "jibie" char(4) NOT NULL DEFAULT NULL , PRIMARY KEY ("ygh")) ;