---
title: Medical Tables
slug: redshift/medical-tables
icon: {"lucideIcon":"Database"}
docTags: 
createdAt: 2026-10-01T12:34:12.749Z
---

```mermaid
%%{init: {'theme':'base', 'themeVariables': {'primaryColor':'#4CD0E2','primaryTextColor':'#002A32','primaryBorderColor':'#00778F','lineColor':'#00778F','secondaryColor':'#EDF8FA','tertiaryColor':'#FFFFFF','fontFamily':'DM Sans, sans-serif'}}}%%
erDiagram
    pet ||--o{ new_file_cases : pet_id
    new_file_cases }o--|| sale : sale_id
    new_file_cases }o--o| appointment : appointment_id
    new_file_cases }o--|| vets : "vet_id / responsible_id"

    new_file_cases ||--o{ prescriptions : record_id
    prescriptions }o--|| products : product_id

    new_file_cases ||--o{ new_field_values : file_id
    new_field_values }o--|| new_fields : field_id
    new_fields }o--|| new_checkup_groups : "(via row_id / new_group_rows)"
    new_fields ||--o{ new_field_options : field_id
```