Game Database Direct SQL Access: Table Descriptions
FamitsuSoftwarePie
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
|
PRI |
0000-00-00 |
|
| System |
tinytext |
|
PRI |
|
|
| Percent |
decimal(3,1) |
|
|
0.0 |
|
Fam_HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
|
MUL |
0000-00-00 |
|
| System |
tinytext |
|
MUL |
|
|
| Units |
int(11) |
|
|
0 |
|
GroupInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| GroupID |
mediumint(8) |
|
PRI |
0 |
|
| Name |
tinytext |
|
|
|
|
| Description |
text |
|
|
|
|
HardwareInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| ShortName |
tinytext |
|
MUL |
|
|
| LongName |
tinytext |
|
|
|
|
| ReleaseDateJapan |
date |
|
|
0000-00-00 |
|
| Manufacturer |
tinytext |
|
|
|
|
| SystemType |
tinytext |
|
|
|
|
| HardwareFamily |
tinytext |
|
|
|
|
| GraphColorR |
tinyint(3) unsigned |
|
|
0 |
|
| GraphColorG |
tinyint(3) unsigned |
|
|
0 |
|
| GraphColorB |
tinyint(3) unsigned |
|
|
0 |
|
| GraphOrder |
tinyint(3) unsigned |
|
|
0 |
|
HardwareShipments
| Field |
Type |
Null |
Key |
Default |
Extra |
| Date |
date |
|
PRI |
0000-00-00 |
|
| SystemRegion |
tinytext |
|
PRI |
|
|
| Units |
int(11) |
|
|
0 |
|
MC_HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
|
MUL |
0000-00-00 |
|
| System |
tinytext |
|
MUL |
|
|
| Units |
int(11) |
|
|
0 |
|
SoftwareGroups
| Field |
Type |
Null |
Key |
Default |
Extra |
| GroupID |
mediumint(8) |
|
PRI |
0 |
|
| GameID |
mediumint(8) |
|
PRI |
0 |
|
SoftwareInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| GameID |
mediumint(8) unsigned |
|
PRI |
0 |
|
| TitleEnglish |
tinytext |
|
|
|
|
| TitleJapanese |
tinytext |
|
|
|
|
| Platform |
tinytext |
|
|
|
|
| Publisher |
tinytext |
|
|
|
|
| ReleaseDate |
date |
|
|
0000-00-00 |
|
| LaunchPrice |
mediumint(8) |
|
|
0 |
|
SoftwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
|
PRI |
0000-00-00 |
|
| Tracker |
tinytext |
|
PRI |
|
|
| GameID |
mediumint(8) unsigned |
|
PRI |
0 |
|
| Rank |
tinyint(3) unsigned |
|
|
0 |
|
| SalesWeekly |
int(10) unsigned |
|
|
0 |
|
| SalesLTD |
int(10) unsigned |
|
|
0 |
|
Game Database Direct SQL Access
Garaph