lundi 11 janvier 2016

Database design. One-to-many or Many-to-many?

In my application i need to assign multiple groups to my users. There are 1000+ users and 10-15 groups.

Which database design is better?

One-to-many:

USER_ID | GROUP_1 | GROUP_2 | ... | GROUP_15
--------------------------------------------
 1      | true    | false   | ... | true
 2      | false   | true    | ... | true
 3      | true    | true    | ... | true
 .      | .       | .       | ... | . 
 .      | .       | .       | ... | . 
 .      | .       | .       | ... | . 

or many-to-many:

USER_ID | GROUP_ID 
------------------
 1      | 1
 1      | 15
 2      | 2
 2      | 15
 3      | 1
 3      | 2
 3      | 15
 .      | .       
 .      | .       
 .      | .       

?

Aucun commentaire:

Enregistrer un commentaire