Hello,

i have following problem:

I have one table MODULE.
And i have one table CONSUMER.

Now i want to connect MODULE with CONSUMER,
because evry MODUL has one CONSUMER.

But the difficult part is, that i need another connection
from MODULE to CONSUMER.

Both are 1 to 1, but they are different.

Consumer has only one PK wich the Module has to connect with.
Module have two Columns with IDs for Consumer.

And all this with XML File, not with annotations...

How can i solve that problem?

I tryed to search for that, but i cant discribe my problem.

Thank you for your answers :)

I am not sure about what you are trying to do. Please, write the names of the columns in each table which refer to table relations, and what kind of relation they support. That would help to solve your problem.

I am not sure about what you are trying to do. Please, write the names of the columns in each table which refer to table relations, and what kind of relation they support. That would help to solve your problem.

Table MODULE
columns: module_id int <pk>
main_consumer_id int <fk1>
alternativ_consumer_id int <fk2>
....

Table CONSUMER
columns: consumer_id int <pk>
...


I want to connect main_consumer_id with consumer_id
and a second connection from alternativ_consumer_id to consumer_id.

Afther this, i have two 1..1 relations.