/*
================================================================================
档案代号:bgb_file
档案名称:材料预计涨幅档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgb_file
(
bgb01       varchar2(10) NOT NULL,   /*版本                                   */
bgb02       number(5) NOT NULL,      /*年度                                   */
bgb03       number(5) NOT NULL,      /*月份                                   */
bgb04       varchar2(10) NOT NULL,   /*材料类别                               */
bgb05       number(9,4),             /*涨幅                                   */
bgbacti     varchar2(1),             /*资料有效码                             */
bgbuser     varchar2(10),            /*资料所有者                             */
bgbgrup     varchar2(10),            /*资料所有部门                           */
bgbmodu     varchar2(10),            /*资料修改者                             */
bgbdate     date                     /*最近修改日                             */
);

create unique index bgb_pk on bgb_file (bgb01,bgb02,bgb03,bgb04);
alter table bgb_file add  constraint bgb_pk primary key  (bgb01,bgb02,bgb03,bgb04) enable validate;
grant select on bgb_file to public;
grant index on bgb_file to public;
grant update on bgb_file to public;
grant delete on bgb_file to public;
grant insert on bgb_file to public;