Organizations Table
Component Detail
Data Layer
medium complexity
Shared Component
backend
0
Dependencies
2
Dependents
0
Entities
0
Integrations
Description
PostgreSQL data component managing the organizations table with row-level tenant isolation enforced at the API layer. Stores organization profile, contact details, billing configuration, and platform preferences. Serves as the source of truth for session bootstrap responses so clients receive the latest org configuration without additional round-trips. No cross-tenant reads are possible through this surface.
organizations-table
Responsibilities
- Persist and retrieve organization profile and configuration fields
- Enforce row-level tenant isolation - no cross-tenant reads permitted
- Provide organization record to session bootstrap queries for client propagation
- Support atomic partial updates with constraint validation and rollback
Interfaces
findById(orgId: string): Promise<Organization>
update(orgId: string, patch: Partial<Organization>): Promise<Organization>
findByMembership(userId: string): Promise<Organization[]>
findAll(): Promise<Organization[]>
create(org: NewOrganization): Promise<Organization>
Relationships
Dependents (2)
Components that depend on this component