DNS Collector

Tables (3)

dns_c_domain_new (Untitled)

  • domain (pk_domain) — varchar(255) — Primary key — NOT NULL
  • ip_address (PK_ipaddress) — varchar(20) — Primary key — NOT NULL
  • registrar (Field) — varchar(60) — NOT NULL
  • create_date (Field2) — date — NOT NULL
  • expire_date (Field3) — date — NOT NULL
  • email (Field4) — varchar(120)
  • ip_type (Field5) — varchar(120) — NOT NULL
  • is_cloudflare (Field6) — bool — NOT NULL
  • real_ip_address (Field7) — varchar(20) — NOT NULL
  • real_port_no (Field8) — int — NOT NULL

ip_domain_mapping (IP mapping table)

  • ip_address (pk_ipaddress) — varchar(20) — Primary key — NOT NULL
  • domain (pk_domain) — varchar(255) — Primary key — NOT NULL
  • ip_numeric — bigint — NOT NULL

tld_{name} (domain source table)

  • domain (root domain) — varchar(255) — Primary key — NOT NULL