cpt_codes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
credential_cpt_codes.cpt_code_id credential_cpt_codes_ibfk_2 C
encounter_cpt_codes.cpt_code_id fk_encounter_cpt_codes_cpt R
encounter_rules.cpt_code_id fk_encounter_rules_cpt C
encounter_type_cpts.cpt_code_id fk_encounter_type_cpts_cpt C
payer_contracted_rates.billing_code_id fk_payer_contracted_rates_cpt_code R
user_rates.cpt_code_id user_rates_ibfk_3 C
category VARCHAR 50 √ null
code VARCHAR 10 null
description TEXT 65535 null
is_active BIT 1 √ 1
location_business_line_id VARCHAR 36 √ null
location_business_lines.id fk_cpt_codes_location_business_line R
notes TEXT 65535 √ null
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 CURRENT_TIMESTAMP
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null
unit_duration_minutes INT 10 √ 15

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_cpt_active Performance Asc is_active
idx_cpt_category Performance Asc category
idx_cpt_code Performance Asc code
idx_cpt_codes_location_business_line Performance Asc location_business_line_id

Relationships

Close relationships within degrees of separation