/*
================================================================================
档案代号:git_file
档案名称:人工输入金额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table git_file
(
git01       varchar2(6) NOT NULL,    /*群组代码                               */
git02       varchar2(24) NOT NULL,   /*科目编号                               */
git03       varchar2(16) NOT NULL,   /*编号                                   */
git06       number(5) NOT NULL,      /*年度                                   */
git07       number(5) NOT NULL,      /*期别                                   */
git04       varchar2(80),            /*说明                                   */
git05       number(20,6),            /*人工输入金额                           */
git00       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index git_pk on git_file (git06,git07,git00,git01,git02,git03);
alter table git_file add  constraint git_pk primary key  (git06,git07,git00,git01,git02,git03) enable 
validate;
grant select on git_file to public;
grant index on git_file to public;
grant update on git_file to public;
grant delete on git_file to public;
grant insert on git_file to public;