创建表格的sql.txt

数据库pb语言的一些程序示例,给pb学习者参考使用,希望能给大家带来帮助!

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