multi column relationships - PK is composite key

[aisbergde]

Expected Behavior

it should be possible to show multi colum relationships as one relationship

example: if the relationship is defined as
Tab1.A = Tab2.A
and Tab1.B = Tab2.B
and Tab1.C = Tab2.C

• it should be possible to define this kind of relationship via XML
• the relationship should be shown as one relationship
• but it should still be possible to identify the columns

Current Behavior

in the example currently 3 relationships will be listed and shown
it is very hard "to read" these diagrams

Possible Solution

extend SchemaMeta to not only define FK per column but enable to define relationships independently from column definitions.

it should be possible to link more then one column.

read existing multi column relationships from database and keep them together

[npetzall]

Just to check are we discussing composite keys. Like PK is (column a, column b)

[aisbergde]

yes, exactly, I should rename the issue

[aisbergde]

Here an example.
3 column composite key in each table or view