El escenario
A research database stores clinical, biomarker, genetic, medication, and outcome data for heart disease studies, requiring normalized tables and one-to-many relationships from patients to measurements and events.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
01
Bridge table StudyParticipant to model many-to-many patient-study enrollment
02
Separate Biomarker and BiomarkerMeasurement to normalize test definitions and results
03
Link samples to both patients and studies for traceability
Reusable for any clinical research registry or hospital analytics project that integrates longitudinal patient data with samples and genomic results.