/* ================================================================================ 档案代号:idc_file 档案名称:ICD料件/刻号/BIN库存主档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idc_file ( idc01 varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/ idc02 varchar2(10) DEFAULT '' NOT NULL, /*仓库编号*/ idc03 varchar2(10) DEFAULT '' NOT NULL, /*储位编号*/ idc04 varchar2(80) DEFAULT '' NOT NULL, /*批号*/ idc05 varchar2(3) DEFAULT '' NOT NULL, /*刻号*/ idc06 varchar2(5) DEFAULT '' NOT NULL, /*Bin*/ idc07 varchar2(4), /*明细单位 */ idc08 number(15,3), /*数量 */ idc09 varchar2(40), /*母体料号 */ idc10 varchar2(24), /*母批 */ idc11 varchar2(80), /*Datecode */ idc12 number(15,3), /*die数 */ idc13 number(15,6), /*yield */ idc14 varchar2(80), /*test # */ idc15 number(5), /*Deduct */ idc16 varchar2(1), /*pass bin */ idc17 varchar2(1), /*hold批否 */ idc18 varchar2(1), /*no use */ idc19 varchar2(40), /*接单料号 */ idc20 varchar2(255), /*备注 */ idc21 number(15,3) /*已备置量 */ ); create unique index idc_pk on idc_file (idc01,idc02,idc03,idc04,idc05,idc06); alter table idc_file add constraint idc_pk primary key (idc01,idc02,idc03,idc04,idc05,idc06) enable validate; grant select on idc_file to public; grant index on idc_file to public; grant update on idc_file to public; grant delete on idc_file to public; grant insert on idc_file to public; |