Table mimic.mimiciii.datetimeevents
Events relating to a datetime.

 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 datetimeevents_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10  √  null
admissions.hadm_id datetimeevents_fk_hadm_id R
Foreign key. Identifies the hospital stay.
icustay_id int4 10  √  null
icustays.icustay_id datetimeevents_fk_icustay_id R
Foreign key. Identifies the ICU stay.
itemid int4 10
d_items.itemid datetimeevents_fk_itemid R
Foreign key. Identifies the charted item.
charttime timestamp 22 Time when the event occured.
storetime timestamp 22 Time when the event was recorded in the system.
cgid int4 10
caregivers.cgid datetimeevents_fk_cgid R
Foreign key. Identifies the caregiver.
value timestamp 22  √  null Value of the event as a text string.
valueuom varchar 50 Unit of measurement.
warning int2 5  √  null Flag to highlight that the value has triggered a warning.
error int2 5  √  null Flag to highlight an error with the event.
resultstatus varchar 50  √  null Result status of lab data.
stopped varchar 50  √  null Event was explicitly marked as stopped. Infrequently used by caregivers.

Table contained 4,485,937 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc datetime_rowid_pk
subject_id Performance Asc datetimeevents_idx01
itemid Performance Asc datetimeevents_idx02
icustay_id Performance Asc datetimeevents_idx03
hadm_id Performance Asc datetimeevents_idx04

Close relationships  within of separation: