创建表格sql语句.txt

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

9.3.1 创建客户信息表格kehu
CREATE TABLE "YXMS".keku 
(
kehu_no VARCHAR2(6) NULL, 
kehu_name VARCHAR2(20) NULL, 
kehu_adress VARCHAR2(30) NULL, 
kehu_sh VARCHAR2(10) NULL, 
kehu_repute VARCHAR2(10) NULL,  
kehu_country VARCHAR2(10) NULL, 
kehu_province VARCHAR2(10) NULL,
CONSTRAINT kehu_kehu_no_pk PRIMARY KEY (kehu_no)
)
TABLESPACE "USER_DATA";
9.3.2 订单信息表dd
CREATE TABLE "YXMS".dd 
(
dd_no VARCHAR2(6) NOT NULL, 
dd_date DATE NULL,
kehu_no VARCHAR2(6) NOT NULL, 
product_no VARCHAR2(6) NOT NULL, 
product_number NUMBER(10) NULL, 
need_date DATE NULL,  
dd_manager VARCHAR2(10) NOT NULL,
dd_flag VARCHAR2(1) DEFAULT '0' NULL,
CONSTRAINT dd_dd_no_pk PRIMARY KEY (dd_no)
)
TABLESPACE "USER_DATA";
9.3.3 创建库存信息表格kc
CREATE TABLE "YXMS".kc 
(
product_no VARCHAR2(6) NOT NULL, 
product_number NUMBER(10) NULL, 
kc_adress VARCHAR2(10) NOT NULL,
CONSTRAINT kc_product_no_pk PRIMARY KEY (product_no)
)
TABLESPACE "USER_DATA";
9.3.4 创建发货信息表fh
CREATE TABLE "YXMS".fh 
(
fh_date DATE NULL,
kehu_no  VARCHAR2(6) NOT NULL, 
product_no VARCHAR2(6) NOT NULL, 
product_number NUMBER(10) NULL, 
product_outprice NUMBER(10) NULL, 
fh_manager VARCHAR2(10) NOT NULL,
dd_no  VARCHAR2(6) NOT NULL, 
CONSTRAINT fh_dd_no_pk PRIMARY KEY (dd_no)
) 
TABLESPACE "USER_DATA";
9.3.5 创建产品信息表product
CREATE TABLE "YXMS".product 
(
product_no VARCHAR2(6) NOT NULL, 
product_name VARCHAR2(20) NULL, 
product_NumberPerMonth NUMBER(10) NULL, 
product_adress VARCHAR2(20) NULL,
product_llPerOne NUMBER(6) NULL, 
product_price number(10) null,
product_xh VARCHAR2(6) NULL, 
CONSTRAINT product_product_no_pk PRIMARY KEY (product_no)
) 
TABLESPACE "USER_DATA";
9.3.6创建产品生产表producting
CREATE TABLE "YXMS".producting 
(
product_no VARCHAR2(6) NOT NULL, 
product_Number NUMBER(10) NULL, 
product_outdate DATE NULL,
product_manager  VARCHAR2(10) NULL,
CONSTRAINT producting_product_no_pk PRIMARY KEY (product_no)
)  
TABLESPACE "USER_DATA";
9.3.7创建产品进库信息表jk
CREATE TABLE "YXMS".jk 
(
jk_no varchar2(6) not null,
product_no VARCHAR2(6) NOT NULL, 
product_Number NUMBER(10) NULL, 
product_indate date NULL,
product_manager  VARCHAR2(10) NULL,
CONSTRAINT jk_jk_no_pk PRIMARY KEY (jk_no)
)  
TABLESPACE "USER_DATA";