/*
================================================================================
档案代号:oer_file
档案名称:订单变更单备注档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oer_file
(
oer01       varchar2(16) NOT NULL,   /*订单单号                               */
oer02       number(5) NOT NULL,      /*变更序号                               */
oer03       number(5) NOT NULL,      /*行序                                   */
oer04       varchar2(255)            /*备注说明                               */
);

create unique index oer_pk on oer_file (oer01,oer02,oer03);
alter table oer_file add  constraint oer_pk primary key  (oer01,oer02,oer03) enable validate;
grant select on oer_file to public;
grant index on oer_file to public;
grant update on oer_file to public;
grant delete on oer_file to public;
grant insert on oer_file to public;