| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| admissiondrugid |
int4 |
10 |
|
|
|
|
|
| patientunitstayid |
int4 |
10 |
|
|
|
|
| patient.patientunitstayid
|
admissiondrug_fk_ptunit_id R |
|
| drugoffset |
int4 |
10 |
|
|
|
|
|
| drugenteredoffset |
int4 |
10 |
|
|
|
|
|
| drugnotetype |
varchar |
255 |
√ |
|
null |
|
|
| specialtytype |
varchar |
255 |
√ |
|
null |
|
|
| usertype |
varchar |
255 |
|
|
|
|
|
| rxincluded |
varchar |
5 |
√ |
|
null |
|
|
| writtenineicu |
varchar |
5 |
√ |
|
null |
|
|
| drugname |
varchar |
255 |
|
|
|
|
|
| drugdosage |
numeric |
11,4 |
√ |
|
null |
|
|
| drugunit |
varchar |
1000 |
√ |
|
null |
|
|
| drugadmitfrequency |
varchar |
1000 |
|
|
|
|
|
| drughiclseqno |
int4 |
10 |
√ |
|
null |
|
|
Table contained 874,920 rows at Thu Aug 08 18:15 EDT 2019
|