Will this database of persons be inside eZp? And is the roles fixed or different from movie to movie? (Is this going to be a dynamic representation of the whole credit list pr move?)
The name of the roles are fixed but the number of roles for a movie differ from movie to movie. It is as you write the whole credit list I want to implement, eg. credit list for movies in imdb.com.
/vathanan
"Ninety percent of everything is crap"
~Sturgeon's law
I don't know if this helps to understand the problem better but if I were to develop this scenario in eZ<b>2</b> I will create the following database tables and columns (columns in <>):
Ok, then you might be on the right track (to create a custom datatype for it) If it was only director and a couple of other roles I would have suggested one object realtionlist pr role or something.
Do you know of any datatype that I could look into for help to develop this?
I have browsed the Authors, Country, and Category datatypes. The Authors datatype stores the values as 'freetext'. I haven't yet figured out how the other two store the values.
/vathanan
ps. kracker> Fun .. yes ... but also a lot of work I guess. :)
"Ninety percent of everything is crap"
~Sturgeon's law
I never said it would be <b>easy</b> ...
there are many ways to implement different kinds of functionality. not all of them are quickly implemented.
stay fluid, creative and inventive ... I don't see what the problem is ...
I'm not the right person to ask for datatype stuff.
You can even implement it without creating a new datatype. Create a folder structure like this
roles(folder)
|-director(folder)
| |- Joe (person)
| |- Martin (person)
|-actor
| |- Sandy
| |- Martin (second node placement) |- art director
And then a object relation from movie to person, and where parent node name is role. But you'll need to add a new node placement to existing persons all the time and I't wouldn't be that easy to maintain.