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

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc inputevents_cv_rowid_pk

Close relationships  within of separation: