工资管理系统

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";