service_plan_maladaptive_behaviors


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
service_plan_maladaptive_behavior_functions.service_plan_maladaptive_behavior_id fk_sp_mb_functions_behavior C
sp_maladaptive_behavior_barriers.service_plan_maladaptive_behavior_id fk_sp_mb_barriers_behavior C
sp_maladaptive_behavior_function_assignments.sp_maladaptive_behavior_id sp_maladaptive_behavior_function_assignments_ibfk_1 C
sp_maladaptive_behavior_function_interventions.sp_maladaptive_behavior_id sp_maladaptive_behavior_function_interventions_ibfk_1 C
sp_maladaptive_behavior_intensity_assignments.sp_maladaptive_behavior_id sp_maladaptive_behavior_intensity_assignments_ibfk_1 C
sp_maladaptive_behavior_objectives.sp_maladaptive_behavior_id sp_maladaptive_behavior_objectives_ibfk_1 C
sp_maladaptive_behavior_protocol_modifications.sp_maladaptive_behavior_id sp_maladaptive_behavior_protocol_modifications_ibfk_1 C
sp_maladaptive_behavior_topographies.sp_maladaptive_behavior_id sp_maladaptive_behavior_topographies_ibfk_1 C
location_business_line_id VARCHAR 36 null
location_business_lines.id fk_sp_maladaptive_behaviors_location R
service_plan_id VARCHAR 36 null
service_plans.id fk_sp_maladaptive_behaviors_plan C
maladaptive_behavior_id VARCHAR 36 null
maladaptive_behaviors.id fk_sp_maladaptive_behaviors_behavior R
name VARCHAR 255 null
shedlock.name Implied Constraint R
topography TEXT 65535 √ null
barrier TEXT 65535 √ null
start_date DATE 10 null
end_date DATE 10 √ null
status enum('ONGOING', 'RESOLVED', 'ON_HOLD', 'MASTERED', 'DEPRECATED', 'DISCONTINUED', 'PENDING', 'IN_OBSERVATION') 14 ONGOING
previous_behavior_id VARCHAR 36 √ null

Navigation-only link to the behavior this one superseded due to a measurement-type change. Never read by ServicePlanItemLineageService or trend aggregation - see source_item_id for that.
intensity_key_id VARCHAR 36 √ null
catalog_intensity_keys.id fk_sp_maladaptive_behaviors_intensity R
measure_id VARCHAR 36 √ null
is_active BIT 1 1
is_data_collection_enabled BIT 1 1
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null
behavior_goal_id VARCHAR 36 √ null
behavior_goals.id fk_sp_maladaptive_behaviors_goal R
source_item_id VARCHAR 36 √ null

Self-FK - the item this was carried forward from on clone (issue #196, Phase 6)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_sp_maladaptive_behaviors_behavior Performance Asc maladaptive_behavior_id
fk_sp_maladaptive_behaviors_intensity Performance Asc intensity_key_id
idx_sp_maladaptive_behaviors_goal Performance Asc behavior_goal_id
idx_sp_maladaptive_behaviors_location_active Performance Asc/Asc location_business_line_id + is_active
idx_sp_maladaptive_behaviors_plan Performance Asc service_plan_id
idx_sp_maladaptive_behaviors_status Performance Asc status
idx_sp_maladaptive_source_item Performance Asc source_item_id

Relationships

Close relationships within degrees of separation