phase2_done


Description

{“what”:“One row per domain that has completed the phase2 processing step.”,“why”:“Without it, there is no record of which domains have been processed, risking duplicate work.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:22.783242246+00:00”}

Columns

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

{“what”:“The domain string (e.g., example.com) that identifies the processed entity.”,“why”:“Primary key; ensures each domain is processed only once and enables lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:22.965650758+00:00”}

clean bool 1 √ null

{“what”:“Boolean flag: true if the domain passed the phase2 cleanliness check.”,“why”:“Without it, we cannot tell which domains are considered clean and which need review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:23.089627800+00:00”}

ran_at timestamptz 35,6 √ now()

{“what”:“Timestamp with time zone of when the phase2 run completed for this domain.”,“why”:“Records when processing happened, needed for audit and scheduling decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:23.105579052+00:00”}

Indexes

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

Relationships