| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| row_id |
int4 |
10 |
|
|
|
|
|
| subject_id |
int4 |
10 |
|
|
|
|
| patients.subject_id
|
procedureevents_mv_fk_subject_id R |
|
| hadm_id |
int4 |
10 |
|
|
|
|
| admissions.hadm_id
|
procedureevents_mv_fk_hadm_id R |
|
| icustay_id |
int4 |
10 |
√ |
|
null |
|
| icustays.icustay_id
|
procedureevents_mv_fk_icustay_id R |
|
| starttime |
timestamp |
22 |
√ |
|
null |
|
|
| endtime |
timestamp |
22 |
√ |
|
null |
|
|
| itemid |
int4 |
10 |
√ |
|
null |
|
| d_items.itemid
|
procedureevents_mv_fk_itemid R |
|
| value |
float8 |
17,17 |
√ |
|
null |
|
|
| valueuom |
varchar |
30 |
√ |
|
null |
|
|
| location |
varchar |
30 |
√ |
|
null |
|
|
| locationcategory |
varchar |
30 |
√ |
|
null |
|
|
| storetime |
timestamp |
22 |
√ |
|
null |
|
|
| cgid |
int4 |
10 |
√ |
|
null |
|
|
| orderid |
int4 |
10 |
√ |
|
null |
|
|
| linkorderid |
int4 |
10 |
√ |
|
null |
|
|
| ordercategoryname |
varchar |
100 |
√ |
|
null |
|
|
| secondaryordercategoryname |
varchar |
100 |
√ |
|
null |
|
|
| ordercategorydescription |
varchar |
50 |
√ |
|
null |
|
|
| isopenbag |
int2 |
5 |
√ |
|
null |
|
|
| continueinnextdept |
int2 |
5 |
√ |
|
null |
|
|
| cancelreason |
int2 |
5 |
√ |
|
null |
|
|
| statusdescription |
varchar |
30 |
√ |
|
null |
|
|
| comments_editedby |
varchar |
30 |
√ |
|
null |
|
|
| comments_canceledby |
varchar |
30 |
√ |
|
null |
|
|
| comments_date |
timestamp |
22 |
√ |
|
null |
|
|
Table contained 258,066 rows at Thu Oct 12 12:29 EDT 2017
|
