/*
================================================================================
档案代号:bhb_file
档案名称:费用项目提拨单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bhb_file
(
bhb01       varchar2(10) NOT NULL,   /*版本                                   */
bhb02       number(5) NOT NULL,      /*年度                                   */
bhb03       varchar2(6) NOT NULL,    /*费用项目                               */
bhb04       varchar2(6) NOT NULL,    /*来源费用项目                           */
bhb05       varchar2(1),             /*提拨方式                               */
                                     /*提拨方式 1.固定金额 2.比率             */
bhb06       number(20,6)             /*提拨比率或金额                         */
);

create unique index bhb_pk on bhb_file (bhb01,bhb02,bhb03,bhb04);
alter table bhb_file add  constraint bhb_pk primary key  (bhb01,bhb02,bhb03,bhb04) enable validate;
grant select on bhb_file to public;
grant index on bhb_file to public;
grant update on bhb_file to public;
grant delete on bhb_file to public;
grant insert on bhb_file to public;