By rabidDog on

Does anyone know of a module that would be good to used to create a relational database? Something that would be great to create a movie database (not Movie Database) like the site with the link below. I can create content types for the titles/movies and the people (cast/crew) but associating one to the other will become tedious as you have to attach each twice on both the title and person.

http://www.ncm.com/movies/overview.aspx?movie=Public-Enemies

⋅ Categories: Drupal 6.x

Comments

WorldFallz’s picture

WorldFallz commented

I'm not sure why you need to attach everything twice, but I made this with cck, views, nodereference and nodereferrer fields, nodereference_url, and rules. Though now you'll probably want to checkout the http://drupal.org/project/cck_referential_integrity module.

rabidDog’s picture

rabidDog commented

Thanks WorldFallz

didn't know about the Node Referrer modules, which is what I was missing. Now I just need to play with this to see how to use it to complete the db. Will also look into the Referential Integrity module.

WorldFallz’s picture

WorldFallz commented

welcome ;-)

referential_integrity looks very promising. Previously, I 'enforced' referential integrity (ie deleting all children when the parent is deleted) via rules and a little 'php code' for the action.