0
Answered

Difference between dotted lines and non-dotted lines

jairo.suarez 5 months ago updated by Support 5 months ago 2

Hi guys

I wondering and trying to looking at the difference between dotted lines and non-dotted lines in my project.

Additional, what does mean the diamond/rhombus? Does it mean MANY?

What does mean the dot in the final point of line? Does it mean one?

Thanks for your support and help me put to understand.

Regards;

Jairo Suarez

GOOD, I'M SATISFIED

Thank you so much, Paul. The information has been very useful.

Satisfaction mark by jairo.suarez 5 months ago

Hi Jairo,


Dotted vs complete lines is down the relationship you're portraying.

Dotted is non identifying join type typically PK to FK

Regular lines are identifying joins and typically PK to PK


In this screenshot from one of my models, a record cannot exist in the yellow table without a corresponding record in the blue table (it's parent) making it an identifying relationship.


The blue table may have none, 1 or many records in the green table making it a optional, or non-identifying link.

You can change this by click on your join and changing the checkbox for relationship:


As for circle vs rhombus.   The circle denotes the destination of the join I believe.   The rhombus I've not seen in my models but I'm using a different methodology to you and we might be working on a different database types.

Hope this helps

Answered

Thank you Paul, yes that is underlying meaning of Dotted Vs Solid relationship line.

Dear Jairo, please feel free to ask if you any further questions.

Thanks,

Ajay