Schema

Database schema

Postgres schema is defined in Drizzle as packages/server/src/db/schema.ts. Migrations live under the monorepo migration workflow (see root drizzle.config.ts and app db:* scripts).

Design principles

Multi-tenant — business entities that belong to a customer workspace include organization_id (or equivalent FK).
Better Auth — users, sessions, accounts, and verifications follow Better Auth conventions (string ids where required).

Enums (Postgres)

Enum	Values
`org_role`	`owner`, `admin`, `member`
`subscription_status`	`active`, `trialing`, `past_due`, `canceled`, `incomplete`
`notification_severity`	`normal`, `critical`
`platform_banner_placement`	`landing`, `app`, `everywhere`
`platform_banner_variant`	`info`, `warning`, `critical`
`task_status`	`backlog`, `todo`, `in_progress`, `in_review`, `done`
`task_priority`	`low`, `medium`, `high`

Core tables

Table	Purpose
`users`	Profiles, email, password hash, Better Auth admin `role`, ban fields, welcome onboarding timestamp.
`organizations`	Workspace name, slug, logo.
`organization_members`	User ↔ org membership and `org_role`. Unique `(organization_id, user_id)`.
`organization_invitations`	Pending invites: email, role, `token_hash`, expiry, accept/revoke timestamps.
`subscriptions`	One row per org: Stripe customer/subscription/price ids, status, period, cancel-at-period-end.
`api_keys`	Per-org API keys: hashed secret, prefix, last used.

Product / operator tables

Table	Purpose
`tasks` / `task_assignees`	Org-scoped tasks and assignees.
`events`	Analytics-style events (optional org/user FKs).
`audit_log_entries`	Org-scoped audit trail.
`webhook_endpoints` / `webhook_deliveries`	Outbound webhooks and delivery log.
`user_notifications` / `user_notification_preferences`	In-app notifications and preferences.
`platform_onboarding_config`	Welcome wizard copy and steps.
`platform_feature_flags`	Operator feature toggles.
`platform_banners`	Announcement bars (placement, variant, schedule).

Better Auth tables

Table	Purpose
`sessions`	Session token, expiry, user id, optional `impersonated_by` (admin impersonation).
`accounts`	OAuth and credential links per provider.
`verifications`	Email verification and reset tokens.

TypeScript types

Drizzle infers $inferSelect / $inferInsert types exported next to each table in schema.ts for use in server code.

Database seeding
Stripe & billing — subscriptions sync