Implement PostgreSQL Full-Text Search

Implement full-text search for {{ENTITY}}:

Search requirements:
- Search across: {{FIELDS}}
- Support: exact match, fuzzy match, prefix search
- Ranking by relevance
- Result highlighting
- Autocomplete suggestions
- Search history (optional)

PostgreSQL implementation:
1. Create tsvector column for searchable text
2. Add GIN index for fast lookups
3. Use ts_rank for relevance scoring
4. Implement ts_headline for highlighting
5. Create trigram index for fuzzy matching
6. Add search suggestion endpoint

Provide:
- Database migration for search columns
- GIN index creation
- Search query builder
- API endpoint for search
- Autocomplete endpoint
- Frontend search component
- Search analytics tracking