Because when I was to redo the relationships in my table 1: 1 I get two types in WorkBench 1: 1 --------- 1.1_ _ __ (With the dash in the middle but the straight line)
What's the difference from one to the other?
Type of relationships 1: 1
2
asked by anonymous 12.02.2014 / 11:55
1 answer
8
The difference of dashes has to be with the use of primary keys from one table to another.
In case you use --- you will get the primary key of the table with which you are making the relation, being the same as a secondary key. In the case of ___ , you import primary key from one table to the other, but now being left as the primary key and not as a secondary key.
I think the following image illustrates well what I mean:
12.02.2014 / 12:07