+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Designing a database using Datamapper (/showthread.php?tid=17718)
Designing a database using Datamapper - El Forum - 04-13-2009
[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