CREATE TABLE "public"."table"
(
"prefix" integer ,
"paragraph" integer NOT NULL ,
"province" varchar(20) ,
"city_county" varchar(20) ,
"province_simple" varchar(20) ,
"city_county_simple" varchar(20) ,
"isp" varchar(20) ,
"asc_isp" varchar(4) ,
"zip_code" varchar(6) ,
"zone_description" varchar(4) ,
"province_id" varchar(12) ,
"city_county_id" varchar(12) ,
"lng" varchar(15) ,
"lat" varchar(15)
)
WITH (
FILLFACTOR = 100,
OIDS = FALSE
)
;
COMMENT ON COLUMN "public"."table"."prefix" IS '前缀';
COMMENT ON COLUMN "public"."table"."paragraph" IS '号段';
COMMENT ON COLUMN "public"."table"."province" IS '省份';
COMMENT ON COLUMN "public"."table"."city_county" IS '城市';
COMMENT ON COLUMN "public"."table"."province_simple" IS '省份简称';
COMMENT ON COLUMN "public"."table"."city_county_simple" IS '城市简称';
COMMENT ON COLUMN "public"."table"."isp" IS '运营商';
COMMENT ON COLUMN "public"."table"."asc_isp" IS '虚拟运营商归属ISP';
COMMENT ON COLUMN "public"."table"."zip_code" IS '邮编';
COMMENT ON COLUMN "public"."table"."zone_description" IS '区号';
COMMENT ON COLUMN "public"."table"."province_id" IS '省份行政代码';
COMMENT ON COLUMN "public"."table"."city_county_id" IS '城市行政代码';
COMMENT ON COLUMN "public"."table"."lng" IS '经度';
COMMENT ON COLUMN "public"."table"."lat" IS '纬度';
CREATE TABLE "public"."table"
(
"prefix" integer ,
"paragraph" integer NOT NULL ,
"provice_simple" varchar(20) ,
"city_county_simple" varchar(20) ,
"isp" varchar(20) ,
"zip_code" varchar(6) ,
"zone_description" varchar(4)
)
WITH (
FILLFACTOR = 100,
OIDS = FALSE
)
;
COMMENT ON COLUMN "public"."table"."prefix" IS '前缀';
COMMENT ON COLUMN "public"."table"."paragraph" IS '号段';
COMMENT ON COLUMN "public"."table"."provice_simple" IS '省份简称';
COMMENT ON COLUMN "public"."table"."city_county_simple" IS '城市简称';
COMMENT ON COLUMN "public"."table"."isp" IS '运营商';
COMMENT ON COLUMN "public"."table"."zip_code" IS '邮编';
COMMENT ON COLUMN "public"."table"."zone_description" IS '区号';