An additional consideration around the DB table: right now we're creating multiple table entries per row in the spreadsheet when the entry applies to multiple projects.
The current solution requires deduping to render a reasonable stream of updates. Currently this takes place on the frontend, which breaks the expectation of consistent page counts when viewing paginated data.
In the long term, a join table seems like the natural solution for this.
If that's a heavy lift at this point (is it?), could we at least map these rows to single table entries with a list of project_ids?
Work-in-progress schema here
An additional consideration around the DB table: right now we're creating multiple table entries per row in the spreadsheet when the entry applies to multiple projects.
project_ids?