Change Log: 2026-06-03

Data Dictionary Changelog

Date Range: 2026-01-16 → 2026-06-03

Modified Tables

events_formsubmission

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

rules_action

• Column data: Comment changed from (none) to 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.

rules_actiontype

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

rules_condition

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

rules_rule

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

rules_savedsearch

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

rules_triggertype

• Column name: Nullable changed from NO to YES

tasks_task

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

temperature_profiles_temperatureconditionfollowups

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

temperature_profiles_temperatureconditionfollowups_translation

• Description changed from Table that lists temperature conditions follow ups translation. to Error: Table details missing in mongo_table_details/mongo_column_details.
• Column id removed
• Column language_code removed
• Column master_id removed
• Column title removed

users_company

• Column tenant_id added

users_usernotificationsettingdeliverytype

• Column name: Nullable changed from NO to YES