---
updatedAt: 2026-09-18T18:37:37.000Z
agentTools:
  projectIndex: https://developer.ops-execution.crunchtime.com/llms.txt
---

# 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`