/*
================================================================================
档案代号:ohd_file
档案名称:客诉单号单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ohd_file
(
ohd01       varchar2(16) NOT NULL,   /*客诉单号                               */
ohd02       number(5) NOT NULL,      /*行序                                   */
ohd03       varchar2(255),           /*客诉内容说明                           */
ohd04       varchar2(1),             /*No Use                                 */
ohd05       varchar2(1)              /*No Use                                 */
);

create unique index ohd_pk on ohd_file (ohd01,ohd02);
alter table ohd_file add  constraint ohd_pk primary key  (ohd01,ohd02) enable validate;
grant select on ohd_file to public;
grant index on ohd_file to public;
grant update on ohd_file to public;
grant delete on ohd_file to public;
grant insert on ohd_file to public;