/*
================================================================================
档案代号:rmk_file
档案名称:不良现象/修复代码代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rmk_file
(
rmk01       varchar2(4) NOT NULL,    /*代码                                   */
rmk02       varchar2(80),            /*说明                                   */
rmk03       varchar2(1)              /*码别                                   */
                                     /*码别 1-Defect 2-Repair                 */
);

create unique index rmk_pk on rmk_file (rmk01);
alter table rmk_file add  constraint rmk_pk primary key  (rmk01) enable validate;
grant select on rmk_file to public;
grant index on rmk_file to public;
grant update on rmk_file to public;
grant delete on rmk_file to public;
grant insert on rmk_file to public;