Table mimic.mimiciii.chartevents
Events occuring on a patient chart.

Generated by
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 chartevents_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10  √  null
admissions.hadm_id chartevents_fk_hadm_id R
Foreign key. Identifies the hospital stay.
icustay_id int4 10  √  null
icustays.icustay_id chartevents_fk_icustay_id R
Foreign key. Identifies the ICU stay.
itemid int4 10  √  null
d_items.itemid chartevents_fk_itemid R
Foreign key. Identifies the charted item.
charttime timestamp 22  √  null Time when the event occured.
storetime timestamp 22  √  null Time when the event was recorded in the system.
cgid int4 10  √  null
caregivers.cgid chartevents_fk_cgid R
Foreign key. Identifies the caregiver.
value varchar 255  √  null Value of the event as a text string.
valuenum float8 17,17  √  null Value of the event as a number.
valueuom varchar 50  √  null Unit of measurement.
warning int4 10  √  null Flag to highlight that the value has triggered a warning.
error int4 10  √  null Flag to highlight an error with the event.
resultstatus varchar 50  √  null Result status of lab data.
stopped varchar 50  √  null Text string indicating the stopped status of an event (i.e. stopped, not stopped).

Table contained 330,712,483 rows at Thu Oct 12 12:29 EDT 2017

Column(s) Type Sort Constraint Name
row_id Primary key Asc chartevents_rowid_pk

Close relationships  within of separation: