/*
================================================================================
档案代号:bgk_file
档案名称:费用基础金额档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgk_file
(
bgk01       varchar2(10) NOT NULL,   /*版本                                   */
bgk02       varchar2(10) NOT NULL,   /*部门编号                               */
bgk03       varchar2(6) NOT NULL,    /*分摊类别                               */
bgk04       number(20,6),            /*金额                                   */
bgk05       varchar2(1)              /*No Use                                 */
);

create unique index bgk_pk on bgk_file (bgk01,bgk02,bgk03);
alter table bgk_file add  constraint bgk_pk primary key  (bgk01,bgk02,bgk03) enable validate;
grant select on bgk_file to public;
grant index on bgk_file to public;
grant update on bgk_file to public;
grant delete on bgk_file to public;
grant insert on bgk_file to public;