/* ================================================================================ 档案代号:vna_file 档案名称:aps 存货预配记录维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vna_file ( vna01 varchar2(40) DEFAULT '' NOT NULL, /*料号*/ vna02 varchar2(60) DEFAULT '' NOT NULL, /*配给对象*/ vna03 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ vna04 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ vna05 number(15,3), /*分配量 */ vna06 number(15,3), /*需求数量 */ vna09 number(1) /*锁定 */ ); create unique index vna_pk on vna_file (vna01,vna02,vna03,vna04); alter table vna_file add constraint vna_pk primary key (vna01,vna02,vna03,vna04) enable validate; grant select on vna_file to public; grant index on vna_file to public; grant update on vna_file to public; grant delete on vna_file to public; grant insert on vna_file to public; |