Table postgres.mimic.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 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 0 rows at dim. sept. 10 22:12 CEST 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