Per project rule 01-migration-first.md, FK columns must follow
{singular_table}_id convention. Updates migration, models,
services, and all Livewire queries/views that reference this column.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>