How this setup of 3 tables generally work.grnerally I find

Question

C#

Pythongames

How this setup of 3 tables generally work.grnerally I find

tad hard regarding the foreign key setup.could some explain pls?

0

27.01.2024

2 ответов

5 просмотров

Jass

generally there are masters of product and customers,order entry has a customer and multiple products, a customer can have multiple order entries, and one order entry can have multiple products customer -> order 1 -> (p1,p2..) order2 -> (p1,p2)

0

3 месяца назад

André 𓆏 (ZeroGC ᵉⁿˡⁱᵍʰᵗᵉⁿᵉᵈ 🇧🇷) · Accepted Answer

André 𓆏 (ZeroGC ᵉⁿˡⁱᵍʰᵗᵉⁿᵉᵈ 🇧🇷)

I think it would be an N:N relationship, after all 1 customer can place 1 order with multiple products and 1 product can be sold in multiple orders by multiple customers. So Customer N:N with products and orders is the "join" table.

0

3 месяца назад

Похожие чаты

How this setup of 3 tables generally work.grnerally I find

2 ответов

Похожие вопросы