(Handles: Create/Update/Delete Appointments)

createAppointment(input: {...})

- Validates input

- Writes to Aurora PostgreSQL

{

eventType: "APPOINTMENT_CREATED",

appointmentGuid: "abc-123",

tenantId: "tenant-xyz"

}

(Event-Driven: Updates Read Model)

- Listens to EventBridge

- Fetches related entities (Person, Provider)

- Builds denormalized record

PK: LOCATION#123#2025-01-20

SK: 09:00#APPT#abc-123

------------------------------------

appointmentGuid: "abc-123"

startTime: "2025-01-20T09:00:00Z"

endTime: "2025-01-20T10:00:00Z"

status: "confirmed"

# Denormalized Person Data (no joins!)

personName: "John Doe"

personPhone: "+1-555-1234"

personId: "person-456"

# Denormalized Provider Data

providerName: "Dr. Sarah Smith"

providerCredentials: "MD, PhD"

providerId: "provider-789"

# Denormalized Location Data

locationName: "Physical Therapy - Room 101"

locationAddress: "123 Main St"

# Denormalized Case Data

caseDescription: "Post-op PT"

caseStatus: "active"

# TTL for automatic cleanup

ttl: 1735689600 (90 days)

Global Secondary Indexes:

- GSI1: Provider + Date (provider schedule)

- GSI2: Person ID (patient's appointments)

(Handles: Query Appointments for Scheduler UI)

getSchedulerView(

locationIds: ["location-123"],

date: "2025-01-20"

)

- Constructs DynamoDB query

- Single partition key lookup

KeyConditionExpression:

PK = "LOCATION#123#2025-01-20"

Returns: All appointments with complete data

Response Time: < 50ms ⚡

- Zero joins

- Zero additional Lambda calls

- All data pre-computed and denormalized