Hi Friends,
I´m with a great problem.
I have a relationship as represented in figure below:
RELAC_PROJ (N) <--------- (1) PROJECT
I have two relationship one-to-many of Project to Relac_Proj.
In this case, I have the following structure of tables:
Table PROJECT:
"id" and "version" are fields that represent the primary key of table,
composed key (both Integer)
"identification" (String)
... and others
Table RELAC_PROJ:
"id", primary key of table (sequential number - Integer)
"id_importer" and "version_importer" are foreign keys that represent the entity PROJECT "father" of relationship. (both Integer)
"id_imported" and "version_imported" are foreign keys that represent the entity PROJECT "child" related with the entity "father" (both Integer)
... and others
I´d like to relate one entity PROJECT into entity RELAC_PROJ, of form that it represent the entity "father" of my relationship, and in the same one, i´d like to represent another entity PROJECT too, that it´s the child PROJECT of relationship.
For this, i have two objects Project into object RelProjects.
However, at the same time, I need to load into object Project a collection (Set in this case) of the RelProject, that represented through "id_importer" and "version_importer".
Will be that somebody could help me? Please.
Since already i´m thakful.
|