/*
================================================================================
档案代号:bgl_file
档案名称:预估人工/制费/加工费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgl_file
(
bgl01       varchar2(10) NOT NULL,   /*版本                                   */
bgl02       number(5) NOT NULL,      /*年度                                   */
bgl03       number(5) NOT NULL,      /*月份                                   */
bgl04       varchar2(10) NOT NULL,   /*部门编号                               */
bgl05       number(20,6),            /*总人工金额                             */
bgl06       number(20,6),            /*总制费金额                             */
bgl07       number(20,6),            /*总加工金额                             */
bgl08       varchar2(1)              /*No Use                                 */
);

create unique index bgl_pk on bgl_file (bgl01,bgl02,bgl03,bgl04);
alter table bgl_file add  constraint bgl_pk primary key  (bgl01,bgl02,bgl03,bgl04) enable validate;
grant select on bgl_file to public;
grant index on bgl_file to public;
grant update on bgl_file to public;
grant delete on bgl_file to public;
grant insert on bgl_file to public;