Task Assignment Repository

Data access layer for all assignment-related entities: assignments, dispatches, and read receipts. Provides CRUD operations and query methods for coordinator status overviews and reminder scheduling, backed by Supabase with row-level security policies ensuring only authorized users access sensitive records.

Feature: Encrypted Task Assignment to Peer Mentors

task-assignment-repository

• Create and persist new assignment records with encrypted payload
• Query assignments by coordinator, status, and date range
• Record dispatch events and associate with assignment
• Record and retrieve read receipt events
• Enforce row-level security via Supabase policies