상황
A longitudinal heart disease study needs to record patient demographics, follow-up visits, clinical measurements, diagnoses, medications, risk factors, and cardiac events over time.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Modeled Patient as central entity with one-to-many relationships to longitudinal records
02
Used composite VisitProvider table to link visits with providers
03
Separated clinical measurements, diagnoses, medications, risk factors, and outcomes as distinct fact tables
Appropriate for building a research database that tracks patient-level clinical data across multiple time points.