Table eicu.eicu_crd.patient 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
patientunitstayid int4 10
admissiondrug.patientunitstayid admissiondrug_fk_ptunit_id R
admissiondx.patientunitstayid admissiondx_fk_ptunit_id R
allergy.patientunitstayid allergy_fk_ptunit_id R
apacheapsvar.patientunitstayid apacheapsvar_fk_ptunit_id R
apachepatientresult.patientunitstayid apachepatientresult_fk_ptunit_id R
apachepredvar.patientunitstayid apachepredvar_fk_ptunit_id R
careplancareprovider.patientunitstayid careplancareprovider_fk_ptunit_id R
careplaneol.patientunitstayid careplaneol_fk_ptunit_id R
careplangeneral.patientunitstayid careplangeneral_fk_ptunit_id R
careplangoal.patientunitstayid careplangoal_fk_ptunit_id R
careplaninfectiousdisease.patientunitstayid careplaninfectiousdisease_fk_ptunit_id R
customlab.patientunitstayid customlab_fk_ptunit_id R
diagnosis.patientunitstayid diagnosis_fk_ptunit_id R
infusiondrug.patientunitstayid infusiondrug_fk_ptunit_id R
intakeoutput.patientunitstayid intakeoutput_fk_ptunit_id R
lab.patientunitstayid lab_fk_ptunit_id R
medication.patientunitstayid medication_fk_ptunit_id R
microlab.patientunitstayid microlab_fk_ptunit_id R
note.patientunitstayid note_fk_ptunit_id R
nurseassessment.patientunitstayid nurseassessment_fk_ptunit_id R
nursecare.patientunitstayid nursecare_fk_ptunit_id R
nursecharting.patientunitstayid nursecharting_fk_ptunit_id R
pasthistory.patientunitstayid pasthistory_fk_ptunit_id R
physicalexam.patientunitstayid physicalexam_fk_ptunit_id R
respiratorycare.patientunitstayid respiratorycare_fk_ptunit_id R
respiratorycharting.patientunitstayid respiratorycharting_fk_ptunit_id R
treatment.patientunitstayid treatment_fk_ptunit_id R
vitalaperiodic.patientunitstayid vitalaperiodic_fk_ptunit_id R
vitalperiodic.patientunitstayid vitalperiodic_fk_ptunit_id R
patienthealthsystemstayid int4 10  √  null
gender varchar 25  √  null
age varchar 10  √  null
ethnicity varchar 50  √  null
hospitalid int4 10  √  null
wardid int4 10  √  null
apacheadmissiondx varchar 1000  √  null
admissionheight numeric 10,2  √  null
hospitaladmittime24 varchar 8  √  null
hospitaladmitoffset int4 10  √  null
hospitaladmitsource varchar 30  √  null
hospitaldischargeyear int2 5  √  null
hospitaldischargetime24 varchar 8  √  null
hospitaldischargeoffset int4 10  √  null
hospitaldischargelocation varchar 100  √  null
hospitaldischargestatus varchar 10  √  null
unittype varchar 50  √  null
unitadmittime24 varchar 8  √  null
unitadmitsource varchar 100  √  null
unitvisitnumber int4 10  √  null
unitstaytype varchar 15  √  null
admissionweight numeric 10,2  √  null
dischargeweight numeric 10,2  √  null
unitdischargetime24 varchar 8  √  null
unitdischargeoffset int4 10  √  null
unitdischargelocation varchar 100  √  null
unitdischargestatus varchar 10  √  null
uniquepid varchar 10  √  null

Table contained 200,859 rows at Thu Aug 08 18:15 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
patientunitstayid Primary key Asc patient_pk_ptunit_id

Close relationships: