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