/*
================================================================================
档案代号:nmn_file
档案名称:借款状况资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nmn_file
(
nmn01       number(5) NOT NULL,      /*资料年度                               */
nmn02       number(5) NOT NULL,      /*资料月份                               */
nmn03       number(5) NOT NULL,      /*项次                                   */
nmn04       number(5),               /*日期                                   */
nmn05       number(20,6),            /*融资金额                               */
nmn06       number(20,6),            /*还款金额                               */
nmn07       number(20,6),            /*融资余额                               */
nmn08       number(5)                /*天数                                   */
);

create unique index nmn_pk on nmn_file (nmn01,nmn02,nmn03);
alter table nmn_file add  constraint nmn_pk primary key  (nmn01,nmn02,nmn03) enable validate;
grant select on nmn_file to public;
grant index on nmn_file to public;
grant update on nmn_file to public;
grant delete on nmn_file to public;
grant insert on nmn_file to public;