Docs: Update schema for resource_state_events

This MR updates the database documentation for db/docs/resource_state_events.yml.

The schema was updated in the source file, and this MR reflects that change.

Assignee: @donaldcook, as the DRI for the team_planning feature category, please help ensure a developer from your team reviews this change.