course.search_vector: entity column name doesn't match migration or app SQL

[RUKAYAT-CODER]

Three places disagree on the full-text search column on course:

• Migration 1783000000003-add-course-full-text-search.ts creates search_vector (snake_case)
• Entity Course.searchVector declares the column as searchVector (camelCase, no explicit name) with generatedType: 'STORED'
• App raw SQL (src/search/search.service.ts) queries course.search_vector (snake_case)

The entity column maps to a DB column named searchVector, which does not exist — the entity can never read the generated column, and the schema drift check wants to drop search_vector and create searchVector.

Fix: declare the entity column with name: 'search_vector' (keeping the property name searchVector), and align the asExpression with the migration's expression. This also removes a chunk of the known drift snapshot in #1194.

[sublime247]

I would love tp resolve this issue

[Cedarich]

Hello maintainer can i take up this task

[grantfox-oss]

🦊 GrantFox — @Cedarich has been assigned to this issue as part of the Third Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #1197)
2. Your PR will be reviewed by the rinafcode maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Third Campaign campaign!

@Cedarich's PR #1355 was approved and merged by @RUKAYAT-CODER.

🏆 @Cedarich: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (877 total points). Track your full progress on GrantFox.

👏 Great work, @Cedarich! Keep contributing to rinafcode.