[eluser]jongliko[/eluser]
Hi, I'm using datamapper for some days now. I have no problem for simple structure but I'm starting a new project, and I really want to use datamapper. I have difficulty to design the database using datamapper logic.
Here some of the data I have to organize :
Artists could have many attributes (functions, style etc..)
- Singer
- Rock
- Hardrock
- Metal
- ...
- Jazz
- Swing
- New Orleans
- ...
- Musicians
- Painter
- ...
Videos could have many attributes (style, substyle)
- Documentary
- Animals
- Discovery
- ...
- Concert Live
- Jazz
- Swing
- New Orleans
- ...
- Movie
- Full-length film
- Comic
- Thriller
- ...
User could have many tastes
Music taste
- Rock
- Hardrock
- Metal
- ...
I want to have a list of properties that I can use to define user tastes, category of a video, style of an artist. As you can see above each of the properties have relation between them.
I can use for example three tables cat, sub-cat, sub-sub-cat (three levels seems to be enough for the project). I can use one table with a level's column. Or ...
I can't figure out a good logic to use with datamapper.
Thanks in advance for you help