创建表格的sql.txt

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

7.3.1 创建设备代码表格device_code
CREATE TABLE "DMS".device_code 
(
code VARCHAR2(6) NULL, 
name VARCHAR2(20) NULL,  
CONSTRAINT code_code_pk PRIMARY KEY (code)
)
TABLESPACE "USER_DATA";
7.3.2 创建入库表格device_in
CREATE TABLE "DMS".device_in 
(
code VARCHAR2(6)  NOT NULL, 
in_date DATE NOT NULL, 
provider VARCHAR2(20) NULL, 
teleno VARCHAR2(10) NULL, 
in_number NUMBER(6) NULL, 
price NUMBER(6) NULL, 
buyer VARCHAR2(10) NULL,
CONSTRAINT in_date_pk PRIMARY KEY (in_date)
)
TABLESPACE "USER_DATA";
7.3.3 创建出库表格device_out
CREATE TABLE "DMS".device_out 
(
code VARCHAR2(6) NOT NULL, 
department VARCHAR2(20) NULL, 
out_date DATE NULL, 
out_state NUMBER(1) NULL, 
out_person VARCHAR2(10) NULL, 
out_number NUMBER(6) NOT NULL, 
taker VARCHAR2(10) NULL, 
usage VARCHAR2(20) NULL,
CONSTRAINT out_date_pk PRIMARY KEY (out_date)
)
TABLESPACE "USER_DATA";
7.3.4 创建现有库存表device
CREATE TABLE "DMS".device 
(
code VARCHAR2(6) NULL, 
now_number NUMBER(6) NULL,
high_number NUMBER(6) NULL, 
low_number NUMBER(6) NULL,  
total_number NUMBER(6) NULL,  
CONSTRAINT device_code_pk PRIMARY KEY (code)
) 
TABLESPACE "USER_DATA";
7.3.5 创建部门需求表device_need
CREATE TABLE "DMS".device_need
(
code VARCHAR2(10) NOT NULL, 
department VARCHAR2(10) NOT NULL, 
need_number NUMBER(6) NULL, 
begin_date DATE NULL, 
end_date DATE NULL,
)  
TABLESPACE "USER_DATA";
7.3.6 创建设备还库表device_return
CREATE TABLE "DMS".device_return
(
code VARCHAR2(6) NOT NULL, 
department VARCHAR2(20) NULL, 
return_date DATE  NULL, 
keeper VARCHAR2(10) NULL, 
return_number NUMBER(6) NULL,  
return_person VARCHAR2(10) NULL,  
CONSTRAINT return_date_pk PRIMARY KEY (return_date)
) 
TABLESPACE "USER_DATA";
7.3.7 创建设备采购计划表device_wantbuy
CREATE TABLE "DMS".device_wantbuy 
(
code VARCHAR2(6) NOT NULL, 
now_number NUMBER(6) NULL, 
total_number NUMBER(6) NULL, 
max_number NUMBER(6) NULL, 
buy_number NUMBER(6) NULL, 
provider VARCHAR2(20) NULL, 
price NUMBER(6) NULL, 
buy_date DATE NULL,  
CONSTRAINT wantbuy_date_pk PRIMARY KEY (buy_date)
)
TABLESPACE "USER_DATA";
7.3.8 创建操作日志表howdo
CREATE TABLE "DMS".howdo
(
do_user VARCHAR2(10) NOT NULL, 
do_what VARCHAR2(40) NOT NULL, 
do_date DATE NOT NULL, 
) 
TABLESPACE "USER_DATA";