Table eicu.eicu_crd.admissiondrug 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
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


Close relationships  within of separation: