/*
================================================================================
档案代号:nae_file
档案名称:内部银行利息档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nae_file
(
nae01       varchar2(30) NOT NULL,   /*银行帐号                               */
nae02       varchar2(1),             /*计息类型                               */
nae03       number(20,6),            /*利率                                   */
nae04       date NOT NULL,           /*起息日                                 */
nae05       date NOT NULL,           /*止息日                                 */
nae06       number(20,6),            /*利息金额                               */
nae07       varchar2(16),            /*计息正式单号                           */
nae08       varchar2(10),            /*所属营运中心                           */
naeconf     varchar2(1),             /*确认码                                 */
naeacti     varchar2(1),             /*资料有效码                             */
naeuser     varchar2(10),            /*资料所有者                             */
naegrup     varchar2(10),            /*资料所有部门                           */
naemodu     varchar2(10),            /*资料修改者                             */
naedate     date,                    /*最后修改日期                           */
nae09       varchar2(2)              /*拨入变动码                             */
);

create unique index nae_pk on nae_file (nae01,nae04,nae05);
alter table nae_file add  constraint nae_pk primary key  (nae01,nae04,nae05) enable validate;
grant select on nae_file to public;
grant index on nae_file to public;
grant update on nae_file to public;
grant delete on nae_file to public;
grant insert on nae_file to public;