| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| medicationid |
int4 |
10 |
|
|
|
|
|
| patientunitstayid |
int4 |
10 |
|
|
|
|
| patient.patientunitstayid
|
medication_fk_ptunit_id R |
|
| drugorderoffset |
int4 |
10 |
|
|
|
|
|
| drugstartoffset |
int4 |
10 |
|
|
|
|
|
| drugivadmixture |
varchar |
6 |
|
|
|
|
|
| drugordercancelled |
varchar |
6 |
|
|
|
|
|
| drugname |
varchar |
220 |
√ |
|
null |
|
|
| drughiclseqno |
int4 |
10 |
√ |
|
null |
|
|
| dosage |
varchar |
60 |
√ |
|
null |
|
|
| routeadmin |
varchar |
120 |
√ |
|
null |
|
|
| frequency |
varchar |
255 |
√ |
|
null |
|
|
| loadingdose |
varchar |
120 |
|
|
|
|
|
| prn |
varchar |
6 |
|
|
|
|
|
| drugstopoffset |
int4 |
10 |
|
|
|
|
|
| gtc |
int4 |
10 |
|
|
|
|
|
Table contained 7,301,853 rows at Thu Aug 08 18:15 EDT 2019
|