discovery_runs


Description

{“what”:“A single execution of the discovery process for a domain.”,“why”:“Without it, there is no record of when and for which domain discovery was performed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.659048710+00:00”}

Columns

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

{“what”:“The website domain (e.g., example.com) that was scanned.”,“why”:“Identifies which site each run belongs to; without it runs are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.723511318+00:00”}

ran_at timestamptz 35,6 now()

{“what”:“UTC timestamp when the run started, set to current time by default.”,“why”:“Provides chronological ordering and allows auditing when each discovery happened.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.761807071+00:00”}

n_content_layouts int4 10 null

{“what”:“Number of distinct content layouts found during the run.”,“why”:“Quantifies the result of the run; without it the run’s outcome is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.788504253+00:00”}

tier text 2147483647 √ null

{“what”:“Optional classification of the run, e.g., ‘full’ or ‘incremental’.”,“why”:“Distinguishes run types; without it all runs are treated equally, losing context for filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:53.884337175+00:00”}

Indexes

Constraint Name Type Sort Column(s)
idx_discovery_runs Performance Asc/Desc domain + ran_at

Relationships