Representing N:N without intermediate table

since you can assign selections to dataclasses, it also seems that you can represent N:N relationships without explicitly defining an intermediate table.
does this diagram make sense? i renamed the ID’s in each table to make it clearer:

Hello Mikey!

No it’s not possible to do so. In order to represent an N:N relation, you should create an association table that will store the entity of each other table and will be the intermediary path between the two tables.

1 Like