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