/* ================================================================================ 档案代号:icf_file 档案名称:ICD料件BIN资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table icf_file ( icf01 varchar2(80) NOT NULL, /*Item */ icf02 varchar2(5) NOT NULL, /*Bin */ icf03 varchar2(255), /*Bin Desc */ icf04 varchar2(1), /*Pass Bin */ icf05 varchar2(1), /*Code */ /*0:Good 1:D/G(Down Grade) 2:Fail */ icf06 varchar2(255), /*Remark */ icf07 varchar2(1), /*no use */ icf08 varchar2(1), /*no use */ icf09 varchar2(1) /*no use */ ); create unique index icf_pk on icf_file (icf01,icf02); alter table icf_file add constraint icf_pk primary key (icf01,icf02) enable validate; grant select on icf_file to public; grant index on icf_file to public; grant update on icf_file to public; grant delete on icf_file to public; grant insert on icf_file to public; |