Table mimic.mimiciii.inputevents_cv
Events relating to fluid input for patients whose data was originally stored in the CareVue database.

 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.
subject_id int4 10
patients.subject_id inputevents_cv_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10  √  null
admissions.hadm_id inputevents_cv_fk_hadm_id R
Foreign key. Identifies the hospital stay.
icustay_id int4 10  √  null
icustays.icustay_id inputevents_cv_fk_icustay_id R
Foreign key. Identifies the ICU stay.
charttime timestamp 22  √  null Time of that the input was started or received.
itemid int4 10  √  null Foreign key. Identifies the charted item.
amount float8 17,17  √  null Amount of the item administered to the patient.
amountuom varchar 30  √  null Unit of measurement for the amount.
rate float8 17,17  √  null Rate at which the item is being administered to the patient.
rateuom varchar 30  √  null Unit of measurement for the rate.
storetime timestamp 22  √  null Time when the event was recorded in the system.
cgid int4 10  √  null
caregivers.cgid inputevents_cv_fk_cgid R
Foreign key. Identifies the caregiver.
orderid int4 10  √  null Identifier linking items which are grouped in a solution.
linkorderid int4 10  √  null Identifier linking orders across multiple administrations. LINKORDERID is always equal to the first occuring ORDERID of the series.
stopped varchar 30  √  null Event was explicitly marked as stopped. Infrequently used by caregivers.
newbottle int4 10  √  null Indicates when a new bottle of the solution was hung at the bedside.
originalamount float8 17,17  √  null Amount of the item which was originally charted.
originalamountuom varchar 30  √  null Unit of measurement for the original amount.
originalroute varchar 30  √  null Route of administration originally chosen for the item.
originalrate float8 17,17  √  null Rate of administration originally chosen for the item.
originalrateuom varchar 30  √  null Unit of measurement for the rate originally chosen.
originalsite varchar 30  √  null Anatomical site for the original administration of the item.

Table contained 17,527,935 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc inputevents_cv_rowid_pk
subject_id Performance Asc inputevents_cv_idx01
hadm_id Performance Asc inputevents_cv_idx02
icustay_id Performance Asc inputevents_cv_idx03
charttime Performance Asc inputevents_cv_idx04
itemid Performance Asc inputevents_cv_idx05

Close relationships  within of separation: