profile_org_views


Description

{“what”:“Snapshot of a profile’s view of an org function, with metrics and optional contact binding.”,“why”:“Without it, profile-specific org function assessments cannot be stored or compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:11.378639219+00:00”}

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
profiles.id profile_org_views_profile_id_fkey R

{“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
org_functions.slug profile_org_views_org_function_slug_fkey R

{“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
prism_values.slug profile_org_views_prism_value_slug_fkey R

{“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
contacts.id profile_org_views_contact_id_fkey R

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

Relationships