tier_predictions


Description

{“what”:“Predicted or confirmed tier for a domain, with source and decision metadata.”,“why”:“Without it, tier assignments and their provenance are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:56.044015437+00:00”}

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

Relationships