/*
================================================================================
档案代号:icl_file
档案名称:ICD料件正背印资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icl_file
(
icl01       varchar2(40) NOT NULL,   /*料件编号                               */
icl02       varchar2(10) NOT NULL,   /*类别                                   */
                                     /*1 正印 2 背印 3 正印备注 4 背印备注    */
icl03       varchar2(5) NOT NULL,    /*No.                                    */
icl04       varchar2(1),             /*Date Code否                            */
icl05       varchar2(255),           /*Remark                                 */
icl06       varchar2(1),             /*no use                                 */
iclacti     varchar2(1),             /*资料有效码                             */
icldate     date,                    /*最近修改日                             */
iclgrup     varchar2(10),            /*资料所有群                             */
iclmodu     varchar2(10),            /*资料更改者                             */
icluser     varchar2(10)             /*资料所有者                             */
);

create unique index icl_pk on icl_file (icl01,icl02,icl03);
alter table icl_file add  constraint icl_pk primary key  (icl01,icl02,icl03) enable validate;
grant select on icl_file to public;
grant index on icl_file to public;
grant update on icl_file to public;
grant delete on icl_file to public;
grant insert on icl_file to public;