Forums / Install & configuration / Implement and showing many to many relations?

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Implement and showing many to many relations?

Previous topic

Install & configuration

Next topic

Author	Message
Adolfo Barragán	Tuesday 25 March 2003 2:37:38 am I'm newbie in Exponential, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in Exponential? I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species. So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are: Countries--Packs (1:M) Countries--Country_Species (1:M) Species--Country_Species (1:M) Packs--Pack_Species (1:M) Species--Pack_Species (1:M) When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country. Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation). And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to. I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution. Thanks in advance

Author

Message

Adolfo Barragán

Tuesday 25 March 2003 2:37:38 am

I'm newbie in Exponential, and I don't know how to implement many to many relations. In a database model, I make the following but, how can I do in Exponential?

I the conceptual model Ihave 3 classes (Countries, Packs, Species) and 3 relations: Countries--Packs (1:M); Countries--Species (M:M) and Packs--Species (M:M). In addition, the relation Countries-Species have their owns attributes and also the relation Packs-Species.

So, In the physical model I have 5 classes (tables): Countries, Packs, Species, Countries_Species, Packs_Species and their relations are:
Countries--Packs (1:M)
Countries--Country_Species (1:M)
Species--Country_Species (1:M)
Packs--Pack_Species (1:M)
Species--Pack_Species (1:M)

When an user click on "content/view/full/Country_Id" I need show the attributes of Country_Id plus a list of Species of that country (and attributes of relation) plus a list of Packs of that country.

Similary with "content/view/full/Pack_Id", I need show Pack's attributes plus a list of Pack's Species (and attributes of relation).

And finally, when the user click on "content/view/full/Specie_Id I need show Specie's attributes plus a list of Packs and Countries where Specie is assigned to.

I'm sorry the extension of question but I'm weeks to battle with this and I don't find a solution.

Thanks in advance