/*
================================================================================
档案代号:bof_file
档案名称:分量损耗率资料档
档案目的:分量损耗率资料档 单档多栏
上游档案:
下游档案:
============.========================.==========================================
*/
create table bof_file
(
bof01       varchar2(40) DEFAULT '' NOT NULL, /*主件料号*/
bof02       varchar2(20) DEFAULT '' NOT NULL, /*类型 1-依料号 2-依分群码*/
bof03       varchar2(40) DEFAULT '' NOT NULL, /*元件料号/分群码*/
bof04       number(15,3) DEFAULT '0' NOT NULL, /*生产起始数量*/
bof05       number(15,3) DEFAULT '0' NOT NULL, /*生产截至数量*/
bof06       number(15,6) DEFAULT '0' NOT NULL /*损耗率*/
);

create unique index bof_pk on bof_file (bof01,bof02,bof03,bof04,bof05);
alter table bof_file add  constraint bof_pk primary key  (bof01,bof02,bof03,bof04,bof05) enable validate;
grant select on bof_file to public;
grant index on bof_file to public;
grant update on bof_file to public;
grant delete on bof_file to public;
grant insert on bof_file to public;