RFR--Announcements

we should index `team_id` - generally as a matter of practice, it's best to index foreign keys for quick reads.