Dimension table: microbiology items
Definition table for all microbiology measurements.
- microbiologyevents on
|Name||Postgres data type|
As the primary key of the table,
itemid is unique to each row.
label column describes the concept which is represented by the
itemid, e.g. “AMPICILLIN”.
category categorizes the
itemid into one of four types:
“SPECIMEN” describes the sample taken to perform the test, “MICROTEST” describes the type of test performed, “ORGANISM” is the biological organism grown, and “ANTIBIOTIC” is the antibiotic used for evaluating sensitivity of an organism.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.