/*
================================================================================
档案代号:naa_file
档案名称:银行质押资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table naa_file
(
naa00       varchar2(1),             /*1.短期融资 2.中长期融资                */
naa01       varchar2(16) NOT NULL,   /*单号                                   */
naa02       varchar2(30),            /*保证人                                 */
naa03       varchar2(30),            /*担保人一                               */
naa04       varchar2(30)             /*担保人二                               */
);

create unique index naa_pk on naa_file (naa01);
alter table naa_file add  constraint naa_pk primary key  (naa01) enable validate;
grant select on naa_file to public;
grant index on naa_file to public;
grant update on naa_file to public;
grant delete on naa_file to public;
grant insert on naa_file to public;