测试2

--FAD010受注
create table fad010
(
SZNO VARCHAR2(9),
SXS  VARCHAR2(11),
SPBH varchar2(2),
SLBH VARCHAR2(2),
HYBH VARCHAR2(2),
CHYDR VARCHAR2(8),
ss    varchar2(2),
cc    varchar2(1),
spm   varchar2(4),
constraint fad010 primary key (spbh,ss,cc)
);

--fed010入库
create table fed010
(
spbh varchar2(2),
spm  varchar2(4),
ss   varchar2(2),
cc   varchar2(1),
constraint fed010 primary key (spbh,ss,cc)
);

--fed030出库
create table fed030
(
spbh varchar2(2),
ckr  varchar2(8),
ss   varchar2(2),
cc   varchar2(1),
szno varchar2(9),
cks  number(11) default 0,
constraint fed030 primary key (spbh,ss,cc)
);

--fmd080在库
create table fmd080
(
spbh varchar2(2),
ss   varchar2(2),
cc   varchar2(1),
zks  number(11) default 0,
constraint fmd080 primary key (spbh,ss,cc)
);

--fmd030沙龙
create table fmd030
(
slbh varchar2(2) primary key,
slm varchar2(8)
);

--fmd050商品
create table fmd050
(
spbh varchar2(2),
spm  varchar2(4),
ss   varchar2(2),
cc   varchar2(1),
constraint fmd050 primary key (spbh,ss,cc)
);

--fad020会员
create table fad020
(
hybh varchar2(2) primary key,
hym  varchar2(2)
);