jeudi 29 juin 2017

Many to many relationship with extra information

I'm having this Reddit like relationship shown as below. Basic idea is, each user can join many communities, and write many blogs in each community.

And there's community specific information about this user, like reputation etc. My question is, is it a good practice to put the extra information on the associative table (i.e. UserCommunities)? Why any why not?

Thanks!

enter image description here

Aucun commentaire:

Enregistrer un commentaire