/*
================================================================================
档案代号:ido_file
档案名称:ICD厂商WIP资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ido_file
(
ido01       varchar2(20),            /*档案编号                               */
ido02       varchar2(10) DEFAULT '' NOT NULL, /*工厂 facility*/
ido03       varchar2(10) DEFAULT '' NOT NULL, /*厂别 site*/
ido04       varchar2(16),            /*po_no                                  */
ido05       varchar2(80),            /*po_item                                */
ido06       varchar2(80) DEFAULT '' NOT NULL, /*part_no*/
ido07       varchar2(24) DEFAULT '' NOT NULL, /*lot_id*/
ido08       varchar2(1),             /*status                                 */
ido09       number(15,3),            /*input_qty                              */
ido10       number(15,3),            /*qty                                    */
ido11       varchar2(10),            /*stage                                  */
ido12       varchar2(10),            /*operation_code                         */
ido13       varchar2(10),            /*operation                              */
ido14       varchar2(10),            /*oper_no                                */
ido15       varchar2(10),            /*rem_oper_n                             */
ido16       date,                    /*stb_date                               */
ido17       date,                    /*fcst_out                               */
ido18       varchar2(10),            /*os_no                                  */
ido19       varchar2(10),            /*process code                           */
ido20       varchar2(24),            /*os_lot_id                              */
ido21       varchar2(24),            /*lot_attribute                          */
ido22       varchar2(10),            /*eq_name                                */
ido23       number(15,3),            /*良品数量                               */
ido24       number(15,3),            /*不良品数量                             */
ido25       varchar2(80),            /*Wafer Id                               */
idoacti     varchar2(1),             /*资料有效码                             */
idodate     date,                    /*最近修改日                             */
idogrup     varchar2(10),            /*资料所有群                             */
idomodu     varchar2(10),            /*资料更改者                             */
idouser     varchar2(10)             /*资料所有者                             */
);

create unique index ido_pk on ido_file (ido02,ido03,ido06,ido07);
alter table ido_file add  constraint ido_pk primary key  (ido02,ido03,ido06,ido07) enable validate;
grant select on ido_file to public;
grant index on ido_file to public;
grant update on ido_file to public;
grant delete on ido_file to public;
grant insert on ido_file to public;