/* ================================================================================ 档案代号:nmr_file 档案名称:银行对帐单下载历史记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nmr_file ( nmr01 varchar2(11) NOT NULL, /*银行编号 */ nmr02 date, /*第一次下载日期 */ nmr03 date /*最后一次下载日期 */ ); create unique index nmr_pk on nmr_file (nmr01); alter table nmr_file add constraint nmr_pk primary key (nmr01) enable validate; grant select on nmr_file to public; grant index on nmr_file to public; grant update on nmr_file to public; grant delete on nmr_file to public; grant insert on nmr_file to public; |