/* ================================================================================ 档案代号:vmz_file 档案名称:aps 采购令维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vmz_file ( vmz01 varchar2(60) DEFAULT '' NOT NULL, /*采购单编号*/ vmz12 number(1), /*保留 */ vmz16 varchar2(60) /*供给法则编号 */ ); create unique index vmz_pk on vmz_file (vmz01); alter table vmz_file add constraint vmz_pk primary key (vmz01) enable validate; grant select on vmz_file to public; grant index on vmz_file to public; grant update on vmz_file to public; grant delete on vmz_file to public; grant insert on vmz_file to public; |