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
|