maladaptive_behaviors


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
service_plan_maladaptive_behaviors.maladaptive_behavior_id fk_sp_maladaptive_behaviors_behavior R
name VARCHAR 255 null
shedlock.name Implied Constraint R
description TEXT 65535 √ null
location_business_line_id VARCHAR 36 √ null
location_business_lines.id maladaptive_behaviors_ibfk_1 C
catalog_maladaptive_behavior_id VARCHAR 36 √ null
catalog_maladaptive_behaviors.id maladaptive_behaviors_ibfk_2 N
start_date DATE 10 √ null
end_date DATE 10 √ null
display_order INT 10 0
is_active BIT 1 1
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_maladaptive_behaviors_catalog_id Performance Asc catalog_maladaptive_behavior_id
idx_maladaptive_behaviors_is_active Performance Asc is_active
idx_maladaptive_behaviors_location_bl Performance Asc location_business_line_id
idx_maladaptive_behaviors_name Performance Asc name

Relationships

Close relationships within degrees of separation