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

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
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
procedures_icd
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 3,898 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort
row_id Primary key Asc
icd9_code Must be unique Asc
icd9_code Performance Asc
long_title Performance Asc

Close relationships  within of separation: