/*
================================================================================
档案代号:bga_file
档案名称:预估汇率档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bga_file
(
bga01       varchar2(10) NOT NULL,   /*版本                                   */
bga02       number(5) NOT NULL,      /*年度                                   */
bga03       number(5) NOT NULL,      /*月份                                   */
bga04       varchar2(4) NOT NULL,    /*币别                                   */
bga05       number(20,10),           /*汇率                                   */
bgaacti     varchar2(1),             /*资料有效码                             */
bgauser     varchar2(10),            /*资料所有者                             */
bgagrup     varchar2(10),            /*资料所有部门                           */
bgamodu     varchar2(10),            /*资料修改者                             */
bgadate     date                     /*最近修改日                             */
);

create unique index bga_pk on bga_file (bga01,bga02,bga03,bga04);
alter table bga_file add  constraint bga_pk primary key  (bga01,bga02,bga03,bga04) enable validate;
grant select on bga_file to public;
grant index on bga_file to public;
grant update on bga_file to public;
grant delete on bga_file to public;
grant insert on bga_file to public;