/* ================================================================================ 档案代号:vat_file 档案名称:aps(预测群组冲销) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vat_file ( vat01 varchar2(40) DEFAULT '' NOT NULL, /*主冲销料号*/ vat02 varchar2(40) DEFAULT '' NOT NULL /*被冲销料号*/ ); create unique index vat_pk on vat_file (vat01,vat02); alter table vat_file add constraint vat_pk primary key (vat01,vat02) enable validate; grant select on vat_file to public; grant index on vat_file to public; grant update on vat_file to public; grant delete on vat_file to public; grant insert on vat_file to public; |