/* ================================================================================ 档案代号:vag_file 档案名称:aps储位主档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vag_file ( vag01 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ vag02 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ vag03 varchar2(40), /*储位名称 */ vag04 number(5), /*优先顺序 */ vag05 number(1) /*客供料 */ ); create unique index vag_pk on vag_file (vag01,vag02); alter table vag_file add constraint vag_pk primary key (vag01,vag02) enable validate; grant select on vag_file to public; grant index on vag_file to public; grant update on vag_file to public; grant delete on vag_file to public; grant insert on vag_file to public; |