Question about relationships

It's a bit har to understand the relationship between the tables from your description.

However this is a little trick that I use to be able to know what I need in my database model.

Lets say I have a books table.

• A book has an author + An author can have many books = One to many
• A book has one format + A format can have many books = One to many

Now to make it a bit more complex (pivot)

• A book can have many authors + An author can have many books = Many to many.

So I suggest you do that with your three tables

• A build can have ??? A ??? can have ? builds and so on.

Hey, thanks for your response. I'm sorry for my bad explanation, I can give you another one.

I'm struggling to understand the complete concept behind that.

So let's say I Recipe book, which consists of three tables Recipes, Ingredients & Units.

Now I hook them up together so I know which combination of Ingredient & Unit belongs to the given Recipe.

So I thought I have to do some kind of Pivot Table where I have the id from the Recipe, the Ingredient, and the Unit in there. Additionally, I add another column in there for the Amount which is just a basic integer.

So I can access all the Ingredients with the correct Unit and Amount directly from the Recipe trough the Pivot table.

in this specific case, I would have just ingredients and recipe.

recipe has many ingredients, ingredient belongs to recipe.

ingredient contains its name, the quantity and measure . things like cup, spoon, ml, gram etc can come from simple lookup list.

So no pivot in this example?

Yea I thought about this as well, but I thought it would become very fast very redundant.

But I think I'm going the way you described.

Thank you very much.