号段数据结构——PostgreSQL数据结构

手机号段扩展版

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 '区号';