Add sharding key for agent_activity_events
Proposal
This table is missing a sharding key.
The automated sharding key process skipped this table because it already has a project_id
column. We originally added this column to provide project details in an agent's activity feed, however we never got around to doing this so the column is unused.
We can either:
- Repurpose this column to be used as the sharding key, and add another column if/when we want to add to the activity feed.
- Add a new column for the sharding key, and keep this one for the activity feed.
Edited by Tiger Watson