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 |