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