/*
================================================================================
档案代号:nqb_file
档案名称:营运中心周转金设定
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nqb_file
(
nqb01       varchar2(10) NOT NULL,   /*营运中心                               */
nqb02       date NOT NULL,           /*日期                                   */
nqb03       number(20,6),            /*周转金额                               */
nqbacti     varchar2(1),             /*资料有效码                             */
nqbuser     varchar2(10),            /*资料所有者                             */
nqbgrup     varchar2(10),            /*资料所有群                             */
nqbmodu     varchar2(10),            /*资料更改者                             */
nqbdate     date                     /*最近修改日                             */
);

create unique index nqb_pk on nqb_file (nqb01,nqb02);
alter table nqb_file add  constraint nqb_pk primary key  (nqb01,nqb02) enable validate;
grant select on nqb_file to public;
grant index on nqb_file to public;
grant update on nqb_file to public;
grant delete on nqb_file to public;
grant insert on nqb_file to public;