/* ================================================================================ 档案代号: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; |