Feature 5: Vendor Reputation System with Reviews & Verification

[saidai-bhuvanesh]

Description

This issue aims to build a community-driven trust marketplace by implementing a Vendor Reputation System with reviews and rating verification.

We will add a rating and review system where verified customers can rate vendors (1 to 5 stars) and write textual reviews. A Supabase table public.vendor_reviews will be created, and triggers will automatically update a vendor's overall trust_score and avg_freshness_score based on both their reviews and scans. A glowing "Trusted Vendor" badge will be displayed on the map and leaderboard for vendors with high reputation scores. We will also include basic fake review detection to maintain system integrity.

Technical Implementation Details

1. Database Schema: Add public.vendor_reviews and trigger functions in database migrations.
2. Review API: Build backend routes under backend/vendors.py to manage adding/listing reviews.
3. Badges & Visuals: Compute and render the "Trusted Vendor" badge on map popups and leaderboards.
4. Reviews Section: Construct a custom reviews and rating submit card within the vendor detail drawer on the map.