Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('profile_org_views_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for this view record.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.401519148+00:00”} |
||||
| profile_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the profile this view belongs to.”,“why”:“Without it, the view cannot be associated with a specific profile.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.415685077+00:00”} |
|||||
| org_function_slug | text | 2147483647 | null |
|
|
{“what”:“Slug identifying the organizational function (e.g., ‘engineering’).”,“why”:“Without it, the function being viewed is unknown, making the view ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.428667390+00:00”} |
|||||
| prism_value_slug | text | 2147483647 | null |
|
|
{“what”:“Slug for a prism value (e.g., ‘collaboration’) associated with the view.”,“why”:“Without it, the specific prism dimension being measured is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.441586332+00:00”} |
|||||
| binding | text | 2147483647 | 'entity'::text |
|
|
{“what”:“Binding type, default ‘entity’; when ‘contact’, contact_id is set.”,“why”:“Without it, it is unclear whether the view applies to an entity or a specific contact.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.455812782+00:00”} |
|||||
| contact_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the contact when binding is ‘contact’; null otherwise.”,“why”:“Without it, contact-specific views cannot be linked to a contact.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.489913661+00:00”} |
||||
| quant_score | float4 | 8,8 | √ | null |
|
|
{“what”:“Numeric score (unitless) for the view, e.g., a performance metric.”,“why”:“Without it, there is no quantitative measure to compare or rank views.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.503028164+00:00”} |
||||
| headcount | int4 | 10 | √ | null |
|
|
{“what”:“Number of people in the org function at observation time.”,“why”:“Without it, the size of the function is unknown, affecting context for scores.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.522528077+00:00”} |
||||
| pct_of_org | float4 | 8,8 | √ | null |
|
|
{“what”:“Percentage (0-100) of the whole organization that this function represents.”,“why”:“Without it, the relative size of the function cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.536013613+00:00”} |
||||
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text notes about the view.”,“why”:“Without it, additional context or caveats are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.912583317+00:00”} |
||||
| observed_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp (with timezone) when this view was recorded; defaults to current time.”,“why”:“Without it, the temporal validity of the view is unknown, preventing time-series analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:12.062614944+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| profile_org_views_pkey | Primary key | Asc | id |
| idx_pov_binding | Performance | Asc | binding |
| idx_pov_function | Performance | Asc | org_function_slug |
| idx_pov_profile | Performance | Asc | profile_id |
| profile_org_views_profile_id_org_function_slug_prism_value__key | Must be unique | Asc/Asc/Asc | profile_id + org_function_slug + prism_value_slug |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| profile_org_views_quant_score_check | ((quant_score >= (0)::double precision) AND (quant_score <= (100)::double precision)) |
| profile_org_views_binding_check | (binding = ANY (ARRAY['entity'::text, 'individual'::text, 'fused'::text, 'representative'::text])) |