IP地址查询_iP地址库_ip归属地数据库_iP库-蓝鲸数据-IPv4数据结构—

IPv4数据结构——PostgreSQL数据结构

IPv4扩展版

CREATE TABLE "public"."table"
(
 "ip_start" varchar(15) ,
 "ip_end" varchar(15) ,
 "num_start" bigint ,
 "num_end" bigint ,
 "num" bigint ,
 "land" varchar(4) ,
 "country" varchar(20) ,
 "region" varchar(30) ,
 "city" varchar(30) ,
 "area" varchar(30) ,
 "land_english" varchar(20) ,
 "country_english" varchar(100) ,
 "region_english" varchar(100) ,
 "city_english" varchar(100) ,
 "area_english" varchar(100) ,
 "isp" varchar(50) ,
 "scene" varchar(20) ,
 "asn" varchar(150) ,
 "country_id_2" varchar(2) ,
 "country_id_3" varchar(3) ,
 "international_code" varchar(50) ,
 "currency" varchar(20) ,
 "time_zone" varchar(30) ,
 "utc" varchar(255) ,
 "region_id" varchar(6) ,
 "city_id" varchar(6) ,
 "area_id" varchar(6) ,
 "lat" varchar(15) ,
 "lng" varchar(15) 
)
WITH (
    FILLFACTOR = 100,
    OIDS = FALSE
)
;
COMMENT ON COLUMN "public"."table"."ip_start" IS '起始IP';
COMMENT ON COLUMN "public"."table"."ip_end" IS '结束IP';
COMMENT ON COLUMN "public"."table"."num_start" IS '数字起始IP';
COMMENT ON COLUMN "public"."table"."num_end" IS '数字结束IP';
COMMENT ON COLUMN "public"."table"."num" IS 'IP数量';
COMMENT ON COLUMN "public"."table"."land" IS '大州';
COMMENT ON COLUMN "public"."table"."country" IS '国家';
COMMENT ON COLUMN "public"."table"."region" IS '省份';
COMMENT ON COLUMN "public"."table"."city" IS '城市';
COMMENT ON COLUMN "public"."table"."area" IS '区县';
COMMENT ON COLUMN "public"."table"."land_english" IS '大州英文';
COMMENT ON COLUMN "public"."table"."country_english" IS '国家英文';
COMMENT ON COLUMN "public"."table"."region_english" IS '省份英文';
COMMENT ON COLUMN "public"."table"."city_english" IS '城市英文';
COMMENT ON COLUMN "public"."table"."area_english" IS '区县英文';
COMMENT ON COLUMN "public"."table"."isp" IS '运营商';
COMMENT ON COLUMN "public"."table"."scene" IS '场景';
COMMENT ON COLUMN "public"."table"."asn" IS 'ASN编号';
COMMENT ON COLUMN "public"."table"."country_id_2" IS '国家二位码';
COMMENT ON COLUMN "public"."table"."country_id_3" IS '国家三位码';
COMMENT ON COLUMN "public"."table"."international_code" IS '国际区号';
COMMENT ON COLUMN "public"."table"."currency" IS '主要货币';
COMMENT ON COLUMN "public"."table"."time_zone" IS '时区标识符';
COMMENT ON COLUMN "public"."table"."utc" IS 'UTC偏移量';
COMMENT ON COLUMN "public"."table"."region_id" IS '国内一级行政代码';
COMMENT ON COLUMN "public"."table"."city_id" IS '国内二级行政代码';
COMMENT ON COLUMN "public"."table"."area_id" IS '国内三级行政代码';
COMMENT ON COLUMN "public"."table"."lat" IS '经度';
COMMENT ON COLUMN "public"."table"."lng" IS '纬度';

IPv4基础版

CREATE TABLE "public"."table"
(
 "ip_start" varchar(15) ,
 "ip_end" varchar(15) ,
 "num_start" bigint ,
 "num_end" bigint ,
 "num" bigint ,
 "land" varchar(4) ,
 "region" varchar(30) ,
 "city" varchar(30) ,
 "area" varchar(30) ,
 "country" varchar(20) ,
 "country_english" varchar(100) ,
 "isp" varchar(50) ,
 "country_id" varchar(10) ,
 "international_code" varchar(50) ,
 "region_id" varchar(6) ,
 "city_id" varchar(6) ,
 "area_id" varchar(6) ,
 "lat" varchar(15) ,
 "lng" varchar(15) 
)
WITH (
    FILLFACTOR = 100,
    OIDS = FALSE
)
;
COMMENT ON COLUMN "public"."table"."ip_start" IS '起始IP';
COMMENT ON COLUMN "public"."table"."ip_end" IS '结束IP';
COMMENT ON COLUMN "public"."table"."num_start" IS '数字起始IP';
COMMENT ON COLUMN "public"."table"."num_end" IS '数字结束IP';
COMMENT ON COLUMN "public"."table"."num" IS 'IP数量';
COMMENT ON COLUMN "public"."table"."land" IS '大州';
COMMENT ON COLUMN "public"."table"."region" IS '省份';
COMMENT ON COLUMN "public"."table"."city" IS '城市';
COMMENT ON COLUMN "public"."table"."area" IS '区县';
COMMENT ON COLUMN "public"."table"."country" IS '国家';
COMMENT ON COLUMN "public"."table"."country_english" IS '国家英文';
COMMENT ON COLUMN "public"."table"."isp" IS '运营商';
COMMENT ON COLUMN "public"."table"."country_id" IS '国家代码';
COMMENT ON COLUMN "public"."table"."international_code" IS '国际区号';
COMMENT ON COLUMN "public"."table"."region_id" IS '一级行政代码';
COMMENT ON COLUMN "public"."table"."city_id" IS '二级行政代码';
COMMENT ON COLUMN "public"."table"."area_id" IS '三级行政代码';
COMMENT ON COLUMN "public"."table"."lat" IS '经度';
COMMENT ON COLUMN "public"."table"."lng" IS '纬度';

IPv4简化版

CREATE TABLE "public"."table"
(
 "ip_start" varchar(15) ,
 "ip_end" varchar(15) ,
 "num_start" bigint ,
 "num_end" bigint ,
 "num" bigint ,
 "region" varchar(30) ,
 "country" varchar(20) ,
 "isp" varchar(50) ,
 "international_code" varchar(50) ,
 "lat" varchar(15) ,
 "lng" varchar(15) 
)
WITH (
    FILLFACTOR = 100,
    OIDS = FALSE
)
;
COMMENT ON COLUMN "public"."table"."ip_start" IS '起始IP';
COMMENT ON COLUMN "public"."table"."ip_end" IS '结束IP';
COMMENT ON COLUMN "public"."table"."num_start" IS '数字起始IP';
COMMENT ON COLUMN "public"."table"."num_end" IS '数字结束IP';
COMMENT ON COLUMN "public"."table"."num" IS 'IP数量';
COMMENT ON COLUMN "public"."table"."region" IS '省份';
COMMENT ON COLUMN "public"."table"."country" IS '国家';
COMMENT ON COLUMN "public"."table"."isp" IS '运营商';
COMMENT ON COLUMN "public"."table"."international_code" IS '国际区号';
COMMENT ON COLUMN "public"."table"."lat" IS '经度';
COMMENT ON COLUMN "public"."table"."lng" IS '纬度';