/*
================================================================================
档案代号:gis_file
档案名称:现金流量活动科目档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gis_file
(
gis01       varchar2(6) NOT NULL,    /*群组代码                               */
gis02       varchar2(24) NOT NULL,   /*科目编号                               */
gis03       varchar2(1),             /*加减项 +.加项 / -.减项                 */
gis04       varchar2(1),             /*1.异动 2.期初 3.期末 4.人工输          */
                                     /*5.借方异动    6.贷方异动               */
gis00       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index gis_pk on gis_file (gis00,gis01,gis02);
alter table gis_file add  constraint gis_pk primary key  (gis00,gis01,gis02) enable validate;
grant select on gis_file to public;
grant index on gis_file to public;
grant update on gis_file to public;
grant delete on gis_file to public;
grant insert on gis_file to public;