建立数据库.txt

网上收集到的一套很优秀的PB人事管理系统

部门信息表
CREATE TABLE "T_DEPT"  (
   "DEPT_ID"            NUMBER(4)   NOT NULL,
   "DEPT_CODE"          VARCHAR2(5),
   "DEPT_NAME"          VARCHAR2(10),
   "DEPT_MANAGER"       VARCHAR2(10),
   CONSTRAINT PK_T_DEPT PRIMARY KEY ("DEPT_ID"));
为表 "T_DEPT" 建序列 
CREATE SEQUENCE system.SEQ_DEPT_ID;
员工基本信息表 
CREATE TABLE "T_EMP"  (
   "EMP_ID"             NUMBER(4)                        NOT NULL,
   "DEPT_ID"            NUMBER(4),
   "EMP_CODE"           VARCHAR2(10),
   "DEPT_JOB"           VARCHAR2(10),
   "EMP_JCLASS"         VARCHAR2(10),
   "EMP_DATE"           DATE,
   "EMP_NOWNAME"        VARCHAR2(10),
   "EMP_OLDNAME"        VARCHAR2(10),
   "EMP_ENGNAME"        VARCHAR2(10),
   "EMP_SEX"            VARCHAR2(2),
   "EMP_RSDASZD"        VARCHAR2(255),
   "EMP_HJSZD"          VARCHAR2(255),
   "EMP_NATION"         VARCHAR2(10),
   "EMP_HOMETOWN"       VARCHAR2(255),
   "EMP_BIRTHDAY"       DATE,
   "EMP_MARRIAGE"       VARCHAR2(2),
   "EMP_SFZ"            NUMBER(20),
   "EMP_ZZMM"           VARCHAR2(10),
   "EMP_STATURE"        NUMBER(3),
   "EMP_HEATH"          VARCHAR2(10),
   "EMP_HOMEADDRESS"    VARCHAR2(255),
   "EMP_JTDZYB"         NUMBER(6),
   "EMP_NOWADDRESS"     VARCHAR2(255),
   "EMP_XLXDZYB"        NUMBER(6),
   "EMP_JOBTELE"        NUMBER(20),
   "EMP_TELENO"         NUMBER(20),
   "EMP_HANDTELENO"     NUMBER(20),
   "EMP_EMAIL"          VARCHAR2(20),
   "EMP_XL"             VARCHAR2(10),
   "EMP_MAJOR"          VARCHAR2(30),
   "BY_DATE"            DATE,
   "BY_SCHOOL"          VARCHAR2(10),
   "EMP_GJZC"           VARCHAR2(10),
   "FOREIGN_LANGUAGE"   VARCHAR2(10),
   "FOREIGN_LANGUAGE_CLASS" VARCHAR2(10),
   "LOVER_NAME"         VARCHAR2(10),
   "LOVER_BIRTHDAY"     DATE,
   "LOVER_NATION"       VARCHAR2(10),
   "LOVER_HOMETOWN"     VARCHAR2(255),
   "LOVER_ZZMM"         VARCHAR2(10),
   "LOVER_XL"           VARCHAR2(10),
   "LOVER_SFZ"          NUMBER(20),
   "LOVER_GZDW"         VARCHAR2(255),
   "LOVER_GZJL"         VARCHAR2(255),
   "FATHER_NAME"        VARCHAR2(10),
   "FATHER_GZDW"        VARCHAR2(255),
   "MOTHER_NAME"        VARCHAR2(10),
   "MOTHER_GZDW"        VARCHAR2(255),
   "EMP_JRGSFS"         VARCHAR2(10),
   "EMP_ZPBM"           VARCHAR2(10),
   "EMP_TJR"            VARCHAR2(10),
   "EMP_ZWPJ"           VARCHAR2(255),
   "EMP_QTDYYQ"         VARCHAR2(255),
   "EMP_GRAH"           VARCHAR2(255),
   "EMP_JN"             VARCHAR2(255),
   "EMP_OTHER"          VARCHAR2(255),
   "EMP_QSXM"           VARCHAR2(10),
   "EMP_QSZW"           VARCHAR2(10),
   "EMP_XZ"             VARCHAR2(10),
   CONSTRAINT PK_T_EMP PRIMARY KEY ("EMP_ID"));
