Table postgres.mimic.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
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 0 rows at dim. sept. 10 22:12 CEST 2017

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

Close relationships  within of separation: