MySQL Many to Many with additional data in intermediary table

many-to-manyMySQL

I need to create a Many to Many relationship and understand the need for an intermediate table to act as the link between the two. The understanding I have is the Group of ID's in the intermediate table should be unique to not duplicate data; is this correct?

The DB that I am designing is for a deck of cards.

I have two tables: decks and cards. The intermediary table is deck_cards.

The issue I am facing is: a deck can contain many cards but can also contain more than one of the same card.

Below is a screen shot of my current Schema. I am currently storing an additional bit of data in the column amount in the deck_cards table for a given relationship. Is this the appropriate way to approach this situation? Or, is there another intermediary table that is needed to be created?

many to many schema

Best Answer