I have read the documentation and university courses on data modelling and the text often mentions many-to-many relationships such as product tags. This is displayed in the data model as having a bi-directional arrow and will allow filtering of products by tag on data dashboards.
However, when I import database tables from my database, the model only ever shows the arrows going from products to tags only, which means I can never use the tags table to filter my products.
My pivot table has the following columns:
id (the id of the pivot item)
product_id (foreign key that links to id on the products table)
tag_id (foreign key that links to id on the tags table)
Each product can have multiple tags and each tag can have multiple products, but this is not reflected in the data model diagram. What am I doing wrong?
Best answer by Julius KosView original