Docs: Update schema for content_blocked_states

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

The schema decision was updated, and this MR reflects that change.

Assignee: @andrevr, as the EM for the source_code_management feature category, please help ensure a developer from your team reviews this change.