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