/*
================================================================================
档案代号:gil_file
档案名称:现金流量表活动科目
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gil_file
(
gil01       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*类别 1.营业 2.投资 3.理财              */
gil02       varchar2(24) NOT NULL,   /*科目编号                               */
gil00       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index gil_pk on gil_file (gil00,gil01,gil02);
alter table gil_file add  constraint gil_pk primary key  (gil00,gil01,gil02) enable validate;
grant select on gil_file to public;
grant index on gil_file to public;
grant update on gil_file to public;
grant delete on gil_file to public;
grant insert on gil_file to public;