sp_maladaptive_behavior_function_interventions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
sp_maladaptive_behavior_id VARCHAR 36 null
service_plan_maladaptive_behaviors.id sp_maladaptive_behavior_function_interventions_ibfk_1 C
hypothesized_function_id VARCHAR 36 null
hypothesized_functions.id sp_maladaptive_behavior_function_interventions_ibfk_2 R
intervention_type enum('ANTECEDENT', 'CONSEQUENCE') 11 null
antecedent_intervention_id VARCHAR 36 √ null
antecedent_interventions.id sp_maladaptive_behavior_function_interventions_ibfk_3 R
consequence_intervention_id VARCHAR 36 √ null
consequence_interventions.id sp_maladaptive_behavior_function_interventions_ibfk_4 R
is_active BIT 1 1
created_at DATETIME 19 √ CURRENT_TIMESTAMP
updated_at DATETIME 19 √ CURRENT_TIMESTAMP
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
antecedent_intervention_id Performance Asc antecedent_intervention_id
consequence_intervention_id Performance Asc consequence_intervention_id
idx_function_interventions_behavior Performance Asc sp_maladaptive_behavior_id
idx_function_interventions_function Performance Asc hypothesized_function_id

Relationships

Close relationships within degrees of separation