A
A
apaicer2016-10-14 21:40:27
Database
apaicer, 2016-10-14 21:40:27

How to set 2 foreign keys in 1 table?

In general, after creating an ER diagram, you need to file foreign keys on it in the designer on openserver hphmyadmin. However, I can't create 2 relationships in 1 table, what's wrong?
52eebb91557c4332b6a8d5bd4e2db75f.jpg
PS do not look at the keys in the attributes, out of desperation I am already trying to somehow achieve the result, so I assign it to "maybe" I
did it based on this diagram.
f5ffe420d0704c259f72f02cc1cd175e.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vasily K, 2016-10-20
@gonzalez187

There are many options .. for example, here:
1) In Wholesale_purchase, the key is composite on the upper scheme (Wholesale_purchase_code + Product_code)?
2) Are there spaces in the names of tables and fields?
3) It is better not to use the Russian language) there may be troubles + you can get tired then change the layout)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question