?? 創建表格的sql.txt
字號:
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";
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -