C#•2y ago•

5 replies

Dublicate Properties in Tables?

I have a table named

Users

Users

and one named

Organizations

Organizations

. The relation between them is many to many. The joining table is called

OrganizationMember

OrganizationMember

. I'm wondering whether it would be a good idea, to store certain properties from the

User

User

table inside the

OrganizationMember

OrganizationMember

. Such as

Email

Email

, &

Full Name

Full Name

and

AvatarUrl

AvatarUrl

. The reason being is that

OrganizationMember

OrganizationMember

will be used very much. I don't want to modify my queries to include the

User

User

every time. Any suggestions would be appreciated.