Activity Feed Database Index
Component Detail
Infrastructure
low complexity
backend
0
Dependencies
0
Dependents
0
Entities
0
Integrations
Description
Database migration that defines the PostgreSQL indexes required for performant cursor-based pagination and filter queries on the activity feed. Ensures that ordering by `created_at` combined with organization/local-association scoping does not result in full table scans as the activities table grows.
activity-feed-index
Responsibilities
- Define composite index on (organization_id, created_at DESC) for feed ordering
- Define index on (local_association_id, created_at DESC) for coordinator-scoped queries
- Define index on (status) for status filter performance
- Provide migration script for deployment
Interfaces
up(): Migration
down(): Migration