/* ================================================================================ 档案代号:idf_file 档案名称:ICD回货资料厂商设定单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idf_file ( idf01 varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/ idf02 varchar2(1) DEFAULT '' NOT NULL, /*类别*/ /*0.body 1.未测wafer 2.已测wafer */ /*3.未测IC 4.已测IC 9.其他 */ idf03 number(5) DEFAULT '0' NOT NULL, /*顺序*/ idf04 varchar2(20), /*档案编号 */ idf05 varchar2(20), /*栏位编号 */ idf06 varchar2(1), /*no use */ idf07 varchar2(1), /*no use */ idf08 varchar2(1), /*no use */ idf09 varchar2(1), /*no use */ idf10 varchar2(1) /*no use */ ); create unique index idf_pk on idf_file (idf01,idf02,idf03); alter table idf_file add constraint idf_pk primary key (idf01,idf02,idf03) enable validate; grant select on idf_file to public; grant index on idf_file to public; grant update on idf_file to public; grant delete on idf_file to public; grant insert on idf_file to public; |