Database Schema, Enterprise / FHIR R4-aligned

Multi-tenant Postgres · 0 entities · 17 domains · source of truth: prisma/schema.prisma · theme Medical Blue
PKFKUKenum jsondecimalPHItenant FHIR= maps to a FHIR R4 resource
Diagrams need internet (Mermaid via CDN). The table catalogue below works offline.

Where are “Doctor”, “Nurse”, “Hospital”? real-world concepts → entities

Hospital / clinic groupOrganization (legal entity) + Location (facility→building→ward→room→bed)
DoctorPractitioner + PractitionerRole (roleCode = doctor)
Nurse / Head NursePractitioner + PractitionerRole (nurse / head-nurse)
Pharmacist / Lab tech / Technician / Maintenance / Ambulance crewPractitioner + PractitionerRole (one table, role is data, no table per job title)
PatientPatient (+ PatientIdentifier, RelatedPerson, Coverage)
A visit / admissionEncounter (+ Admission, Bed for inpatient)
PrescriptionMedicationRequestMedicationDispenseMedicationAdministration (eMAR)
Lab / imaging orderServiceRequestSpecimenDiagnosticReport / Observation / ImagingStudy
Diagnosis / vitals / lab valueCondition / Observation (FHIR uses one Observation for vitals & labs)