Last Site Update: 18 January 2010

GWAP API

Database Structure of GWAP API

Databases
ESP
ESPTOP
 
Tables in ESP
game
label
label_to_be
pic
pic_metadata
session
Tables in ESPTOP
toplist
 

Columns of Table "ESP.game"

FieldType
id
start_ts
u_ip1
u_ip2
int(11)
timestamp
text
text
 

Columns of Table "ESP.label"

FieldType
id
session_id
taboo
score
int(11)
int(11)
int(11)
text
 

Columns of Table "ESP.pic"

FieldType
id
filename
grp
isplaying
add_ts
label_count
int(11)
text
text
tinyint(1)
timestamp
int(11)
 

Columns of Table "ESP.pic_metadata"

FieldType
id
pic_id
tag
int(11)
int(11)
text
 

Columns of Table "ESP.session"

FieldType
id
game_id
pic_id
end_reason
end_ts
int(11)
int(11)
int(11)
text
timestamp
 

Columns of Table "ESP.toplist"

FieldType
id
name1
name2
score
ts
int(11)
text
text
int(11)
timestamp