Table mimic.mimiciii.d_labitems
Dictionary of laboratory-related items.

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
row_id int4 10 Unique row identifier.
itemid int4 10
labevents.itemid labevents_fk_itemid R
Foreign key. Identifies the charted item.
label varchar 100 Label identifying the item.
fluid varchar 100 Fluid associated with the item, for example blood or urine.
category varchar 100 Category of item, for example chemistry or hematology.
loinc_code varchar 100  √  null Logical Observation Identifiers Names and Codes (LOINC) mapped to the item, if available.

Table contained 753 rows at Thu Oct 12 12:29 EDT 2017

Column(s) Type Sort Constraint Name
row_id Primary key Asc dlabitems_rowid_pk
itemid Performance Asc d_labitems_idx01
label Performance Asc d_labitems_idx02
loinc_code Performance Asc d_labitems_idx03
itemid Must be unique Asc dlabitems_itemid_unique

Close relationships  within of separation: