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