/*
================================================================================
档案代号:ohe_file
档案名称:客诉原因代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ohe_file
(
ohe01       varchar2(16) NOT NULL,   /*客诉单号                               */
ohe02       number(5) NOT NULL,      /*行序                                   */
ohe03       varchar2(8),             /*原因代码                               */
ohe04       varchar2(1),             /*No Use                                 */
ohe05       varchar2(1)              /*No Use                                 */
);

create unique index ohe_pk on ohe_file (ohe01,ohe02);
alter table ohe_file add  constraint ohe_pk primary key  (ohe01,ohe02) enable validate;
grant select on ohe_file to public;
grant index on ohe_file to public;
grant update on ohe_file to public;
grant delete on ohe_file to public;
grant insert on ohe_file to public;