Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('tier_predictions_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each prediction row.”,“why”:“Provides a stable reference for updates and joins; without it rows cannot be uniquely addressed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.053952865+00:00”} |
|
| domain | text | 2147483647 | null |
|
|
{“what”:“Domain name (e.g., example.com) the prediction applies to.”,“why”:“Identifies which domain the tier decision or prediction concerns; without it the row has no subject.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.066939612+00:00”} |
||
| tier | int2 | 5 | √ | null |
|
|
{“what”:“Predicted or assigned tier level as a small integer (e.g., 1-5).”,“why”:“Records the tier outcome; without it the prediction’s result is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.104214240+00:00”} |
|
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin of the prediction, such as model version or manual entry.”,“why”:“Distinguishes predictions from different sources; without it you cannot attribute or compare reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.113956074+00:00”} |
|
| is_prediction | bool | 1 | false |
|
|
{“what”:“Flag true if the tier is a prediction, false if it is a confirmed/actual tier.”,“why”:“Separates predicted from confirmed tiers; without it you cannot filter for only predictions or only actuals.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.124634016+00:00”} |
||
| decision | text | 2147483647 | √ | null |
|
|
{“what”:“Decision outcome (e.g., ‘approved’, ‘rejected’) associated with the tier.”,“why”:“Records the action taken on the domain; without it the result of the review process is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.154558536+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the row was inserted.”,“why”:“Enables time-based ordering and auditing; without it you cannot know when the prediction was made.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.180902194+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tier_predictions_pkey | Primary key | Asc | id |
| idx_tier_pred_domain | Performance | Asc/Desc | domain + created_at |