I am creating a project management application for my portfolio similar to Jira where Users can collaborate on projects, create tickets, leave comments on tickets, etc.. I’m setting up the entity relationships and I’m a bit confused about how to set them up when there are user roles involved. For example, each User can have many projects and each project can have many Users, so there is a many to many relationship. However, since each user needs a specific role for each project, I created a third entity called ProjectUser which has a composite key of both the User id and the Project id and contains a role property.

We have an entity type class that when it is converted to its dto class, I want a property to be set with additional calculations. Entity class:

We have an entity type class that when it is converted to its dto class, I want a property to be set with additional calculations. Entity class: