/*
================================================================================
档案代号:gih_file
档案名称:采购预算档 (单头)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gih_file
(
gih01       varchar2(6) NOT NULL,    /*预测编号                               */
gih02       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*类别 1:外购料  2:内购料                */
gih03       varchar2(10) NOT NULL,   /*部门编号                               */
                                     /*部门编号      (输入 '*' 表示全部)      */
gihacti     varchar2(1),             /*资料有效码                             */
gihuser     varchar2(10),            /*资料所有者                             */
gihgrup     varchar2(10),            /*资料所有部门                           */
gihmodu     varchar2(10),            /*资料修改者                             */
gihdate     date                     /*最近修改日                             */
);

create        index gih_02 on gih_file (gih01);
create unique index gih_pk on gih_file (gih01,gih02,gih03);
alter table gih_file add  constraint gih_pk primary key  (gih01,gih02,gih03) enable validate;
grant select on gih_file to public;
grant index on gih_file to public;
grant update on gih_file to public;
grant delete on gih_file to public;
grant insert on gih_file to public;