/*
================================================================================
档案代号:ngi_file
档案名称:营运中心追索天数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ngi_file
(
ngi01       varchar2(3) NOT NULL,    /*类别                                   */
ngi02       varchar2(10) NOT NULL,   /*营运中心                               */
ngi03       number(5)                /*追索天数                               */
);

create unique index ngi_pk on ngi_file (ngi01,ngi02);
alter table ngi_file add  constraint ngi_pk primary key  (ngi01,ngi02) enable validate;
grant select on ngi_file to public;
grant index on ngi_file to public;
grant update on ngi_file to public;
grant delete on ngi_file to public;
grant insert on ngi_file to public;