Column
Alias
events.league
league
events.id
eventid
events.date
date
games.hometeam
hometeam
games.awayteam
awayteam
games.starttime
starttime
games.homescore
homescore
games.awayscore
awayscore
games.id
gameid
leagues.sport
sportid
leagues.id
leagueid
leagues.icon
leagueicon
sports.name
sportname
sports.icon
icon
sports.duration
duration
progress.status
status
status.name
name
Column
Alias
sports.id
id
sports.name
sportsname
sports.icon
sportsicon
leagues.name
leaguename
leagues.icon
leagueicon
Column
Alias
teams.name
teamname
leagues.name
leaguename
The following is a list of the tables in the Couch Potato database:
Legend:
PK- Primary Key
NN - Not Null
AI - Auto Increment
None.
None
None
None
None
None
None
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
timestamp
DATETIME
❌
✅
❌
CURRENT_TIMESTAMP
status
VARCHAR(4)
❌
✅
❌
subcode
VARCHAR(4)
❌
✅
❌
title
VARCHAR(255)
❌
✅
❌
message
VARCHAR(1000)
❌
❌
❌
NULL
url
VARCHAR(255)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
user
INT(11)
❌
✅
❌
league
VARCHAR(45)
❌
✅
❌
date
DATE
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
fk_user_idx
INDEX
user
ASC
fk_league_idx
INDEX
league
ASC
Foreign Key
Referenced Table
Column
Referenced Column
fk_user
'couch_potato'.'users'
user
id
fk_leagues
'couch_potato'.'leagues'
league
name
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
user
INT(11)
❌
✅
❌
event
INT(11)
❌
✅
❌
hometeam
VARCHAR(100)
❌
✅
❌
awayteam
VARCHAR(100)
❌
✅
❌
starttime
VARCHAR(12)
❌
✅
❌
homescore
INT(11)
❌
❌
❌
NULL
awayscore
INT(11)
❌
❌
❌
NULL
whistle_start_time
VARCHAR(32)
❌
❌
❌
NULL
whistle_end_time
VARCHAR(32)
❌
❌
❌
NULL
Index
Type
Columns
Order
PRIMARY
PRIMARY
id, user
ASC
user_idx
INDEX
user
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
timestamp
DATETIME
❌
✅
❌
CURRENT_TIMESTAMP
type
VARCHAR(12)
❌
✅
❌
url
VARCHAR(255)
❌
✅
❌
uniqueid
VARCHAR(255)
❌
✅
❌
approveid
VARCHAR(255)
❌
✅
❌
message
VARCHAR(1000)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
timestamp
VARCHAR(60)
❌
✅
❌
uniquename
VARCHAR(255)
❌
✅
❌
call
VARCHAR(20)
❌
✅
❌
message
JSON
❌
✅
❌
url
VARCHAR(255)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
name
VARCHAR(45)
❌
✅
❌
sport
INT(11)
❌
✅
❌
icon
VARCHAR(64)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id, name
ASC
idx_name
INDEX
name
ASC
fk_sport_idx
INDEX
sport
ASC
Foreign Key
Referenced Table
Column
Referenced Column
fk_sport
'couch_potato'.'sports'
sport
id
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
game
INT(11)
❌
✅
❌
status
INT(11)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
fk_status_idx
INDEX
status
ASC
Foreign Key
Referenced Table
Column
Referenced Column
fk_status
'couch_potato'.'status'
status
id
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
name
VARCHAR(45)
✅
✅
❌
icon
VARCHAR(45)
❌
✅
❌
duration
INT(11)
❌
❌
❌
NULL
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
fk_leagues_idx
INDEX
name
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
name
VARCHAR(20)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
name
VARCHAR(100)
✅
✅
❌
icon
VARCHAR(45)
❌
✅
❌
league
INT(11)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC
fk_teams_leagues_idx
INDEX
league
ASC
Foreign Key
Referenced Table
Column
Referenced Column
fk_teams_leagues
'couch_potato'.'leagues'
league
id
Column
Datatype
PK
NN
AI
Default
id
INT(11)
✅
✅
✅
timestamp
DATETIME
❌
✅
❌
CURRENT_TIMESTAMP
username
VARCHAR(45)
❌
✅
❌
salt
VARCHAR(128)
❌
✅
❌
password
CHAR(255)
❌
✅
❌
VARCHAR(60)
❌
✅
❌
Index
Type
Columns
Order
PRIMARY
PRIMARY
id
ASC