---
title: Appointment Tables
slug: redshift/appointment-tables
icon: {"lucideIcon":"Database"}
docTags: 
createdAt: 2026-10-01T12:36:50.557Z
---

```mermaid
%%{init: {'theme':'base', 'themeVariables': {'primaryColor':'#4CD0E2','primaryTextColor':'#002A32','primaryBorderColor':'#00778F','lineColor':'#00778F','secondaryColor':'#EDF8FA','tertiaryColor':'#FFFFFF','fontFamily':'DM Sans, sans-serif'}}}%%
erDiagram
    appointment }o--|| pet : patient_id
    appointment }o--|| clinics : clinic_id
    appointment }o--|| vets : vet_id
    appointment }o--o| rooms : room_id
    appointment }o--o| available_services : visit_type_id
    appointment ||--o{ appointment_requests : appointment_id
    appointment ||--o{ appointments_reschedules : appointment_id
    appointment ||--o{ appointment_services : appointment_id
    appointment_services }o--|| service_packages : service_package_id
    appointment ||--o| new_file_cases : appointment_id
```