/* ================================================================================ 档案代号: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; |