/* ================================================================================ 档案代号:pmni_file 档案名称:采购单单身档(行业别档) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmni_file ( pmni01 varchar2(16) DEFAULT '' NOT NULL, /*采购单号*/ pmni02 number(5) DEFAULT '0' NOT NULL, /*采购项次*/ pmniicd01 varchar2(16), /*订单单号 */ pmniicd02 number(5), /*订单项次 */ pmniicd03 varchar2(10), /*Icd作业编号 */ pmniicd04 varchar2(1), /*New Code */ pmniicd05 varchar2(1), /*Low Yield */ pmniicd06 varchar2(1), /*Metal Layer */ pmniicd07 number(15,3), /*FST片数 */ pmniicd08 varchar2(1), /*Multi Die */ pmniicd09 number(15,3), /*Reference Die */ pmniicd10 varchar2(1), /*已转完采购单否 */ pmniicd11 varchar2(80), /*Datecode */ pmniicd12 varchar2(10), /*Wafer Site */ pmniicd13 number(15,3), /*已转Wafer Start采购单数量 */ pmniicd14 varchar2(40), /*内编母体料号 */ pmniicd15 varchar2(40), /*最终料号 */ /*存放接单料号 */ pmniicd16 varchar2(24), /*母批 */ pmniicd17 varchar2(10), /*Wafer厂商 */ pmniicd18 varchar2(10), /*下阶厂商 */ pmnislk01 varchar2(16) /*制单号 */ ); create unique index pmni_pk on pmni_file (pmni01,pmni02); alter table pmni_file add constraint pmni_pk primary key (pmni01,pmni02) enable validate; grant select on pmni_file to public; grant index on pmni_file to public; grant update on pmni_file to public; grant delete on pmni_file to public; grant insert on pmni_file to public; |