/* ================================================================================ 档案代号:top_file 档案名称:地级市编号维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table top_file ( top01 varchar2(10) NOT NULL, /*地级市代号 */ top02 varchar2(80), /*地级市名称 */ top03 varchar2(10), /*省别代号 */ topacti varchar2(1) /*有效否 */ ); create unique index top_pk on top_file (top01); alter table top_file add constraint top_pk primary key (top01) enable validate; grant select on top_file to public; grant index on top_file to public; grant update on top_file to public; grant delete on top_file to public; grant insert on top_file to public; |