If you go single table you can use filtered indexes if your database supports it to speed up queries instead of having to do a row by row search with a where cl

If you go single table you can use filtered indexes if your database supports it to speed up queries instead of having to do a row by row search with a where clause. Personally this seems like a job for DynamoDB but that’s a whole beast unto itself. You must know the queries you will do to the database before hand as that guides how you craft it. There’s an amazing talk at reinvent that is given almost every year on creating a DynamoDB schema (https://m.youtube.com/watch?v=HaEPXoXVf2k https://m.youtube.com/watch?v=HaEPXoXVf2k) I would normalize as the theory says and then denormalize as performance requires it.