S Skylara Jun 18, 2008 #1 Does anyone know of a template that would be useful in recording laboratory test results? Thank you
P pietlinden Jun 18, 2008 #2 Does anyone know of a template that would be useful in recording laboratory test results? Thank you Click to expand... Hard to answer that without knowing exactly what you're doing. Can a given subject receive more than one of the same test on a given day? Patient/Subject---(1,M)---TestResult---(M,?)---Test TestResult( PatientID PK1, TestID PK2, TestDate, Result) is about the simplest structure you can have. Then you can summarize across time and get averages etc.
Does anyone know of a template that would be useful in recording laboratory test results? Thank you Click to expand... Hard to answer that without knowing exactly what you're doing. Can a given subject receive more than one of the same test on a given day? Patient/Subject---(1,M)---TestResult---(M,?)---Test TestResult( PatientID PK1, TestID PK2, TestDate, Result) is about the simplest structure you can have. Then you can summarize across time and get averages etc.
