ESRB Rating

Bump.

Don't know if there has been anymore talk about this or if vtalwar still has the types he worked on somewhere. Seems like something that should be added, especially if Computer Game Version gets changed to a Standard type.

I remember trying to model this a while back here with a few examples in my Computer Game Release type. I would make a possible suggestion of making the evaluation non-unique and adding a date for times when games are re-rated.

OK, I have a few examples in the sandbox. Here are the types:

• Computer Game Rating System models the ratings boards for different countries.
• Computer Game Rating represents the actual age range-based rating, like Teen or Mature for the ESRB and A or Z for CERO.
• Computer Game Content Descriptor is for the phrases that detail the actual content of the game (Strong Language, Comic Mischief).
• Computer Game Evaluation is the compound type that is attached to a version of a game.

I think this is a good model. I (of course!) have a few thoughts, though:

I think the incoming links from Computer Game Evaluation should be reciprocated on Computer Game Rating and Computer Game Content Descriptor so you can see a list of games with a given rating/descriptor.

The Computer Game Evaluation CVT could have a property for rating system,  so that you could tell that the two ratings on San Andreas are from the same system, although it would be a bit of a denormalization since the rating system is already explicitly linked to the rating. (Actually, now that I look at the model, it isn't explicitly linked: the property "Rating System" on Computer Game Rating should be unique.)

And on Computer Game Rating, we have a choice: use "integer range" for Age Range, or create two properties for high and low values. Creating two properties has the advantage that you can make them disambiguators so that the ranges show up in a table view on the Rating System Topic: http://www.sandbox-freebase.com/view/en/entertainment_software_rating_board

Agreed on the reciprocation. Added links to the sandbox, though it still looks weird 'cause CGV is a CVT.

Rating System definitely should be unique, something I'll have to do right this time when I remake the types. I am kind of weary of making a redundant connection to the rating system, though it wouldn't be the first (Content Descriptor also has a connection to it's rating system).

Age Range is an interesting problem. Looking back, there is only one instance I can find of a rating system using ratings with both a low and high age value, the defunct ELSPA system. Even then it can be modeled in the same matter of other boards (with low-end-only age values). I would vote to keep Age Range as an integer range though to preserve the connection between the two number and to properly model the rare exception.

K, time to finish this up.

• Video Game Rating System
• Video Game Rating
• Video Game Content Descriptor
• Video Game Evaluation

Changes from the previous update: - Rating System is unique on VG Rating and Content Descriptor - Return links added on Evaluation for Rating and Content Descriptor

I'll add these types to the commons in the next couple of days unless some objections come up.

Types updated and ready for move.

I don't know if there's an behind-the-scenes way to do it, but if there's an easier way to move these types other than recreating them, let me know.

I've added the PEGI ratings in.

One very minor point: the documentation for the age range on Video Game Rating should specify it is in years.

A more serious problem I see here is the data entry one: if I want to link a game version to the ESRB "Violence" content descriptor, currently I'm offered a choice of three options by Suggest, Violence, Violence and Violence with no way of knowing which is the right one, and this problem is only going to get worse as we add more rating systems. Would making Video Game Content Descriptor/Rating system a disambiguating property help? I can still see us ending up with the wrong content descriptors being attached to things though.

As for moving types, it certainly can be done. Jeff will be able to point you in the right direction.

I believe that disambiguators are being displayed in the autocomplete flyout now, so making "Rating system" property a disambiguator should should with that.

I'll create a task in JIRA to move the types (you can do it yourself if you ever need to do it again -- just assign it to "Freebase Commons and Schema", and we'll move them for you.

Am I able to do the type moves myself? Is there more to it than:

1. assigning the new key (/cvg/video_game_rating, etc.)
2. changing the domain property on the type
3. deleting the old key?

I just realized I have enough access to do all these things, but I'll gladly sit on my hands if you're afraid I might break something.