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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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)) |