profile_dimensions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('profile_dimensions_id_seq'::regclass)

{“what”:“Unique numeric identifier for each row.”,“why”:“Provides a stable primary key for referencing and updating rows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.546239583+00:00”}

profile_id int4 10 null
profiles.id profile_dimensions_profile_id_fkey R

{“what”:“Identifier of the profile this dimension score belongs to.”,“why”:“Links each score to its owning profile; without it scores are orphaned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.591603641+00:00”}

dimension_slug text 2147483647 null
dimensions.slug profile_dimensions_dimension_slug_fkey R

{“what”:“Slug naming the dimension being scored, e.g. ‘openness’.”,“why”:“Identifies which dimension the score refers to; without it scores are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.605517987+00:00”}

quant_score float4 8,8 null

{“what”:“Numeric score value for the dimension, likely a float.”,“why”:“Holds the actual measurement; without it the dimension has no quantitative result.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.622577284+00:00”}

tag_slug text 2147483647 √ null
dimension_values.slug profile_dimensions_tag_slug_fkey R

{“what”:“Optional slug for a tag associated with this dimension score.”,“why”:“Allows grouping or filtering scores by tag; without it tag-based queries fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.640050740+00:00”}

surprise float4 8,8 0

{“what”:“Real number indicating unexpectedness of the score, default 0.”,“why”:“Captures deviation from expectation; without it surprise-based ranking is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.655120551+00:00”}

binding text 2147483647 'entity'::text

{“what”:“Scope of the score: ‘entity’ or other binding type.”,“why”:“Determines whether score applies to whole profile or a specific entity; without it scope is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.680692127+00:00”}

contact_id int4 10 √ null
contacts.id profile_dimensions_contact_id_fkey R

{“what”:“Identifier of a contact if the score is bound to one.”,“why”:“Links score to a specific contact when binding is not ‘entity’; without it contact-specific scores are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.697588969+00:00”}

time_context text 2147483647 √ null

{“what”:“Text describing the time period or context of the score.”,“why”:“Allows filtering scores by temporal context; without it time-based analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.708202806+00:00”}

confidence text 2147483647 √ null

{“what”:“Text label for confidence level, e.g. ‘high’.”,“why”:“Indicates reliability of the score; without it low-confidence scores are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.722552309+00:00”}

source text 2147483647 √ null

{“what”:“Origin of the score, e.g. ‘survey’ or ‘inferred’.”,“why”:“Traces data provenance; without it source-based audits fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.741516728+00:00”}

notes text 2147483647 √ null

{“what”:“Free-form notes about the score or its context.”,“why”:“Captures additional human context; without it qualitative details are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.766520722+00:00”}

assigned_at timestamptz 35,6 √ now()

{“what”:“Timestamp when the score was assigned, default current time.”,“why”:“Records when the score was set; without it temporal ordering is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:17.798463219+00:00”}

Indexes

Constraint Name Type Sort Column(s)
profile_dimensions_pkey Primary key Asc id
idx_pd_dimension Performance Asc dimension_slug
idx_pd_profile Performance Asc profile_id
idx_pd_surprise Performance Desc surprise

Check Constraints

Constraint Name Constraint
profile_dimensions_quant_score_check ((quant_score >= (0)::double precision) AND (quant_score <= (100)::double precision))
profile_dimensions_confidence_check (confidence = ANY (ARRAY['observed'::text, 'inferred'::text, 'estimated'::text]))
profile_dimensions_binding_check (binding = ANY (ARRAY['entity'::text, 'individual'::text, 'fused'::text, 'representative'::text]))
profile_dimensions_surprise_check ((surprise >= (0)::double precision) AND (surprise <= (100)::double precision))

Relationships