SchemaCraft AI

Zero-Backend 3NF
Quick Domain Presets:
Healthcare Clinical Triage & Emergency Response•
3NF Validated6 TablesLatency: 14.5ms

Relational Entity Graph (3NF Normalized)

Every entity is equipped with a UUID primary key, indexed foreign keys, and cascading integrity constraints.

Primary Key| Foreign Key (Cascade)
HospitalWardhospital_wards

Inpatient hospital wards and specialized emergency departments

8 cols
id
uuidReq
•
ward_code
stringReq
•
name
stringReq
•
department
stringReq
•
capacity
integerReq
•
is_active
booleanReq
•
created_at
timestampReq
•
updated_at
timestampReq
Indexes:
idx_wards_deptidx_wards_code
Doctordoctors

Attending physicians, surgeons, and on-duty triage clinicians

10 cols
id
uuidReq
ward_id
HospitalWarduuidReq
•
license_number
stringReq
•
first_name
stringReq
•
last_name
stringReq
•
specialization
stringReq
•
pager_number
stringReq
•
is_on_call
booleanReq
•
created_at
timestampReq
•
updated_at
timestampReq
Indexes:
idx_doctors_wardidx_doctors_license
Patientpatients

Admitted hospital patients requiring emergency evaluation

9 cols
id
uuidReq
•
mrn
stringReq
•
first_name
stringReq
•
last_name
stringReq
•
date_of_birth
stringReq
•
blood_type
stringReq
•
emergency_contact
string
•
created_at
timestampReq
•
updated_at
timestampReq
Indexes:
idx_patients_mrnidx_patients_name
TriageAssessmenttriage_assessments

Emergency Severity Index (ESI 1-5) clinical triage evaluations and vital records

11 cols
id
uuidReq
patient_id
PatientuuidReq
doctor_id
DoctoruuidReq
•
acuity_level
integerReq
•
chief_complaint
textReq
•
systolic_bp
integerReq
•
heart_rate_bpm
integerReq
•
spo2_percent
integerReq
•
temperature_c
floatReq
•
triage_status
stringReq
•
assessed_at
timestampReq
Indexes:
idx_triage_patientidx_triage_doctoridx_triage_acuity
BedAssignmentbed_assignments

Physical hospital bed occupancy tracking and room assignments

7 cols
id
uuidReq
patient_id
PatientuuidReq
ward_id
HospitalWarduuidReq
•
bed_label
stringReq
•
bed_status
stringReq
•
assigned_at
timestampReq
•
discharged_at
timestamp
Indexes:
idx_bed_patientidx_bed_ward
MedicalAlertmedical_alerts

Automated biometric telemetry threshold alerts and escalation logs

8 cols
id
uuidReq
triage_id
TriageAssessmentuuidReq
•
alert_code
stringReq
•
severity
stringReq
•
trigger_metric
stringReq
•
is_acknowledged
booleanReq
•
acknowledged_by
string
•
created_at
timestampReq
Indexes:
idx_alerts_triageidx_alerts_sev