Lines in the ER diagram.

[paoloholzl]

Example

In the ER diagram, lines usually originate from the fields where a relationship is set (but this does not happen in DBeaver). For example, in figure 1, this is what I need. Since the schema connects the tables but not the related fields, row-by-row adjustments are required.
It is possible to move the line, but due to the set mechanism, it is almost impossible to get from field to field without creating broken lines (see figure 2).
Sometimes reducing the number of breaks is almost impossible.

Ideally, each line should start from the fields in referential integrity (if any), and be movable if needed.
Then, a marker would be needed for each angle of the broken line (with the possibility of removing it with a right-click), as shown in example 3. Additionally, a way to move the line from its beginning (example 3, a marker that moves the start directly from its origin) would be helpful.

I use ER diagram programs for SQL Server, Oracle, and even MS Access, and none of them have these problems (they have other issues). I am providing an example of one of my diagrams to show that complex results can be achieved. I am also posting an image of the poor result of connecting all lines to the same origin with great difficulty.

The tool is splendid, but this is a significant shortcoming.

Try to connect to the same filed (orrible)

Er example

[LonwoLonwo]

Hello @paoloholzl
What DBeaver version do you use?

[paoloholzl]

I understand that the pro version has the function I need.
I accept the limitation that for the Community version one has to move relationships 'by hand'.
But the functions that are in the Community version must work, manually moving the relationships is practically bordering on unusable and it is not possible to obtain an acceptable result.
In certain cases, inextricable 'knots' are created, making it impossible to move the relation line to the point where it joins the frame.
This is currently the most serious limitation I have found in the Community version.

[E1izabeth]

If you have a clear example with steps to reproduce, you can create an issue

[paoloholzl]

Ok.
For example I have soma related tables.
I create a ER diagram

but i require to correct so

Now I try ... impossible to do

Spostamenti.mp4

[E1izabeth]

Thank you!

[E1izabeth]

I created the issue #34649