Change Log: 2026-09-30

Data Dictionary Changelog

Date Range: 2026-09-30 → 2026-09-30

Added Tables

• sensors_sensorswaphistorylog

Removed Tables

• sensors_sensorswaphistory

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)

users_usernotificationsettingdeliverytype

• Column name: Nullable changed from YES to NO