Hi Fabiano
It seems that you have a hierarchical data model.  Did you look into
the idea of nested sets and use a single table which self-references
using fields 'left' and 'right'.  Did you already learn about that
concept?  I mean,  perhaps you already considered and dismissed it.
Some links here which might be interesting:
http://troels.arvin.dk/db/rdbms/links/#hierarchical
http://en.wikipedia.org/wiki/Tree_structure
-D

Reply via email to