/*
================================================================================
档案代号:nad_file
档案名称:内部银行利率档
档案目的: 储存存款利率档
上游档案:
下游档案:
============.========================.==========================================
*/
create table nad_file
(
nad01       varchar2(4) NOT NULL,    /*币别                                   */
nad02       varchar2(1) NOT NULL,    /*计息类别                               */
nad03       number(20,6),            /*利率                                   */
nad04       varchar2(4),             /*no use                                 */
nadacti     varchar2(1),             /*资料有效码                             */
nadgrup     varchar2(10),            /*资料所有部门                           */
nadmodu     varchar2(10),            /*资料修改者                             */
naddate     date,                    /*最后修改日期                           */
naduser     varchar2(10)             /*资料所有者                             */
);

create unique index nad_pk on nad_file (nad01,nad02);
alter table nad_file add  constraint nad_pk primary key  (nad01,nad02) enable validate;
grant select on nad_file to public;
grant index on nad_file to public;
grant update on nad_file to public;
grant delete on nad_file to public;
grant insert on nad_file to public;