sp_maladaptive_behavior_intensity_assignments


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_intensity_assignments_ibfk_1 C
intensity_key_id VARCHAR 36 null
catalog_intensity_keys.id sp_maladaptive_behavior_intensity_assignments_ibfk_2 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
definition TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_intensity_assignments_behavior Performance Asc sp_maladaptive_behavior_id
idx_intensity_assignments_key Performance Asc intensity_key_id
uk_intensity_assignment Must be unique Asc/Asc sp_maladaptive_behavior_id + intensity_key_id

Relationships

Close relationships within degrees of separation