/* ================================================================================ 档案代号: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; |