/* ================================================================================ 档案代号:rmr_file 档案名称:RMA序号资料客诉问题明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table rmr_file ( rmr01 varchar2(16) NOT NULL, /*RMA单号 */ rmr02 number(5) NOT NULL, /*RET No. */ /*RET# */ rmr03 number(5) NOT NULL, /*行号 */ rmr04 varchar2(255) /*问题内容 */ ); create unique index rmr_pk on rmr_file (rmr01,rmr02,rmr03); alter table rmr_file add constraint rmr_pk primary key (rmr01,rmr02,rmr03) enable validate; grant select on rmr_file to public; grant index on rmr_file to public; grant update on rmr_file to public; grant delete on rmr_file to public; grant insert on rmr_file to public; |