Table eicu.eicu_crd.medication Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
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


Close relationships  within of separation: