Schema Overview

The Booking Kit’s database schema consists of 23 tables managed by Drizzle ORM with full TypeScript type inference.

Table groups

Table	Description
`providers`	Service providers (doctors, stylists, consultants). Includes `metadata` JSONB for settings.
`event_types`	Bookable services. Duration, price, questions, limits, confirmation mode.
`availability_rules`	Recurring schedules using RRULE. Linked to providers.
`availability_overrides`	Date-specific schedule modifications (block/extend hours).
`bookings`	Customer appointments. `starts_at`/`ends_at` in UTC with `EXCLUDE USING gist`.
`booking_events`	Append-only audit trail for every booking status change.
`out_of_office`	Extended unavailability periods (vacations, leave).

Table	Description
`teams`	Groups of providers with assignment strategy.
`team_members`	Provider membership in teams with role.
`team_event_types`	Event types associated with teams.

Table	Description
`payments`	Payment records linked to bookings. Amount, status, Stripe IDs.

Table	Description
`workflows`	Workflow definitions (trigger, conditions, actions).
`workflow_logs`	Execution history for workflows.
`webhook_subscriptions`	Registered webhook endpoints with triggers and secrets.
`webhook_deliveries`	Delivery attempts with response status and retry count.

Table	Description
`recurring_series`	Recurring booking series metadata (frequency, count).
`seat_attendees`	Individual attendees for group/seat bookings.

Table	Description
`api_keys`	API keys with scopes, rate limits, and expiry.

Table	Description
`organizations`	Tenant organizations with branding and settings.
`organization_members`	User membership in organizations with roles.

All tables include:

Column	Type	Description
`id`	`uuid`	Primary key (auto-generated)
`created_at`	`timestamp`	Row creation time
`updated_at`	`timestamp`	Last modification (auto-updated via trigger)

Most tables include an optional organization_id column for multi-tenancy scoping.

EXCLUDE USING gist (
  provider_id WITH =,
  tstzrange(starts_at, ends_at) WITH &&
) WHERE (status NOT IN ('cancelled', 'rejected'))

Requires the btree_gist extension.

Enum	Values
`booking_status`	`pending`, `confirmed`, `completed`, `cancelled`, `rescheduled`, `no_show`, `rejected`
`payment_status`	`pending`, `succeeded`, `failed`, `refunded`, `partially_refunded`
`payment_type`	`booking`, `cancellation_fee`, `no_show_fee`, `refund`
`assignment_strategy`	`round_robin`, `collective`, `managed`, `fixed`
`recurring_frequency`	`weekly`, `biweekly`, `monthly`
`seat_status`	`confirmed`, `cancelled`, `waitlisted`
`workflow_trigger`	`booking.created`, `booking.confirmed`, `booking.cancelled`, etc.

packages/db/src/schema/
├── tables.ts    # All 23 table definitions
└── enums.ts     # All enum definitions