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

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