Files
2026-07-08 16:15:37 +02:00

202 lines
8.3 KiB
Plaintext

// AK-P16b (P16) Booking — Calendly-style public booking pages, timezone-aware
// slot calculation, full appointment lifecycle. Aligned to ENTITY-MODEL Domäne 9
// (M06-booking).
//
// AD-21: self-contained schema. `tenantId` / `providerUserId` / `kontaktId` /
// `leadId` / `formSubmissionId` are BARE String scalars (no `@relation` to
// Tenant/User/Kontakt/Lead/Form) → zero merge-conflict surface against the shared
// core + neighbouring module schemas (crm.prisma / calendar.prisma / forms). The
// CRM/Form linkage runs through those bare scalars in the service layer.
// Intra-module relations (Page → Provider / Appointment, Appointment self-reschedule)
// stay inside this file.
//
// Cross-ticket gaps handled per user decision (2026-06-30):
// - leadId stays NULLABLE, reserved for R-P7 (typed CRM Lead not built yet). v1
// post-booking matches/creates a Kontakt + logs an Activity instead.
// - formSubmissionId stays NULLABLE, reserved for AK-P16c (Forms module not built
// yet). v1 stores the standard mini-form answers in `intakeAnswers` JSON.
//
// Slot availability subtracts the Google busy intervals from AK-P16a
// (CalendarEvent.isBusyForAvailability) via the pure availability.ts helpers —
// leak-protection holds: only busy {from,to} intervals cross over, never titles.
//
// RLS ships separately in prisma/rls/booking-isolation.sql (deferred cutover like
// the other modules). The hard double-booking guard (PostgreSQL EXCLUDE USING gist
// over a tstzrange per provider) ships in prisma/rls/booking-constraints.sql — it
// cannot be expressed in the Prisma schema. On the feature branch: `prisma db push`
// + manual `psql -f` for the constraint; the merge migration folds both in (AD-21).
/// Provider-assignment strategy (M06 A.2). v1 implements `first_available` only
/// ("Erster der frei ist"); round_robin / specific_provider_choice → v2. The enum
/// carries all three so the v2 switch is additive (no migration of stored values).
enum BookingAssignmentStrategy {
round_robin
specific_provider_choice
first_available
}
/// Weekday of a weekly availability rule (M06 A.3).
enum BookingDayOfWeek {
monday
tuesday
wednesday
thursday
friday
saturday
sunday
}
/// Date-specific override kind (M06 A.4). `unavailable` blocks the whole day;
/// `custom_window` replaces the standard rule for that date.
enum AvailabilityExceptionKind {
unavailable
custom_window
}
/// Appointment lifecycle status (M06 A.5 / M129). `rescheduled` keeps the old row
/// for history and points forward via `rescheduledFromId` on the successor.
enum AppointmentStatus {
scheduled
held
cancelled
no_show
rescheduled
}
/// Who triggered a cancellation (M06 A.5) — drives the Klartext + auto-mail copy.
enum AppointmentCancelledByKind {
customer
provider
system
}
/// A public booking page (M06 A.1). Tenant-scoped, soft-deletable. `slug` is unique
/// per tenant and powers the public URL `/b/{tenant}/{slug}`. `intakeFormId` is a
/// bare reserved scalar for the AK-P16c Forms module (null = standard mini-form).
model BookingPage {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
tenantId String
createdByUserId String?
slug String
title String
description String?
durationMinutes Int
bufferBeforeMinutes Int @default(0)
bufferAfterMinutes Int @default(0)
slotIncrementMinutes Int @default(15)
minNoticeHours Int @default(4)
maxAdvanceDays Int @default(60)
assignmentStrategy BookingAssignmentStrategy @default(first_available)
confirmationEmailSubject String
confirmationEmailBody String
internalEventTitleTemplate String?
redirectUrlAfterBooking String?
// Reserved bare scalar for AK-P16c (Forms). Null → standard mini-form.
intakeFormId String?
isPublished Boolean @default(false)
isDemoData Boolean @default(false)
archivedAt DateTime?
providers BookingPageProvider[]
appointments Appointment[]
@@unique([tenantId, slug])
@@index([tenantId, archivedAt, isPublished])
}
/// M:N between BookingPage and tenant users who hold its appointments (M06 A.2).
/// `providerUserId` is a bare scalar (no @relation to User, AD-21).
model BookingPageProvider {
id String @id @default(cuid())
createdAt DateTime @default(now())
tenantId String
bookingPageId String
providerUserId String
displayOrder Int @default(0)
isActive Boolean @default(true)
bookingPage BookingPage @relation(fields: [bookingPageId], references: [id], onDelete: Cascade)
@@unique([bookingPageId, providerUserId])
@@index([tenantId, providerUserId])
}
/// Weekly standard availability per tenant user (M06 A.3). Several rows per weekday
/// allowed (e.g. 09:00-12:00 + 14:00-17:00). Times are local "HH:mm" in `timezone`.
model AvailabilityRule {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
tenantId String
providerUserId String
dayOfWeek BookingDayOfWeek
startTime String
endTime String
timezone String
@@index([tenantId, providerUserId, dayOfWeek])
}
/// Date-specific override of the standard rules (M06 A.4). `startTime`/`endTime`
/// only set when kind = custom_window (null for a full-day `unavailable`).
model AvailabilityException {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
tenantId String
providerUserId String
date DateTime @db.Date
kind AvailabilityExceptionKind
startTime String?
endTime String?
reason String?
timezone String
@@index([tenantId, providerUserId, date])
}
/// A booked appointment (M06 A.5). Tenant-scoped. `startAt`/`endAt` are UTC;
/// `timezone` records the booker's IANA zone for display. CRM/Form links are bare
/// nullable scalars (kontaktId set on match/create; leadId reserved for R-P7,
/// formSubmissionId reserved for AK-P16c). `intakeAnswers` holds the v1 mini-form
/// payload. `internalCalendarEventId` points at the local CalendarEvent mirror that
/// blocks the provider's availability (AK-P16a write-path pushes it external later).
model Appointment {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
tenantId String
bookingPageId String
providerUserId String
startAt DateTime
endAt DateTime
timezone String
status AppointmentStatus @default(scheduled)
// CRM linkage (bare scalars, AD-21). leadId reserved for R-P7.
kontaktId String?
leadId String?
// Reserved for AK-P16c Forms. v1 answers live in intakeAnswers.
formSubmissionId String?
intakeAnswers Json @default("{}")
// Local CalendarEvent mirror id + external provider event ids (M06 J.2/J.3).
internalCalendarEventId String?
externalCalendarEventIds Json @default("[]")
cancelledAt DateTime?
cancelledByKind AppointmentCancelledByKind?
cancellationReason String?
rescheduledFromId String?
notesInternal String?
isDemoData Boolean @default(false)
bookingPage BookingPage @relation(fields: [bookingPageId], references: [id], onDelete: Cascade)
rescheduledFrom Appointment? @relation("AppointmentReschedule", fields: [rescheduledFromId], references: [id], onDelete: SetNull)
rescheduledTo Appointment[] @relation("AppointmentReschedule")
@@index([tenantId, providerUserId, startAt])
@@index([tenantId, status, startAt])
@@index([tenantId, kontaktId, startAt])
@@index([bookingPageId, startAt])
}