| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| 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
|
