/* ================================================================================ 档案代号:oer_file 档案名称:订单变更单备注档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oer_file ( oer01 varchar2(16) NOT NULL, /*订单单号 */ oer02 number(5) NOT NULL, /*变更序号 */ oer03 number(5) NOT NULL, /*行序 */ oer04 varchar2(255) /*备注说明 */ ); create unique index oer_pk on oer_file (oer01,oer02,oer03); alter table oer_file add constraint oer_pk primary key (oer01,oer02,oer03) enable validate; grant select on oer_file to public; grant index on oer_file to public; grant update on oer_file to public; grant delete on oer_file to public; grant insert on oer_file to public; |