/* ================================================================================ 档案代号:vaj_file 档案名称:aps实体库存 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vaj_file ( vaj01 varchar2(40) DEFAULT '' NOT NULL, /*料号*/ vaj02 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ vaj03 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ vaj04 number(15,3), /*可用量 */ vaj05 varchar2(60) /*库房位置 */ ); create unique index vaj_pk on vaj_file (vaj01,vaj02,vaj03); alter table vaj_file add constraint vaj_pk primary key (vaj01,vaj02,vaj03) enable validate; grant select on vaj_file to public; grant index on vaj_file to public; grant update on vaj_file to public; grant delete on vaj_file to public; grant insert on vaj_file to public; |