/*
================================================================================
档案代号:nna_file
档案名称:银行帐户支票簿号档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nna_file
(
nna01       varchar2(11) NOT NULL,   /*银行编号                               */
nna021      date NOT NULL,           /*取票日期                               */
nna02       number(5) NOT NULL,      /*簿号                                   */
nna03       varchar2(15),            /*下次列印支票号                         */
nna04       number(5),               /*支票号码位数                           */
nna05       number(5),               /*后几位连续编号                         */
nna06       varchar2(1),             /*是否套印支票                           */
nna07       varchar2(1),             /*No Use                                 */
nna08       varchar2(1)              /*No Use                                 */
);

create unique index nna_pk on nna_file (nna01,nna021,nna02);
alter table nna_file add  constraint nna_pk primary key  (nna01,nna021,nna02) enable validate;
grant select on nna_file to public;
grant index on nna_file to public;
grant update on nna_file to public;
grant delete on nna_file to public;
grant insert on nna_file to public;