Organization Labels Table
Component Detail
Data Layer
low complexity
backend
0
Dependencies
1
Dependents
0
Entities
0
Integrations
Description
PostgreSQL table storing key-value label overrides scoped to organization ID. Each row represents one overridden label key for one organization; any key absent from the table resolves to the platform default at service layer. Enforces uniqueness on (organization_id, key).
organization-labels-table
Responsibilities
- Persist organization-scoped label key-value override pairs
- Support efficient bulk lookup of all overrides for a given organization
- Enforce a unique constraint on (organization_id, key) to prevent duplicate rows
Interfaces
SELECT key, value FROM organization_labels WHERE organization_id = $1
INSERT INTO organization_labels (organization_id, key, value) ON CONFLICT (organization_id, key) DO UPDATE SET value = EXCLUDED.value
DELETE FROM organization_labels WHERE organization_id = $1 AND key = $2