/* ================================================================================ 档案代号:ogaa_file 档案名称:出货单INVOICE档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ogaa_file ( ogaa00 varchar2(1), /*No Use */ ogaa01 varchar2(10) NOT NULL, /*No Use */ ogaa011 varchar2(10), /*No Use */ ogaa49 varchar2(16) /*No Use */ ); create unique index ogaa_02 on ogaa_file (ogaa49); create unique index ogaa_pk on ogaa_file (ogaa01); alter table ogaa_file add constraint ogaa_pk primary key (ogaa01) enable validate; grant select on ogaa_file to public; grant index on ogaa_file to public; grant update on ogaa_file to public; grant delete on ogaa_file to public; grant insert on ogaa_file to public; |