/*
================================================================================
档案代号:ooc_file
档案名称:科目类别目档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ooc_file
(
ooc01       varchar2(1) NOT NULL,    /*科目类别                               */
ooc02       varchar2(80),            /*科目类别说明                           */
ooc03       varchar2(24),            /*科目编号                               */
ooc04       varchar2(24)             /*第二科目编码                           */
);

create unique index ooc_pk on ooc_file (ooc01);
alter table ooc_file add  constraint ooc_pk primary key  (ooc01) enable validate;
grant select on ooc_file to public;
grant index on ooc_file to public;
grant update on ooc_file to public;
grant delete on ooc_file to public;
grant insert on ooc_file to public;