Table mimic.mimiciii.icustays
List of ICU admissions.

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 icustays_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10
admissions.hadm_id icustays_fk_hadm_id R
Foreign key. Identifies the hospital stay.
icustay_id int4 10
chartevents.icustay_id chartevents_fk_icustay_id R
datetimeevents.icustay_id datetimeevents_fk_icustay_id R
inputevents_cv.icustay_id inputevents_cv_fk_icustay_id R
inputevents_mv.icustay_id inputevents_mv_fk_icustay_id R
outputevents.icustay_id outputevents_fk_icustay_id R
prescriptions.icustay_id prescriptions_fk_icustay_id R
procedureevents_mv.icustay_id procedureevents_mv_fk_icustay_id R
transfers.icustay_id transfers_fk_icustay_id R
Primary key. Identifies the ICU stay.
dbsource varchar 20 Source database of the item.
first_careunit varchar 20 First careunit associated with the ICU stay.
last_careunit varchar 20 Last careunit associated with the ICU stay.
first_wardid int2 5 Identifier for the first ward the patient was located in.
last_wardid int2 5 Identifier for the last ward the patient is located in.
intime timestamp 22 Time of admission to the ICU.
outtime timestamp 22  √  null Time of discharge from the ICU.
los float8 17,17  √  null Length of stay in the ICU in fractional days.

Table contained 61,532 rows at Thu Oct 12 12:29 EDT 2017

Column(s) Type Sort Constraint Name
row_id Primary key Asc icustay_rowid_pk
icustay_id Must be unique Asc icustay_icustayid_unique
subject_id Performance Asc icustays_idx01
icustay_id Performance Asc icustays_idx02
hadm_id Performance Asc icustays_idx06

Close relationships  within of separation: