Table mimic.mimiciii.d_cpt
High-level dictionary of the Current Procedural Terminology.

 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.
category int2 5 Code category.
sectionrange varchar 100 Range of codes within the high-level section.
sectionheader varchar 50 Section header.
subsectionrange varchar 100 Range of codes within the subsection.
subsectionheader varchar 255 Subsection header.
codesuffix varchar 5  √  null Text element of the Current Procedural Terminology, if any.
mincodeinsubsection int4 10 Minimum code within the subsection.
maxcodeinsubsection int4 10 Maximum code within the subsection.

Table contained 134 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc dcpt_rowid_pk
subsectionrange Must be unique Asc dcpt_ssrange_unique