Table eicu.eicu_crd.apachepatientresult 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
apachepatientresultsid int4 10
patientunitstayid int4 10
patient.patientunitstayid apachepatientresult_fk_ptunit_id R
physicianspeciality varchar 50  √  null
physicianinterventioncategory varchar 50  √  null
acutephysiologyscore int4 10  √  null
apachescore int4 10  √  null
apacheversion varchar 5
predictedicumortality varchar 50  √  null
actualicumortality varchar 50  √  null
predictediculos float8 17,17  √  null
actualiculos float8 17,17  √  null
predictedhospitalmortality varchar 50  √  null
actualhospitalmortality varchar 50  √  null
predictedhospitallos float8 17,17  √  null
actualhospitallos float8 17,17  √  null
preopmi int4 10  √  null
preopcardiaccath int4 10  √  null
ptcawithin24h int4 10  √  null
unabridgedunitlos float8 17,17  √  null
unabridgedhosplos float8 17,17  √  null
actualventdays float8 17,17  √  null
predventdays float8 17,17  √  null
unabridgedactualventdays float8 17,17  √  null

Table contained 297,064 rows at Thu Aug 08 18:15 EDT 2019


Close relationships  within of separation: