/*
================================================================================
档案代号:ico_file
档案名称:ICD料件生产资讯资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ico_file
(
ico01       varchar2(16) NOT NULL,   /*单据编号                               */
ico02       number(5) NOT NULL,      /*项次                                   */
ico03       varchar2(10) NOT NULL,   /*类别                                   */
                                     /*1.正印           2.背印                */
                                     /*3.正印备注   4.背印备注                */
                                     /*5.FAB            6.WAFER               */
                                     /*7.单价           8.Multi Die           */
                                     /*9.生产备注                             */
ico04       varchar2(5) NOT NULL,    /*No.                                    */
ico05       varchar2(1),             /*Date Code否                            */
ico06       varchar2(255),           /*Comment                                */
ico07       varchar2(40),            /*料号                                   */
icoacti     varchar2(1),             /*资料有效码                             */
icodate     date,                    /*最近修改日                             */
icogrup     varchar2(10),            /*资料所有群                             */
icomodu     varchar2(10),            /*资料更改者                             */
icouser     varchar2(10)             /*资料所有者                             */
);

create unique index ico_pk on ico_file (ico01,ico02,ico03,ico04);
alter table ico_file add  constraint ico_pk primary key  (ico01,ico02,ico03,ico04) enable validate;
grant select on ico_file to public;
grant index on ico_file to public;
grant update on ico_file to public;
grant delete on ico_file to public;
grant insert on ico_file to public;