I write to make a query or guidance on a MER referring to an inventory system.
I have two entities:
Equipo ------------------- Usuario
According to my requirements, I need to generate a many-to-many relationship, which is why I am generating a new entity, which I call "Assignment"
Asignación
- ID Asignación PK
- ID Equipo FK
- ID Usuario FK
My query is as follows, can I assign another FK from the User entity to the Assignment entity again? I need to incorporate the user responsible for that assignment in addition to the user, and I do not want to create a new entity for the technician since the attributes are similar to those of the user entity.
Thank you,