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 |