dns_resolutions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
domain text 2147483647 null

{“what”:“Domain name being resolved; primary key.”,“why”:“Uniquely identifies each resolution record; needed to look up a specific domain’s DNS data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.062190216+00:00”}

resolved bool 1 null

{“what”:“Boolean indicating whether resolution returned any records.”,“why”:“Distinguishes successful from failed lookups; needed to filter out invalid domains.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.145371364+00:00”}

cdn_class text 2147483647 √ null

{“what”:“CDN provider category (e.g., Cloudflare, Akamai) if identified.”,“why”:“Allows grouping domains by CDN usage; unknown if missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.181928605+00:00”}

a_records _text 2147483647 √ null

{“what”:“Array of IPv4 addresses returned for the domain.”,“why”:“Maps domain to IPs; without it, no way to connect to the domain.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.226195970+00:00”}

cname_chain _text 2147483647 √ null

{“what”:“Sequence of CNAME aliases from domain to final target.”,“why”:“Shows redirection path; needed to understand domain’s actual host.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.265488470+00:00”}

ns_records _text 2147483647 √ null

{“what”:“Array of authoritative nameserver hostnames.”,“why”:“Identifies DNS hosting provider; needed for delegation analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.282781431+00:00”}

asn int4 10 √ null

{“what”:“Autonomous System Number of the hosting network.”,“why”:“Identifies network operator; missing makes network attribution impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.327523017+00:00”}

hosting_org text 2147483647 √ null

{“what”:“Name of the hosting organization or ISP.”,“why”:“Provides business context; without it, hosting provider is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.337845564+00:00”}

is_parked bool 1 √ null

{“what”:“True if domain appears to be a parked page.”,“why”:“Helps filter out non-active domains; needed for domain classification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.365790011+00:00”}

platform text 2147483647 √ null

{“what”:“Detected web platform or technology (e.g., WordPress, Nginx).”,“why”:“Used to categorize domains by technology stack; missing leaves technology unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.410579168+00:00”}

run_id text 2147483647 √ null

{“what”:“Identifier of the scan or collection run that produced this record.”,“why”:“Allows tracking data provenance and re-running analyses per batch.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.421382140+00:00”}

resolved_at timestamptz 35,6 √ now()

{“what”:“Timestamp when the main DNS resolution was completed.”,“why”:“Provides temporal context; needed to know freshness of data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.452115002+00:00”}

ns_resolved_at timestamptz 35,6 √ null

{“what”:“Timestamp when nameserver records were resolved.”,“why”:“Separates timing of NS lookup from main resolution; needed to assess staleness of NS data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:57.461877634+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dns_resolutions_pkey Primary key Asc domain

Relationships