Certificate Repository
Component Detail
Data Layer
medium complexity
backend
0
Dependencies
0
Dependents
4
Entities
0
Integrations
Description
Data access layer for certificate and certification renewal records in the Supabase database. Provides type-safe CRUD operations with Supabase RLS integration ensuring coordinators and admins can write while peer mentors have read-only access to their own records.
certificate-repository
Responsibilities
- Provide CRUD operations for certifications and certification_renewals tables
- Apply Supabase RLS policies for role-based data access
- Query certificates by user, status, and expiry window
- Persist physical card issuance flag updates
Interfaces
findByUserId(userId)
findById(certificateId)
findExpiring(withinDays)
findExpired()
create(certificateData)
update(certificateId, data)
delete(certificateId)
createRenewal(renewalData)
findRenewalsByCertificate(certificateId)
updatePhysicalCardStatus(certificateId, issued)
Related Data Entities (4)
Data entities managed by this component