上传者: slw710793113
|
上传时间: 2021-08-02 15:35:35
|
文件大小: 356KB
|
文件类型: SQL
2016最全的国家省市区地区编码,放在了一个表结构里面,可以轻松调用,
CREATE TABLE "public"."tb_base_district" (
"district_code" varchar(10) NOT NULL,
"district_name" varchar(50),
"district_higher" varchar(10),
"province_code" varchar(10),
"city_code" varchar(10),
"district_level" int4
)
WITH (OIDS=FALSE)
;
COMMENT ON TABLE "public"."tb_base_district" IS '地区表';
COMMENT ON COLUMN "public"."tb_base_district"."district_code" IS '行政区划代码';
COMMENT ON COLUMN "public"."tb_base_district"."district_name" IS '行政区划名称';
COMMENT ON COLUMN "public"."tb_base_district"."district_higher" IS '上级行政区划';