hypothesized_functions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
service_plan_maladaptive_behavior_functions.hypothesized_function_id fk_sp_mb_functions_function R
sp_maladaptive_behavior_function_assignments.hypothesized_function_id sp_maladaptive_behavior_function_assignments_ibfk_2 R
sp_maladaptive_behavior_function_interventions.hypothesized_function_id sp_maladaptive_behavior_function_interventions_ibfk_2 R
name VARCHAR 255 null
shedlock.name Implied Constraint R
location_business_line_id VARCHAR 36 √ null
description TEXT 65535 √ null
category VARCHAR 100 √ null
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_hyp_func_active Performance Asc is_active
idx_hyp_func_category Performance Asc category
idx_hyp_func_location Performance Asc location_business_line_id
unique_name_location Must be unique Asc/Asc name + location_business_line_id

Relationships

Close relationships within degrees of separation