/*
================================================================================
档案代号:ohg_file
档案名称:客诉单处理说明档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ohg_file
(
ohg01       varchar2(16) NOT NULL,   /*客诉单号                               */
ohg02       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*1.调查结果                             */
                                     /*2.处理对策及改善对策                   */
                                     /*3.审核                                 */
                                     /*4.核决                                 */
                                     /*5.结案注记                             */
ohg03       number(5) NOT NULL,      /*行序                                   */
ohg04       varchar2(255),           /*说明                                   */
ohg05       varchar2(1),             /*No Use                                 */
ohg06       varchar2(1)              /*No Use                                 */
);

create unique index ohg_pk on ohg_file (ohg01,ohg02,ohg03);
alter table ohg_file add  constraint ohg_pk primary key  (ohg01,ohg02,ohg03) enable validate;
grant select on ohg_file to public;
grant index on ohg_file to public;
grant update on ohg_file to public;
grant delete on ohg_file to public;
grant insert on ohg_file to public;