/*
================================================================================
档案代号:rmm_file
档案名称:不良品分析单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rmm_file
(
rmm01       varchar2(16) NOT NULL,   /*不良品分析单单号                       */
rmm02       number(5) NOT NULL,      /*不良品分析单项次                       */
rmm03       varchar2(16),            /*RMA 单号                               */
rmm04       number(5),               /*项次                                   */
rmm05       varchar2(1)              /*判定结果                               */
                                     /* 1.可用                                */
                                     /* 2.不良                                */
                                     /* 3.报废                                */
);

create unique index rmm_pk on rmm_file (rmm01,rmm02);
alter table rmm_file add  constraint rmm_pk primary key  (rmm01,rmm02) enable validate;
grant select on rmm_file to public;
grant index on rmm_file to public;
grant update on rmm_file to public;
grant delete on rmm_file to public;
grant insert on rmm_file to public;