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

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
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
Foreign key. Identifies the patient.
hadm_id int4 10
callout
chartevents
cptevents
datetimeevents
diagnoses_icd
drgcodes
icustays
inputevents_cv
inputevents_mv
labevents
microbiologyevents
noteevents
outputevents
prescriptions
procedureevents_mv
procedures_icd
services
transfers
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

Indexes:
Column(s) Type Sort
row_id Primary key Asc
hadm_id Must be unique Asc
subject_id Performance Asc
hadm_id Performance Asc

Close relationships  within of separation: