/*
================================================================================
档案代号:nnb_file
档案名称:融资贷款备注
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnb_file
(
nnb01       varchar2(16) NOT NULL,   /*相关单号                               */
nnb02       varchar2(1) NOT NULL,    /*资料性质                               */
                                     /*1:短期融资                             */
                                     /*2:中长期贷款                           */
nnb03       number(5) NOT NULL,      /*行序                                   */
nnb04       varchar2(255)            /*说明                                   */
);

create unique index nnb_pk on nnb_file (nnb01,nnb02,nnb03);
alter table nnb_file add  constraint nnb_pk primary key  (nnb01,nnb02,nnb03) enable validate;
grant select on nnb_file to public;
grant index on nnb_file to public;
grant update on nnb_file to public;
grant delete on nnb_file to public;
grant insert on nnb_file to public;