public.platform_enabled_capabilities

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

Platform-wide capability enablement (default inherited by every org) — Not: platform_enabled_modules — capabilities are the finer-grained axis

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
capability_key	text		false		workspace_capabilities
created_at	timestamp with time zone	now()	false
id	uuid	gen_random_uuid()	false
source	module_source	‘default’::module_source	false
status	module_status	‘active’::module_status	false
updated_at	timestamp with time zone	now()	false
updated_by	uuid		true

Viewpoints

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

Constraints

Name	Type	Definition
platform_enabled_capabilities_capability_key_fkey	FOREIGN KEY	FOREIGN KEY (capability_key) REFERENCES workspace_capabilities(capability_key) ON DELETE CASCADE
platform_enabled_capabilities_capability_key_key	UNIQUE	UNIQUE (capability_key)
platform_enabled_capabilities_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
platform_enabled_capabilities_capability_key_key	CREATE UNIQUE INDEX platform_enabled_capabilities_capability_key_key ON public.platform_enabled_capabilities USING btree (capability_key)
platform_enabled_capabilities_pkey	CREATE UNIQUE INDEX platform_enabled_capabilities_pkey ON public.platform_enabled_capabilities USING btree (id)

Triggers

Name	Definition
update_platform_enabled_capabilities_updated_at	CREATE TRIGGER update_platform_enabled_capabilities_updated_at BEFORE UPDATE ON public.platform_enabled_capabilities FOR EACH ROW EXECUTE FUNCTION update_updated_at_column()

Relations

erDiagram

"public.platform_enabled_capabilities" |o--|| "public.workspace_capabilities" : "FOREIGN KEY (capability_key) REFERENCES workspace_capabilities(capability_key) ON DELETE CASCADE"

"public.platform_enabled_capabilities" {
  text capability_key FK ""
}
"public.workspace_capabilities" {
  text capability_key ""
  text module_key FK ""
}

---

Generated by tbls