oracle | 全国省市
1.建表
CREATE TABLE "数据库名"."area" (
"id" NUMBER(11) NOT NULL ,
"pid" NUMBER(11) NOT NULL ,
"name" VARCHAR2(255) NOT NULL ,
"visible" NUMBER(4) NOT NULL ,
"displayorder" NUMBER(11) NOT NULL ,
"level" NUMBER(3) NOT NULL ,
PRIMARY KEY ("id")
)