contact_dimensions

{“what”:“Surrogate primary key, auto-incremented via sequence.”,“why”:“Without it, rows lack a unique identifier, making updates and joins ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.363920281+00:00”}

{“what”:“Foreign key to the contact this dimension belongs to.”,“why”:“Without it, the dimension cannot be linked to a specific contact, breaking profile integrity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.393575367+00:00”}

{“what”:“Slug identifying the dimension type, e.g. ‘openness’ or ‘risk_tolerance’.”,“why”:“Without it, the meaning of the score is unknown, so comparisons across contacts are meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.409316866+00:00”}

{“what”:“Numeric value of the dimension, a real number without fixed scale.”,“why”:“Without it, the dimension has no measurable value, so ranking or filtering by score is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.425477402+00:00”}

{“what”:“Optional secondary tag for the dimension, e.g. ‘high’ or ‘verified’.”,“why”:“Without it, additional categorization of the dimension is lost, limiting nuanced queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.457068090+00:00”}

{“what”:“Time period the dimension applies to, e.g. ‘current’ or ‘last_quarter’.”,“why”:“Without it, the temporal validity of the score is unknown, causing outdated data to be used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.473709862+00:00”}

{“what”:“Confidence level of the score, e.g. ‘high’, ‘medium’, ‘low’.”,“why”:“Without it, data reliability is unknown, so decisions based on the score may be over-trusted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.510448682+00:00”}

{“what”:“Origin of the dimension data, e.g. ‘survey’ or ‘inferred’.”,“why”:“Without it, the provenance is unknown, making it hard to audit or filter by data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.541497363+00:00”}

{“what”:“Free-form notes about the dimension assignment.”,“why”:“Without it, context or caveats about the score are lost, reducing interpretability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.553484738+00:00”}

{“what”:“Timestamp when the dimension was assigned, defaulting to current time.”,“why”:“Without it, the recency of the assignment is unknown, affecting decisions based on time-sensitive data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:28.588655505+00:00”}