/*
================================================================================
档案代号:icv_file
档案名称:ICD料件制程资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icv_file
(
icv01       varchar2(40) NOT NULL,   /*母体料号                               */
icv02       varchar2(10) NOT NULL,   /*制程编号                               */
icv03       number(5) NOT NULL,      /*制程序                                 */
icv04       varchar2(10),            /*作业编号                               */
icv05       varchar2(1),             /*制程特性                               */
icv06       varchar2(10)             /*编码原则                               */
);

create unique index icv_pk on icv_file (icv01,icv02,icv03);
alter table icv_file add  constraint icv_pk primary key  (icv01,icv02,icv03) enable validate;
grant select on icv_file to public;
grant index on icv_file to public;
grant update on icv_file to public;
grant delete on icv_file to public;
grant insert on icv_file to public;