I'm in the process of developping a small project for school, and I'm unsure on a design choice.
Here is what I am trying to achieve :
I have a table of users, who are allowed to subscribe/unsubscribe from different magazines stored in a second table.
My question is fairly easy. Does that justify the use of a junction table? I was initially thinking about just including the IDs of subscribers directly in the magazine table with an additional column. It felt sloppy.
On the other hand, if I use a junction table, one way or the other I will still end up storing multiple IDs (users or magazines) into a single column, so it feels like a junction table serves no purpose.