Hi,

I guess you shouldn't rely on a relationnal model of data. Maybe NoSQL could help.. You can have a look at http://www.mongodb.org/ It is a type of database that allows you to embed elements inside each others, to have a tree architecture for example

Then, you have a few plugins to help you retrieve the info at the level you want.. like https://github.com/jenssegers/laravel-mongodb

Polymorphic relationship ?

merlosy said:

Hi,

I guess you shouldn't rely on a relationnal model of data. Maybe NoSQL could help.. You can have a look at http://www.mongodb.org/ It is a type of database that allows you to embed elements inside each others, to have a tree architecture for example

Then, you have a few plugins to help you retrieve the info at the level you want.. like https://github.com/jenssegers/laravel-mongodb

I'm locked in MySQL from other parts of the application.

pmall said:

Polymorphic relationship ?

When I opened the thread i had polymorphic relationship in mind I just didn't know how to structure it/use it in this particular case. (as it's somewhat different than all the examples I could find).