为表 "T_EMP" 建序列 
CREATE SEQUENCE system.SEQ_EMP_ID;
个人工作简历表
CREATE TABLE "T_COMPANY"  (
   "COM_ID"             NUMBER(2)                        NOT NULL,
   "EMP_ID"             NUMBER(4),
   "COM_BEG"            DATE,
   "COM_END"            DATE,
   "COM_NAME"           VARCHAR2(10),
   "COM_TEL"            NUMBER(20),
   "COM_DEPT"           VARCHAR2(10),
   "COM_JOB"            VARCHAR2(10),
   "COM_XSRS"           NUMBER(4),
   "COM_ADD"            VARCHAR2(255),
   "COM_YB"             NUMBER(6),
   "COM_JSPT"           VARCHAR2(20),
   "JOB_GZNR"           VARCHAR2(255),
   "HONOR"              VARCHAR2(255),
   "COM_LZYY"           VARCHAR2(255),
   "COM_ZMR"            VARCHAR2(10),
   "COM_ZMRDH"          NUMBER(20),
   CONSTRAINT PK_T_COMPANY PRIMARY KEY ("COM_ID"));
员工考评表
CREATE TABLE "T_EXAM"  (
   "EX_ID"              NUMBER(4)                        NOT NULL,
   "EMP_ID"             NUMBER(4),
   "EX_DATE"            DATE,
   "EX_D"               VARCHAR2(255),
   "EX_Q"               VARCHAR2(255),
   "EX_X"               VARCHAR2(255),
   "EX_N"               VARCHAR2(255),
   "EX_BMPY"            VARCHAR2(255),
   "EX_GSPY"            VARCHAR2(255),
   "EX_SFHG"            number(1),
   CONSTRAINT PK_T_EXAM PRIMARY KEY ("EX_ID"));
薪金申报表
CREATE TABLE "T_VAL"  (
   "VAL_ID"             NUMBER(4)                        NOT NULL,
   "EMP_ID"             NUMBER(4),
   "EMP_NAME"           VARCHAR2(10),
   "EMP_BIRTHDAY"       DATE,
   "EMP_DATE"           DATE,
   "EMP_EDU"            VARCHAR2(255),
   "EMP_DEPT"           VARCHAR2(10),
   "EMP_ZC"             VARCHAR2(10),
   "EMP_VAL"            NUMBER(8),
   "EMP_TBR"            VARCHAR2(255),
   "EMP_SHR"            VARCHAR2(255),
   "EMP_LD"             VARCHAR2(255),
   "EMP_SZB"            VARCHAR2(255),
   CONSTRAINT PK_T_VAL PRIMARY KEY ("VAL_ID"));
新员工申明表
CREATE TABLE "T_SM"  (
   "SM_ID"              NUMBER(4)                        NOT NULL,
   "EMP_ID"             NUMBER(4),
   "SM_CLSX"            number(1),
   "SM_YGXZ"            VARCHAR2(255),
   "SM_MM"              number(1),
   CONSTRAINT PK_T_SM PRIMARY KEY ("SM_ID"));
应聘员工登记表
CREATE TABLE "T_EMP_DZ"  (
   "DZ_ID"              NUMBER(4)                        NOT NULL,
   "EMP_NAME"           VARCHAR2(10),
   "EMP_SEX"            VARCHAR2(2),
   "EMP_NATION"         VARCHAR2(10),
   "EMP_ZZMM"           VARCHAR2(10),
   "EMP-BIRTHDAY"       DATE,
   "EMP_XL"             VARCHAR2(10),
   "EMP_SFZ"            NUMBER(20),
   "EMP_HOMETOWN"       VARCHAR2(255),
   "EMP_EMAIL"          VARCHAR2(20),
   "EMP_HANDTELENO"     NUMBER(20),
   "EMP_HOMEADDRESS"    VARCHAR2(255),
   "EMP_JTDZYB"         NUMBER(6),
   "EMP_TELENO"         NUMBER(20),
   "EMP_XXADDRESS"      VARCHAR2(255),
   "EMP_XXYB"           NUMBER(6),
   "EMP_XXTEL"          NUMBER(20),
   "EMP_DEPT"           VARCHAR2(10),
   "EMP_JOB"            VARCHAR2(20),
   "EMP_HEATH"          VARCHAR2(10),
   CONSTRAINT PK_T_EMP_DZ PRIMARY KEY ("DZ_ID"));
招聘跟踪表
CREATE TABLE "T_ENROL"  (
   "ENROL_ID"           NUMBER(4)                        NOT NULL,
   "DZ_ID"              NUMBER(4),
   "COL_TEL"            VARCHAR2(255),
   "COL_MS"             VARCHAR2(255),
   "COL_BS"             VARCHAR2(255),
   "COL_JL"             number(1),
   "COL_DATEBEG"        DATE,
   "COL_DATEEND"        DATE,
   "COL_SYVAL"          NUMBER(8,2),
   "COL_ZSVAL"          NUMBER(8,2),
   "DEPT_JOB"           VARCHAR2(10),
   CONSTRAINT PK_T_ENROL PRIMARY KEY ("ENROL_ID"));