I am wondering how you represent a many-to-many relationship that is supported by a join table. Here is a
link to a clear example. There is a
category table, and a
stock_category table to join them. A stock can have many categories and vice versa. So the join table has two ids, a
stock_id foreign key to the stock table and a
category_id foreign key to the category table. How is this represented as a relationship?
The other important part of this table structure is that the
stock_category table also has additional attributes. It is its own resource in that sense. This part of it is similar to these two* questions. I suppose that since it is its own resource it isn’t many-to-many anymore. A
stock has many
stock_category, but a
stock_category has only one
Either way I am quite confused on the whole topic.
*Edit, as a new user I can only put two links in a post. here is the 3rd: Metadata About Relationships