org_functions


Description

{“what”:“Catalog of organizational functions, each identified by a unique slug.”,“why”:“Without it, there is no canonical list of functions to reference for roles, permissions, or feature gating.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.219161431+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
slug text 2147483647 null
profile_org_views.org_function_slug profile_org_views_org_function_slug_fkey R

{“what”:“Unique URL-safe identifier, e.g., ‘finance-approver’, used as primary key.”,“why”:“Provides a stable, human-readable key for lookups and foreign key references.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.245607887+00:00”}

name text 2147483647 null

{“what”:“Display name of the function, e.g., ‘Finance Approver’.”,“why”:“Needed for user-facing labels; without it, only the slug is shown, which may be cryptic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.287734612+00:00”}

description text 2147483647 null

{“what”:“Plain-language explanation of what the function does and when it applies.”,“why”:“Clarifies intent for users and admins, preventing misuse or confusion about scope.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.301060635+00:00”}

examples text 2147483647 √ null

{“what”:“Optional usage examples or scenarios, free-form text.”,“why”:“Helps users understand practical application; absence leaves interpretation to description alone.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:32.323894212+00:00”}

Indexes

Constraint Name Type Sort Column(s)
org_functions_pkey Primary key Asc slug

Relationships