One central DB for items (say CDs) and possibilty for users to 'collect'/rate them..
I have something similiar to the following scenario in my mind.
I'd like to have one central DB for say CDs and I'd like my users to be able to say 'Hey, Brothers in Arms, I love it and I have it in my collection' and then get it in their collection.
If they say 'Hey, I'd like to have 'Love Over Gold' in my collection as well' but that CD isn't their so they have do add it. When done, it's their for others just to pick with having to add artist or things like that.
On some central place I'd like to be able to see average rating but on users homepages/accounts just their own. Also som privileges, maybe people doesn't want to show what CDs they have at home.
And of course, it's not about CDs but hey, just an example. =)
Where do I start? Where can I read about some similiar setup? I've started too look at the CCK but.. it's just not that simple.

First, you would have to
First, you would have to build a structure of artists and cd's. The cd's would have a node reference field to an artist (multiple values, if you want to allow compilation albums and soundtracks).
Second, you would have to create a system so users can mark the cd's. I haven't used it myself, but I have been told that the flag module (http://drupal.org/project/flag) is very good for this. Flags are like checkboxes on nodes, and they can be global of per-user. A cd could have two flags, one saying 'I own this cd', the other saying 'I love this cd'. Based on these flags you can create views (see http://drupal.org/project/views), for instance a block showing the cd's that a certain user likes, but does not own.
I've gotten that far and
I've gotten that far and understood a bit about flags/taxonomy and so on. But now I have another problem.
With flags I can make users being able to build there own collection but I would also like them to be able to have some private fields with say review or things like that.
How do I solve that? Forking the node to a 'user node'? Inherit values? Is it possible to make user specific fields to a node with CCK?
Regards,
Johan
There are several
There are several review/rating modules available. Have a look at http://drupal.org/project/simple_review for instance.
The hard part here that I
The hard part here that I don't just want review and I want some information to be user specific.
Let's not compare to CDs, let's compare to food. I have a recipe instead, I'd like to give my own review about it, remember my own 'tweaks', which bottle of wine I had to the food and so on.
One global node, with some global information and perhaps even more user specific fields. Like text review, rating, which persons I had the honour to eat this food with and so on..
Wouldn't it be a solution to
Wouldn't it be a solution to create a new 'review' content type with all required fields and a node reference to the cd/recipe? If needed, you can use a module like prepopulate (http://drupal.org/project/prepopulate) to prepopulate some fields based on the node that is being reviewed.
But that would duplicate
But that would duplicate alot of information if I understand right? That's often not a good idea, I've thought about it myself but I really don't like it. I might have some information in the main node that needs to be changed after a while.
Though, maybe I would create a user based review node with just node reference to the 'global' node and use a very complex (or not, I don't know) view to present it to my users?
How hard is it to show data from different nodes in one view? Could this be a working solution?
If you prepopulate the node,
If you prepopulate the node, then yes, you're duplicating content.
With views2, you can define 'relationships'. Once you told views that the relationship between nodes is defined by a node reference field, you can display data from both nodes. You can find documentation about views relationships on this site (like http://drupal.org/node/289738) and on other sites as well (for instance the screencast on http://drewish.com/node/127).
You can find this is helpful
You might find http://www.lullabot.com/articles/a_review_of_node_review_modules is helpful.
Attitude is mind's paintbrush, it can color anything.