I'm basing my opinions/ideas on this model: http://wiki.oregami.org/display/OR/UML+Model
First rather minor thing that I think would be useful since you intend to track patch information, I think that there should be additional boolean field called "Major Patch" or something like that. Reason being that many F2P games release weekly patches, most of them are rather trivial (additional items for cash shop, some bug fix), but every 3-4 months bigger patch is usually released that introduces big balance changes (if game is somewhat competitive) and adds some additional content. So if we take something like League of Legends for example, we would have lots of patches and user would be overwhelmed by information. Being able to filter out "minor patches" would greatly increase readability or so I believe.
Next thing is a question about Withdrawal. What is it exactly? When patch isn't available anymore from official sources? Wouldn't in most cases this date be same as release of the next patch? Like I think I would like to see some example on this situation and how would it work out since at the moment that information sounds a bit dubious.
And now something that I might be a bit anal about, namely "Authorized Patch" field. I assume this is to separate official patches from "fan patches"? Now first thing is my assumption that main difference between patch and mod is that patch is official game modification while mod is unofficial (done by fans) modification. So all unauthorized patches should be treated as mods. Mods are often divided into few types: Total Conversion (changes lots of things about the game that it usually can be treated as separate game), unofficial patches (includes bug fixes after developer abandons game and fan translations of, usually, jap games) and other mods (basically anything that doesn't fit in previous categories). There are also some remakes done of older games while using newer game as a base, but I think those fall under Total Conversion type too. In other words my belief is that "unauthorized patches" should be treated as a type of mods and not as a type of patches.
Now I don't see in model anything about mods so my question is, if "fan patches" are going to be the only type of mods tracked? Will Total Conversion mods be ignored or will they be treated as separate games? If so there should be some linking done with original game, I imagine something along what was proposed in this thread.
First rather minor thing that I think would be useful since you intend to track patch information, I think that there should be additional boolean field called "Major Patch" or something like that. Reason being that many F2P games release weekly patches, most of them are rather trivial (additional items for cash shop, some bug fix), but every 3-4 months bigger patch is usually released that introduces big balance changes (if game is somewhat competitive) and adds some additional content. So if we take something like League of Legends for example, we would have lots of patches and user would be overwhelmed by information. Being able to filter out "minor patches" would greatly increase readability or so I believe.
Next thing is a question about Withdrawal. What is it exactly? When patch isn't available anymore from official sources? Wouldn't in most cases this date be same as release of the next patch? Like I think I would like to see some example on this situation and how would it work out since at the moment that information sounds a bit dubious.
And now something that I might be a bit anal about, namely "Authorized Patch" field. I assume this is to separate official patches from "fan patches"? Now first thing is my assumption that main difference between patch and mod is that patch is official game modification while mod is unofficial (done by fans) modification. So all unauthorized patches should be treated as mods. Mods are often divided into few types: Total Conversion (changes lots of things about the game that it usually can be treated as separate game), unofficial patches (includes bug fixes after developer abandons game and fan translations of, usually, jap games) and other mods (basically anything that doesn't fit in previous categories). There are also some remakes done of older games while using newer game as a base, but I think those fall under Total Conversion type too. In other words my belief is that "unauthorized patches" should be treated as a type of mods and not as a type of patches.
Now I don't see in model anything about mods so my question is, if "fan patches" are going to be the only type of mods tracked? Will Total Conversion mods be ignored or will they be treated as separate games? If so there should be some linking done with original game, I imagine something along what was proposed in this thread.