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

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
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
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 0 rows at dim. sept. 10 22:12 CEST 2017

Indexes:
Column(s) Type Sort
row_id Primary key Asc
itemid Must be unique Asc

Close relationships  within of separation: