Table mimic.mimiciii.d_icd_diagnoses
Dictionary of the International Classification of Diseases, 9th Revision (Diagnoses).

 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
row_id int4 10 Unique row identifier.
icd9_code varchar 10
diagnoses_icd.icd9_code diagnoses_icd_fk_icd9 R
ICD9 code - note that this is a fixed length character field, as whitespaces are important in uniquely identifying ICD-9 codes.
short_title varchar 50 Short title associated with the code.
long_title varchar 255 Long title associated with the code.

Table contained 14,710 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc d_icd_diag_rowid_pk
icd9_code Must be unique Asc d_icd_diag_code_unique
icd9_code Performance Asc d_icd_diag_idx01
long_title Performance Asc d_icd_diag_idx02

Close relationships  within of separation: