Hey I want to delete relations between elements of two tables that are defined in a middletable. I can add new ones but can't delete them without adding a primary key.
Does that mean I have to add a primary key to every middle table aswell?
I dont plan on using the tables for anything else than creating relations
Hi @KungFooLemmi, creating a table without a primary key should only be done for entities that do not relate to any other table. For a join table like the one you shared, you should always have a primary key.
1 Like