Platform Catalog & Modules

Synced from docs/generated/erd/ — do not hand-edit.
Regenerate with bun run docs:erd (needs staging reader), then this script runs automatically.
Labels: docs/db/erd-table-labels.yml · Runbook: docs/runbooks/erd-schema-docs.md

Description

Permission catalog, workspace/org/platform module & capability toggles,
autonomy lane catalog, tab definitions, feature adoption. Catalog §1.3, §1.5.

Tables

Permission catalog

Platform permission definitions

Name	Columns	Comment	Type
permission_catalog_entries	7		BASE TABLE
permission_catalog_groups	7		BASE TABLE

Module enablement

What each org/platform/association has turned on

Name	Columns	Comment	Type
association_enabled_capabilities	8		BASE TABLE
association_enabled_modules	8		BASE TABLE
org_enabled_capabilities	8		BASE TABLE
org_enabled_modules	9		BASE TABLE
platform_enabled_capabilities	7		BASE TABLE
platform_enabled_modules	7		BASE TABLE
workspace_capabilities	7		BASE TABLE
workspace_modules	13		BASE TABLE

Autonomy & nav

Trust dials and admin tab catalog

Name	Columns	Comment	Type
autonomy_lane_catalog	12	AL-1 (#2207): global catalog of autonomy lanes (per-capability manual/assistive/automated axis).	BASE TABLE
autonomy_promotions	12	AL-1 (#2207): trust ledger of lane promotion recommendations + decisions.	BASE TABLE
feature_adoption	7		BASE TABLE
org_autonomy_lanes	13	AL-1 (#2207): per-org autonomy lane config (level, policy, kill switch, dry-run).	BASE TABLE
tab_definitions	10		BASE TABLE

-

Name	Columns	Comment	Type
admin_config	6		BASE TABLE
association_shared_settings	8		BASE TABLE
external_integrations	14		BASE TABLE
org_config_overrides	6		BASE TABLE
org_integrations	26		BASE TABLE
organizations	35		BASE TABLE

Relations

erDiagram

"public.admin_config" }o--o| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.association_enabled_capabilities" }o--|| "public.workspace_capabilities" : "FOREIGN KEY (capability_key) REFERENCES workspace_capabilities(capability_key) ON DELETE CASCADE"
"public.association_enabled_modules" }o--|| "public.workspace_modules" : "FOREIGN KEY (module_key) REFERENCES workspace_modules(module_key) ON DELETE CASCADE"
"public.external_integrations" }o--o| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.feature_adoption" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.org_autonomy_lanes" }o--|| "public.autonomy_lane_catalog" : "FOREIGN KEY (lane_key) REFERENCES autonomy_lane_catalog(lane_key) ON DELETE CASCADE"
"public.org_config_overrides" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id) ON DELETE CASCADE"
"public.org_enabled_capabilities" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id) ON DELETE CASCADE"
"public.org_enabled_capabilities" }o--|| "public.workspace_capabilities" : "FOREIGN KEY (capability_key) REFERENCES workspace_capabilities(capability_key) ON DELETE CASCADE"
"public.org_enabled_modules" }o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id) ON DELETE CASCADE"
"public.org_enabled_modules" }o--|| "public.workspace_modules" : "FOREIGN KEY (module_key) REFERENCES workspace_modules(module_key) ON DELETE CASCADE"
"public.org_integrations" |o--|| "public.organizations" : "FOREIGN KEY (org_id) REFERENCES organizations(id)"
"public.permission_catalog_entries" }o--|| "public.permission_catalog_groups" : "FOREIGN KEY (group_key) REFERENCES permission_catalog_groups(group_key)"
"public.platform_enabled_capabilities" |o--|| "public.workspace_capabilities" : "FOREIGN KEY (capability_key) REFERENCES workspace_capabilities(capability_key) ON DELETE CASCADE"
"public.platform_enabled_modules" |o--|| "public.workspace_modules" : "FOREIGN KEY (module_key) REFERENCES workspace_modules(module_key) ON DELETE CASCADE"
"public.workspace_capabilities" }o--|| "public.workspace_modules" : "FOREIGN KEY (module_key) REFERENCES workspace_modules(module_key) ON DELETE CASCADE"

"public.admin_config" {
  text org_id ""
}
"public.association_enabled_capabilities" {
  text capability_key ""
}
"public.association_enabled_modules" {
  text module_key ""
}
"public.association_shared_settings" {
}
"public.autonomy_lane_catalog" {
  text lane_key ""
}
"public.autonomy_promotions" {
}
"public.external_integrations" {
  text org_id ""
}
"public.feature_adoption" {
  text org_id ""
}
"public.org_autonomy_lanes" {
  text lane_key ""
}
"public.org_config_overrides" {
  text org_id ""
}
"public.org_enabled_capabilities" {
  text capability_key ""
  text org_id ""
}
"public.org_enabled_modules" {
  text module_key ""
  text org_id ""
}
"public.org_integrations" {
  text org_id ""
}
"public.organizations" {
  text id ""
}
"public.permission_catalog_entries" {
  text group_key ""
}
"public.permission_catalog_groups" {
  text group_key ""
}
"public.platform_enabled_capabilities" {
  text capability_key ""
}
"public.platform_enabled_modules" {
  text module_key ""
}
"public.tab_definitions" {
}
"public.workspace_capabilities" {
  text capability_key ""
  text module_key ""
}
"public.workspace_modules" {
  text module_key ""
}

---

Generated by tbls