4.3.1 創建員工津貼表jt
CREATE TABLE "PMS".jt 
(
emp_no VARCHAR2(6) Not NULL, 
jb_date DATE NULL, 
jb_daynumber NUMBER(2) NULL, 
jblb VARCHAR2(3) NULL,  
CONSTRAINT  jt_emp_date_pk  PRIMARY KEY (emp_no, jb_date)
)
TABLESPACE "USER_DATA";
4.3.2 創建考勤管理表格kq
CREATE TABLE "PMS".kq 
(
emp_no VARCHAR2(6) Not NULL, 
qq_date DATE NULL, 
qq_daynumber NUMBER(2) NULL, 
qq_lb VARCHAR2(3) NULL, 
CONSTRAINT  kq_emp_date_pk  PRIMARY KEY (emp_no, qq_date)
)
TABLESPACE "USER_DATA";
4.3.3 創建工資標準表格gzbz
CREATE TABLE "PMS".gzbz 
(
gz NUMBER(3) NOT NULL, 
gz_name VARCHAR2(10) NULL,
gzjbgz NUMBER(6) NULL,  
CONSTRAINT  gzbz_gz_pk  PRIMARY KEY (gz)
)
TABLESPACE "USER_DATA";
4.3.4 創建醫療保險表ylbx
CREATE TABLE "PMS".ylbx 
(
emp_no VARCHAR2(6) NOT NULL, 
ylbxfy NUMBER(6) NULL, 
bxf NUMBER(6) NULL,  
ylbx_date VARCHAR2(6) NULL
CONSTRAINT ylbx_emp_date_pk PRIMARY KEY (emp_no,ylbx_date)
) 
TABLESPACE "USER_DATA";
4.3.5 創建員工基本情況表yg
CREATE TABLE "PMS".yg 
(
emp_no VARCHAR2(6) NOT NULL, 
emp_name VARCHAR2(10) NULL, 
emp_gz VARCHAR2(3) NULL, 
emp_department VARCHAR2(10) NULL,  
emp_time VARCHAR2(6) NULL, 
CONSTRAINT yg_emp_no_pk PRIMARY KEY (emp_no)
) 
TABLESPACE "USER_DATA";
4.3.6創建員工月工資表ygz
CREATE TABLE "PMS".ygz
(
emp_no VARCHAR2(6) NOT NULL, 
jbgz NUMBER(6) NULL, 
jt NUMBER(6) NULL, 
kq NUMBER(6) NULL, 
ylbx NUMBER(6) NULL, 
bx NUMBER(6) NULL, 
ygz_total NUMBER(6) NULL,
ygz_date DATE NULL,  
CONSTRAINT ygz_emp_date_pk PRIMARY KEY (emp_no, ygz_date)
)  
TABLESPACE "USER_DATA";
4.3.7創建員工年終獎金表nzjj
CREATE TABLE "PMS".nzjj 
(
emp_no VARCHAR2(6) NOT NULL, 
nzjj_date VARCHAR2 (4) NULL, 
nzjj NUMBER(6) NULL,  
CONSTRAINT nzjj_emp_date PRIMARY KEY (emp_no, nzjj_date)
)  
TABLESPACE "USER_DATA";