Table mimic.mimiciii.admissions
Hospital admissions associated with an ICU stay.

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 admissions_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10
callout.hadm_id callout_fk_hadm_id R
chartevents.hadm_id chartevents_fk_hadm_id R
cptevents.hadm_id cptevents_fk_hadm_id R
datetimeevents.hadm_id datetimeevents_fk_hadm_id R
diagnoses_icd.hadm_id diagnoses_icd_fk_hadm_id R
drgcodes.hadm_id drgcodes_fk_hadm_id R
icustays.hadm_id icustays_fk_hadm_id R
inputevents_cv.hadm_id inputevents_cv_fk_hadm_id R
inputevents_mv.hadm_id inputevents_mv_fk_hadm_id R
labevents.hadm_id labevents_fk_hadm_id R
microbiologyevents.hadm_id microbiologyevents_fk_hadm_id R
noteevents.hadm_id noteevents_fk_hadm_id R
outputevents.hadm_id outputevents_fk_hadm_id R
prescriptions.hadm_id prescriptions_fk_hadm_id R
procedureevents_mv.hadm_id procedureevents_mv_fk_hadm_id R
procedures_icd.hadm_id procedures_icd_fk_hadm_id R
services.hadm_id services_fk_hadm_id R
transfers.hadm_id transfers_fk_hadm_id R
Primary key. Identifies the hospital stay.
admittime timestamp 22 Time of admission to the hospital.
dischtime timestamp 22 Time of discharge from the hospital.
deathtime timestamp 22  √  null Time of death.
admission_type varchar 50 Type of admission, for example emergency or elective.
admission_location varchar 50 Admission location.
discharge_location varchar 50 Discharge location
insurance varchar 255 Insurance type.
language varchar 10  √  null Language.
religion varchar 50  √  null Religon.
marital_status varchar 50  √  null Marital status.
ethnicity varchar 200 Ethnicity.
edregtime timestamp 22  √  null
edouttime timestamp 22  √  null
diagnosis varchar 255  √  null Diagnosis.
hospital_expire_flag int2 5  √  null
has_chartevents_data int2 5 Hospital admission has at least one observation in the CHARTEVENTS table.

Table contained 58,976 rows at Thu Oct 12 12:29 EDT 2017

Column(s) Type Sort Constraint Name
row_id Primary key Asc adm_rowid_pk
hadm_id Must be unique Asc adm_hadm_unique
subject_id Performance Asc admissions_idx01
hadm_id Performance Asc admissions_idx02

Close relationships  within of separation: