Data Dictionary Changelog

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

Added Info:

| form_submission_id | char(24) | NO | FOREIGN KEY, PRIMARY KEY | forms_submission(id) | This is the Object id of the submission |
| data | longtext | NO | | | 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. |
| name | varchar(50) | NO | | | |
| order | smallint unsigned | YES | | | Should only been NULL when updating for a rule. |
| data | longtext | NO | | | JSON representation of the data in this table. That is ONLY the columns in this table. This is for quick retrieving of the information. |
| rule_id | int unsigned | NO | FOREIGN KEY, UNIQUE | rules_rule(id) | This is denormalized, but will allow quicker way to get what rules use what saved searches. |
| name | varchar(50) | YES | UNIQUE | | |
| created_event_id | int unsigned | YES | FOREIGN KEY | events_event(id) | The event that created this task, if any |
| created_rule_id | int unsigned | YES | FOREIGN KEY | rules_rule(id) | The rule that created this task, if any |
| fulfill_submission_id | varchar(24) | YES | FOREIGN KEY | forms_submission(id) | |
| source_submission_id | varchar(24) | YES | FOREIGN KEY | forms_submission(id) | |
| name | varchar(50) | YES | UNIQUE | | |

Removed Info:

| form_submission_id | char(24) | NO | FOREIGN KEY, PRIMARY KEY | forms_submission(id) | |
| data | longtext | NO | | | |
| name | varchar(50) | NO | UNIQUE | | |
| order | smallint unsigned | YES | | | |
| data | longtext | NO | | | |
| rule_id | int unsigned | NO | FOREIGN KEY, UNIQUE | rules_rule(id) | |
| name | varchar(50) | NO | UNIQUE | | |
| created_event_id | int unsigned | YES | FOREIGN KEY | events_event(id) | |
| created_rule_id | int unsigned | YES | FOREIGN KEY | rules_rule(id) | |
| fulfill_submission_id | char(24) | YES | FOREIGN KEY | forms_submission(id) | |
| source_submission_id | char(24) | YES | FOREIGN KEY | forms_submission(id) | |
| name | varchar(50) | NO | UNIQUE | | |