I have conceptual question about DB schema. I have 2 entities: Team and Member.
1.Member can belong to many Teams,
2.Team can have many Members.
So it's many-to-many relationship and I've implemented it successfully. Now the client wants to have ordered Members within a Team. So Member can have priority in one team different than in the other.
How properly implemented DB schema should look like? I considering about 2 options:
- with minimum work effort
- the proper solution
Any hints are more than welcome. Thanks.
Aucun commentaire:
Enregistrer un commentaire