Database
Manage DB
Browse collections and tables, and watch the CQRS timing pipeline.
Organization Membersorganization_members
Which users belong to which organization, and with what roles.
π‘
Operational Purpose & Edge Invariants
Managed by the Better Auth organization plugin. A user has one row per organization; `role` is a comma-separated list of owner, admin, director, steward, member. Organization roles apply to every event group the organization runs.
Relational Connections (2)
Table Columns & Types (5)
organization_members| Column | PostgreSQL Type | Constraints | Default | Documentation |
|---|---|---|---|---|
| id | uuid | NOT NULLPK | gen_random_uuid() | Unique membership identifier. |
| organizationId | uuid | NOT NULLFK -> organizations.id | β | Organization. |
| userId | uuid | NOT NULLFK -> users.id | β | Member. |
| role | text | NOT NULL | 'member' | Comma-separated roles: owner, admin, director, steward, member. |
| createdAt | timestamp with time zone | NOT NULL | now() | When the user joined. |
Database Indexes (2)
| Index Name | Columns | Type | Query Performance Rationale |
|---|---|---|---|
| organization_members_org_user_idx | (organizationId, userId) | UNIQUE | One membership row per user per organization. |
| organization_members_user_idx | (userId) | INDEX | Lists a user's organizations. |