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
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
procedures_icd.icd9_code procedures_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 3,898 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc d_icd_proc_rowid_pk
icd9_code Must be unique Asc d_icd_proc_code_unique
icd9_code Performance Asc d_icd_proc_idx01
long_title Performance Asc d_icd_proc_idx02

Close relationships  within of separation: