/* ================================================================================ 档案代号:vmg_file 档案名称:aps储位维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vmg_file ( vmg01 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ vmg02 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ vmg05 number(1) /*客供料 */ ); create unique index vmg_pk on vmg_file (vmg01,vmg02); alter table vmg_file add constraint vmg_pk primary key (vmg01,vmg02) enable validate; grant select on vmg_file to public; grant index on vmg_file to public; grant update on vmg_file to public; grant delete on vmg_file to public; grant insert on vmg_file to public; |