/*
================================================================================
档案代号:gii_file
档案名称:采购料明细档 (单身)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gii_file
(
gii01       varchar2(6) NOT NULL,    /*预测编号                               */
gii02       varchar2(1) NOT NULL,    /*类别                                   */
gii03       varchar2(10) NOT NULL,   /*部门编号                               */
gii04       number(5) NOT NULL,      /*预测年度                               */
gii05       number(5) NOT NULL,      /*预测期别                               */
gii06       number(20,6),            /*预测金额                               */
gii07       number(9,4)              /*机率                                   */
);

create unique index gii_pk on gii_file (gii01,gii02,gii03,gii04,gii05);
alter table gii_file add  constraint gii_pk primary key  (gii01,gii02,gii03,gii04,gii05) enable validate;
grant select on gii_file to public;
grant index on gii_file to public;
grant update on gii_file to public;
grant delete on gii_file to public;
grant insert on gii_file to public;