/*
================================================================================
档案代号:gir_file
档案名称:现金流量群组表
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gir_file
(
gir01       varchar2(6) NOT NULL,    /*群组代码                               */
gir02       varchar2(40),            /*说明                                   */
gir03       varchar2(1),             /*变动分类                               */
                                     /*变动分类 1.营业 2.投资 3.理财          */
gir04       varchar2(1),             /*合并否                                 */
                                     /*合并否(Y/N)                            */
gir05       number(5)                /*行序                                   */
);

create unique index gir_pk on gir_file (gir01);
alter table gir_file add  constraint gir_pk primary key  (gir01) enable validate;
grant select on gir_file to public;
grant index on gir_file to public;
grant update on gir_file to public;
grant delete on gir_file to public;
grant insert on gir_file to public;