Tables
Relationships
Constraints
Anomalies
Columns
Donate to SchemaSpy
Table
eicu
.
eicu_crd
.
diagnosis
Generated by
SchemaSpy
Related columns
Constraints
Comments
Legend
Legend:
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
diagnosisid
int4
10
patientunitstayid
int4
10
patient
.patientunitstayid
diagnosis_fk_ptunit_id
R
activeupondischarge
varchar
64
√
null
diagnosisoffset
int4
10
diagnosisstring
varchar
200
icd9code
varchar
100
√
null
diagnosispriority
varchar
10
Table contained 2,710,672 rows at Thu Aug 08 18:15 EDT 2019
Close relationships
within
one
two degrees
of separation
: