Game Database Direct SQL Access: Table Descriptions
CommonlyNeededWeeks
| Field |
Type |
Null |
Key |
Default |
Extra |
| Alias |
tinytext |
NO |
MUL |
|
|
| Date |
date |
NO |
|
|
|
Fake_HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
MUL |
0000-00-00 |
|
| System |
tinytext |
NO |
MUL |
|
|
| Units |
int(11) |
NO |
|
0 |
|
FamitsuSoftwarePie
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
PRI |
0000-00-00 |
|
| System |
tinytext |
NO |
PRI |
|
|
| Percent |
decimal(3,1) |
NO |
|
0.0 |
|
Fam_HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
MUL |
0000-00-00 |
|
| System |
tinytext |
NO |
|
|
|
| Units |
int(11) |
NO |
|
0 |
|
GroupInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| GroupID |
mediumint(8) |
NO |
PRI |
0 |
|
| Name |
tinytext |
NO |
|
|
|
| Description |
text |
NO |
|
|
|
GroupWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
PRI |
0000-00-00 |
|
| Tracker |
tinytext |
NO |
PRI |
|
|
| GroupID |
mediumint(8) unsigned |
NO |
PRI |
0 |
|
| SalesWeekly |
int(10) unsigned |
NO |
|
0 |
|
| SalesLTD |
int(10) unsigned |
NO |
|
0 |
|
HardwareInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| ShortName |
tinytext |
NO |
UNI |
|
|
| LongName |
tinytext |
NO |
|
|
|
| ReleaseDateJapan |
date |
NO |
|
0000-00-00 |
|
| Manufacturer |
tinytext |
NO |
|
|
|
| SystemType |
tinytext |
NO |
|
|
|
| HardwareFamily |
tinytext |
NO |
|
|
|
| GraphColorR |
tinyint(3) unsigned |
NO |
|
0 |
|
| GraphColorG |
tinyint(3) unsigned |
NO |
|
0 |
|
| GraphColorB |
tinyint(3) unsigned |
NO |
|
0 |
|
| GraphOrder |
smallint(5) unsigned |
NO |
|
0 |
|
HardwareShipments
| Field |
Type |
Null |
Key |
Default |
Extra |
| Date |
date |
NO |
PRI |
0000-00-00 |
|
| SystemRegion |
tinytext |
NO |
PRI |
|
|
| Units |
int(11) |
NO |
|
0 |
|
HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| WeekFirst |
date |
NO |
PRI |
|
|
| WeekLast |
date |
NO |
|
|
|
| Tracker |
tinytext |
NO |
PRI |
|
|
| System |
tinytext |
NO |
PRI |
|
|
| Group |
tinytext |
NO |
PRI |
|
|
| SalesWeekly |
int(11) |
NO |
|
|
|
| SalesLTD |
int(11) |
NO |
|
|
|
MC_HardwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
MUL |
0000-00-00 |
|
| System |
tinytext |
NO |
MUL |
|
|
| Units |
int(11) |
NO |
|
0 |
|
SoftwareGroups
| Field |
Type |
Null |
Key |
Default |
Extra |
| GroupID |
mediumint(8) |
NO |
PRI |
0 |
|
| GameID |
mediumint(8) |
NO |
PRI |
0 |
|
SoftwareInfo
| Field |
Type |
Null |
Key |
Default |
Extra |
| GameID |
mediumint(8) unsigned |
NO |
PRI |
0 |
|
| TitleEnglish |
tinytext |
NO |
|
|
|
| TitleJapanese |
tinytext |
NO |
|
|
|
| Platform |
tinytext |
NO |
MUL |
|
|
| Publisher |
tinytext |
NO |
MUL |
|
|
| ReleaseDate |
date |
NO |
|
0000-00-00 |
|
| LaunchPrice |
mediumint(8) |
NO |
|
0 |
|
SoftwareInfoFour
| Field |
Type |
Null |
Key |
Default |
Extra |
| GameIDFour |
mediumint(8) unsigned |
NO |
PRI |
0 |
|
| TitleEnglishFour |
tinytext |
NO |
|
|
|
| PlatformFour |
tinytext |
NO |
MUL |
|
|
| PublisherFour |
tinytext |
NO |
MUL |
|
|
SoftwareWeekly
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
PRI |
0000-00-00 |
|
| Tracker |
tinytext |
NO |
PRI |
|
|
| GameID |
mediumint(8) unsigned |
NO |
PRI |
0 |
|
| Rank |
tinyint(3) unsigned |
NO |
|
0 |
|
| SalesWeekly |
int(10) unsigned |
NO |
|
0 |
|
| SalesLTD |
int(10) unsigned |
NO |
|
0 |
|
WeeklyLinks
| Field |
Type |
Null |
Key |
Default |
Extra |
| Week |
date |
NO |
|
0000-00-00 |
|
| LinkText |
tinytext |
NO |
|
|
|
| LinkURL |
tinytext |
NO |
|
|
|
Game Database Direct SQL Access
Garaph