Only one set of cross multi references allowed between two collections?

Ask the community
, ,
1

My problem is I have a members table and a posts table. Members can do different things on posts, like liking, donating, etc. Ideally, I would like to have more than two fields of multireferences to members table, one for liking and one for disliking and etc. But The When I am generating the multi references fields in the posts table, only one field named proposals created in members collection and cross referencing to all three original fields in posts table.

Ended up, if I am inserting one member._id into one reference field in posts table, all three fields in the posts table got the insert.

I really like this multicrossing a lot, is there any way to solve this?

2

Turned out, a different database design can solve the problem. Just make one collection to have multiple collections with singled reference, and then each individual reference collection have multi cross references with the original targeted collection.