Table mimic.mimiciii.d_items
Dictionary of non-laboratory-related charted items.

 Generated by
SchemaSpy
Legend: SourceForge.net
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
chartevents.itemid chartevents_fk_itemid R
datetimeevents.itemid datetimeevents_fk_itemid R
inputevents_mv.itemid inputevents_mv_fk_itemid R
microbiologyevents.ab_itemid microbiologyevents_fk_ab_itemid R
microbiologyevents.org_itemid microbiologyevents_fk_org_itemid R
microbiologyevents.spec_itemid microbiologyevents_fk_spec_itemid R
outputevents.itemid outputevents_fk_itemid R
procedureevents_mv.itemid procedureevents_mv_fk_itemid R
Primary key. Identifies the charted item.
label varchar 200  √  null Label identifying the item.
abbreviation varchar 100  √  null Abbreviation associated with the item.
dbsource varchar 20  √  null Source database of the item.
linksto varchar 50  √  null Table which contains data for the given ITEMID.
category varchar 100  √  null Category of data which the concept falls under.
unitname varchar 100  √  null Unit associated with the item.
param_type varchar 30  √  null Type of item, for example solution or ingredient.
conceptid int4 10  √  null Identifier used to harmonize concepts identified by multiple ITEMIDs. CONCEPTIDs are planned but not yet implemented (all values are NULL).

Table contained 12,487 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc ditems_rowid_pk
itemid Performance Asc d_items_idx01
label Performance Asc d_items_idx02
itemid Must be unique Asc ditems_itemid_unique

Close relationships  within of separation: