shared cases · one platform case (GI / anesthesia share it)
↓ 1──1 (anesthesia_cases.case_id)
anesthesia_cases
THE SPINE — one row per anesthesia case. Every other table FKs to anesthesia_cases.id.
status · anesthesia_type · asa_classification · is_emergency · anesthesiologist_id / crna_id · signatures · is_locked · charge_ticket_status
🟢 Pre-Op
anesthesia_cases 1──1
anesthesia_pre_op
- airway (Mallampati, Cormack grade), baseline vitals, weight/BMI
- history, allergies JSONB, NPO, consent, ASA
Driven by SynForm pre-anesthesia-v1.
🟣 Procedures NEW
anesthesia_cases 1──N
anesthesia_procedures
- 6 SynForm types:
peripheral_block · spinal · epidural · cse · arterial_line · central_line
- form_data JSONB (whole submission) + promoted billing cols: procedure_type, laterality, block_name, ultrasound_guided
Feeds billing via the bridge → see board 2.
🟡 PACU / Recovery
anesthesia_cases 1──1
anesthesia_pacu
- arrival/discharge, disposition, pain (0-10), PONV/airway/oxygenation status
anesthesia_pacu 1──N
anesthesia_pacu_scores
Aldrete time-series (activity·resp·circ·conscious·O₂)
⚪ Audit
cases 1──N
anesthesia_chart_amendments
- Append-only. Who edited which vital/event/med, original→new value, when & why.
INSERT/SELECT only — no UPDATE/DELETE.
🔵 Intra-Op — the live chart (high-frequency time-series)
anesthesia_cases 1──N each (BIGSERIAL for the hot tables)
- anesthesia_vitals — SBP/DBP/MAP/HR/SpO₂/EtCO₂/temp/BIS · source: manual|monitor|HL7
- anesthesia_medications — drug, dose, route, category, bolus/infusion
- anesthesia_events — PatientIn→Induction→Intubation→…→PatientOut
- anesthesia_gas_agents — sevo/des/N₂O, insp/exp %, MAC, flows
- anesthesia_fluids — in/out, crystalloid/colloid/blood, EBL, UO
🔵 Intra-Op — Equipment & lines
anesthesia_cases 1──1
anesthesia_equipment
- airway device (ETT/LMA…), Cormack grade, attempts
- billing flags: has_arterial_line · has_central_line · monitors (ECG/NIBP/SpO₂/EtCO₂/BIS/TOF/TEE) · POCUS
anesthesia_equipment 1──N
anesthesia_vascular_lines
peripheral IV / central / arterial / PICC — type, gauge, site, attempts
⚙️ Device Bridge — HL7 / monitor ingest (optional integration path)
anesthesia_devices
(monitor/vent/gas-machine registry, per org)
──1:N──▶
anesthesia_device_assignments
(device ⇄ case, time-windowed)
──1:N──▶
anesthesia_raw_messages
(raw inbound, audit)
──1:N──▶
anesthesia_observations
(normalized HR=72, SpO₂=98 → feed the chart)
Source: anesthesia migrations under backend/clinical-api/.../Modules/Anesthesia/Migrations + backend/aims-api/database/migrations. Key columns shown are illustrative — full column lists & the ER diagram are in the mermaid artifact.