Table mimic.mimiciii.transfers
Location of patients during their hospital stay.

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 transfers_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10
admissions.hadm_id transfers_fk_hadm_id R
Foreign key. Identifies the hospital stay.
icustay_id int4 10  √  null
icustays.icustay_id transfers_fk_icustay_id R
Foreign key. Identifies the ICU stay.
dbsource varchar 20  √  null Source database of the item.
eventtype varchar 20  √  null Type of event, for example admission or transfer.
prev_careunit varchar 20  √  null Previous careunit.
curr_careunit varchar 20  √  null Current careunit.
prev_wardid int2 5  √  null Identifier for the previous ward the patient was located in.
curr_wardid int2 5  √  null Identifier for the current ward the patient is located in.
intime timestamp 22  √  null Time when the patient was transferred into the unit.
outtime timestamp 22  √  null Time when the patient was transferred out of the unit.
los float8 17,17  √  null Length of stay in the unit in minutes.

Table contained 261,897 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc transfers_rowid_pk
subject_id Performance Asc transfers_idx01
icustay_id Performance Asc transfers_idx02
hadm_id Performance Asc transfers_idx03

Close relationships  within of separation: