Draw arrows between columns?

[krlmlr]

Thanks for the very helpful package!

I wonder if the columns of a table could be modeled as a subgraph inside the table nodes. This would allow linking the columns directly, we wouldn't need the ~ anymore.

[bergant]

It is possible to use PORT attribute in graphviz HTML table. The result would be as shown in example below. Maybe I can support this kind of rendering as an option, since more complex diagrams may get messy...

[krlmlr]

Thanks. Can you also link the arrow pointers to a column (e.g., to "Order ID" instead of the "Order" node)?

[bergant]

Yes

[krlmlr]

Oh, that looks really good! Looking forward to it ;-)

[bergant]

Here is the first attempt ...

Use columnArrows = TRUE when calling dm_create_graph.

[krlmlr]

Thanks. This looks slightly odd with rankdir = "LR", but I still like it: https://github.com/r-prof/profile/blob/24ab0ba316ea545fb06f1323ff597c16f97ef552/man/figures/dm.png

Can you specify more than one PORT attribute for a column, so that graphviz can choose what it thinks looks best?

[bergant]

I think that only the first PORT is then taken into account. Linking from both side will only work if there is only one cell in a row (in your example - without the type column).

BTW, if you want to try something directly with graphviz, there is always a graphviz source in the graph$dot_code element.

[krlmlr]

Thanks. The dot source is useful for fine-tuning, but it would be great if this worked also for autogenerated diagrams.

I guess we still can squeeze all columns in a row into one, what other column types do you support?

[hswerdfe]

I am very late to the discussion, but to expand on @krlmlr comment about looking funny with rankdir = "LR" this is what my DB looks like when rendered columnArrows = TRUE it is a definite improvement, but there are sometimes strange effects where the arrow moves to the top right of the table then to the correct location.

thanks for all your work on the @bergant its a great package.

[krlmlr]

Thanks for the follow-up. Have you seen the new dm package? Unfortunately it will probably suffer from the same problem, because diagram drawing is inherited from here 🙃

[hswerdfe]

@krlmlr I have not seen dm I assume you mean this, I'll look into it.