In my app, I have a 1-Many relationship between posts and comments. I have a Posts collection and a Comments collection. In the Comments collection, I reference the postId.
Now, my goal is to allow file uploads on both posts and comments. I plan to have a new Uploads collection. What’s the best way to model this?
Initially, I was thinking of having a contentId field on an Upload document that would store either the post._id or the comment._id as a reference. This seemed like it would work well but then I thought there might be a small chance those ids are the same since, from what I understand, collection ids aren’t necessarily unique across collections.
As an alternative, I was thinking the Posts and Comments collections could have an uploads field that will contain an array of uploadIds. I think this works, but I’m wondering if there’s a better way.
Appreciate any insight you might have.