/*
================================================================================
档案代号:boe_file
档案名称:成品材料缩放比例档
档案目的:成品材料缩放比例档 假双档
上游档案:
下游档案:
============.========================.==========================================
*/
create table boe_file
(
boe01       varchar2(40) DEFAULT '' NOT NULL, /*主件款式,放单头*/
boe02       varchar2(40) DEFAULT '' NOT NULL, /*元件款式,放单头*/
boe03       varchar2(20) DEFAULT '' NOT NULL, /*主件属性段一,放单身*/
boe04       varchar2(20) DEFAULT '' NOT NULL, /*主件属性段二,放单身*/
boe05       varchar2(20) DEFAULT '' NOT NULL, /*主件属性段三,放单身*/
boe06       varchar2(10) DEFAULT '' NOT NULL, /*部位,放单身*/
boe07       varchar2(20),            /*用量缩放比例公式,放单身,不             */
boe08       varchar2(20)             /*损耗率缩放比率公式，放单身,            */
);

create unique index boe_pk on boe_file (boe01,boe02,boe03,boe04,boe05,boe06);
alter table boe_file add  constraint boe_pk primary key  (boe01,boe02,boe03,boe04,boe05,boe06) enable 
validate;
grant select on boe_file to public;
grant index on boe_file to public;
grant update on boe_file to public;
grant delete on boe_file to public;
grant insert on boe_file to public;