Change Log: 2026-09-08

Data Dictionary Changelog

Date Range: 2026-08-27 → 2026-09-08

Modified Tables

events_formsubmission

• Column form_submission_id: Comment changed from This is the Object id of the submission to (none)

rules_action

• Column data: Comment changed from JSON representation of the data for this action. This is for quick retrieving of the information. The information here can or cannot be represented in additional tables, ie. events_action_notify_user. to (none)

rules_actiontype

• Column name: Constraint changed from (none) to UNIQUE

rules_condition

• Column order: Comment changed from Should only been NULL when updating for a rule. to (none)

rules_rule

• Column data: Comment changed from JSON representation of the data in this table. That is ONLY the columns in this table. This is for quick retrieving of the information. to (none)

rules_savedsearch

• Column rule_id: Comment changed from This is denormalized, but will allow quicker way to get what rules use what saved searches. to (none)

rules_triggertype

• Column name: Nullable changed from YES to NO

tasks_task

• Column created_event_id: Comment changed from The event that created this task, if any to (none)
• Column created_rule_id: Comment changed from The rule that created this task, if any to (none)
• Column fulfill_submission_id: Type changed from varchar(24) to char(24)
• Column source_submission_id: Type changed from varchar(24) to char(24)

temperature_profiles_temperatureconditionfollowups

• Description changed from Error: Table details missing in mongo_table_details/mongo_column_details. to Table that lists temperature conditions follow up actions.
• Column date_created added
• Column date_modified added
• Column id added
• Column is_required added
• Column temperature_condition_id added

temperature_profiles_temperatureconditionfollowups_translation

• Description changed from Error: Table details missing in mongo_table_details/mongo_column_details. to (none)
• Column id added
• Column language_code added
• Column master_id added
• Column title added

users_usernotificationsettingdeliverytype

• Column name: Nullable changed from YES to NO