/*
================================================================================
档案代号:och_file
档案名称:多营运中心信用评等设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table och_file
(
och01       varchar2(10) NOT NULL,   /*信用评等                               */
och02       number(5) NOT NULL,      /*类别                                   */
och03       varchar2(10) NOT NULL    /*营运中心                               */
);

create unique index och_pk on och_file (och01,och02,och03);
alter table och_file add  constraint och_pk primary key  (och01,och02,och03) enable validate;
grant select on och_file to public;
grant index on och_file to public;
grant update on och_file to public;
grant delete on och_file to public;
grant insert on och_file to public;