/*
================================================================================
档案代号:nns_file
档案名称:融资贷款担保票据
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nns_file
(
nns01       varchar2(16) NOT NULL,   /*相关单号                               */
nns02       number(5) NOT NULL,      /*行序                                   */
nns03       varchar2(15) NOT NULL,   /*票号                                   */
nns04       varchar2(16),            /*收票单号                               */
nns05       varchar2(1),             /*No Use                                 */
nns06       varchar2(1)              /*No Use                                 */
);

create unique index nns_pk on nns_file (nns01,nns02,nns03);
alter table nns_file add  constraint nns_pk primary key  (nns01,nns02,nns03) enable validate;
grant select on nns_file to public;
grant index on nns_file to public;
grant update on nns_file to public;
grant delete on nns_file to public;
grant insert on nns_file to public;