/*
================================================================================
档案代号:icm_file
档案名称:ICD料件下阶制程料号资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icm_file
(
icm01       varchar2(40) NOT NULL,   /*料件编号                               */
icm02       varchar2(40) NOT NULL,   /*下阶料                                 */
icm03       varchar2(255),           /*Remark                                 */
icm04       varchar2(16),            /*New Code申请单号                       */
icm12       varchar2(1),             /*no use                                 */
icm13       varchar2(1),             /*no use                                 */
icm14       varchar2(1),             /*no use                                 */
icm15       varchar2(1),             /*no use                                 */
icm16       varchar2(1),             /*no use                                 */
icmacti     varchar2(1),             /*资料有效码                             */
icmdate     date,                    /*最近修改日                             */
icmgrup     varchar2(10),            /*资料所有群                             */
icmmodu     varchar2(10),            /*资料更改者                             */
icmuser     varchar2(10)             /*资料所有者                             */
);

create unique index icm_pk on icm_file (icm01,icm02);
alter table icm_file add  constraint icm_pk primary key  (icm01,icm02) enable validate;
grant select on icm_file to public;
grant index on icm_file to public;
grant update on icm_file to public;
grant delete on icm_file to public;
grant insert on icm_file to public;