| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| allergyid |
int4 |
10 |
|
|
|
|
|
| patientunitstayid |
int4 |
10 |
|
|
|
|
| patient.patientunitstayid
|
allergy_fk_ptunit_id R |
|
| allergyoffset |
int4 |
10 |
|
|
|
|
|
| allergyenteredoffset |
int4 |
10 |
|
|
|
|
|
| allergynotetype |
varchar |
255 |
√ |
|
null |
|
|
| specialtytype |
varchar |
255 |
√ |
|
null |
|
|
| usertype |
varchar |
255 |
|
|
|
|
|
| rxincluded |
varchar |
5 |
√ |
|
null |
|
|
| writtenineicu |
varchar |
5 |
√ |
|
null |
|
|
| drugname |
varchar |
255 |
|
|
|
|
|
| allergytype |
varchar |
255 |
√ |
|
null |
|
|
| allergyname |
varchar |
255 |
√ |
|
null |
|
|
| drughiclseqno |
int4 |
10 |
√ |
|
null |
|
|
Table contained 251,949 rows at Thu Aug 08 18:15 EDT 2019
|
