Change Log: 2026-09-08

Data Dictionary Changelog

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

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)

users_usernotificationsettingdeliverytype

• Column name: Nullable changed from NO to YES