Activity Approval Repository
Component Detail
Data Layer
medium complexity
backend
0
Dependencies
3
Dependents
3
Entities
0
Integrations
Description
Data access layer for reading and writing activity approval state and associated audit records. Manages the approval status enum field on the activities table and provides cursor-based pagination queries optimized for large coordinator activity datasets.
activity-approval-repository
Responsibilities
- Read activities with approval status filtering and cursor-based pagination
- Update activity approval_status enum (pending, approved, flagged, rejected)
- Write and retrieve audit_log entries for approval actions
- Query activities within coordinator organizational scope
Interfaces
findActivitiesPaginated(filters, cursor, limit)
findActivityById(activityId)
updateApprovalStatus(activityId, status, actorId)
insertAuditLogEntry(entry)
findAuditLogsByActivity(activityId)
findActivitiesInScope(coordinatorId, filters)
Relationships
Dependents (3)
Components that depend on this component
Related Data Entities (3)
Data entities managed by this component