Tables - football.db Schema Docu (original) (raw)

football • world • support •

football Tables

alltime_standing_entries •alltime_standings •assocs •assocs_assocs •badges •event_standing_entries •event_standings •events •events_grounds •events_teams •games •goals •grounds •group_standing_entries •group_standings •groups •groups_teams •leagues •persons •rosters •rounds •seasons •teams •

world Tables

cities •continents •countries •country_codes •langs •names •places •regions •usages •

support Tables

logs •props •taggings •tags •

alltime_standing_entries •alltime_standings •assocs •assocs_assocs •badges •event_standing_entries •event_standings •events •events_grounds •events_teams •games •goals •grounds •group_standing_entries •group_standings •groups •groups_teams •leagues •persons •rosters •rounds •seasons •teams •

Table alltime_standing_entries

Name Type Default Description
id integer
alltime_standing_id integer
team_id integer
pos integer NOT NULL
played integer NOT NULL
won integer NOT NULL
lost integer NOT NULL
drawn integer NOT NULL
goals_for integer NOT NULL
goals_against integer NOT NULL
pts integer NOT NULL
recs integer NOT NULL
comments varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table alltime_standings

Name Type Default Description
id integer
key varchar
title varchar
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table assocs

Name Type Default Description
id integer
key varchar
title varchar
since integer NOT NULL
web varchar NOT NULL
country_id integer NOT NULL
national boolean f
continental boolean f
intercontinental boolean f
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table assocs_assocs

Name Type Default Description
id integer
assoc1_id integer
assoc2_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table badges

Name Type Default Description
id integer
team_id integer
league_id integer
season_id integer
title varchar
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table event_standing_entries

Name Type Default Description
id integer
event_standing_id integer
team_id integer
pos integer NOT NULL
played integer NOT NULL
won integer NOT NULL
lost integer NOT NULL
drawn integer NOT NULL
goals_for integer NOT NULL
goals_against integer NOT NULL
pts integer NOT NULL
comments varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table event_standings

Name Type Default Description
id integer
event_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table events

Name Type Default Description
id integer
key varchar
league_id integer
season_id integer
start_at date
end_at date NOT NULL
team3 boolean t
sources varchar NOT NULL
config varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table events_grounds

Name Type Default Description
id integer
event_id integer
ground_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table events_teams

Name Type Default Description
id integer
event_id integer
team_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table games

Name Type Default Description
id integer
key varchar NOT NULL
round_id integer
pos integer
group_id integer NOT NULL
team1_id integer
team2_id integer
play_at datetime
postponed boolean f
play_at_v2 datetime NOT NULL
play_at_v3 datetime NOT NULL
ground_id integer NOT NULL
city_id integer NOT NULL
knockout boolean f
home boolean t
score1 integer NOT NULL
score2 integer NOT NULL
score1et integer NOT NULL
score2et integer NOT NULL
score1p integer NOT NULL
score2p integer NOT NULL
score1i integer NOT NULL
score2i integer NOT NULL
score1ii integer NOT NULL
score2ii integer NOT NULL
next_game_id integer NOT NULL
prev_game_id integer NOT NULL
winner integer NOT NULL
winner90 integer NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table goals

Name Type Default Description
id integer
person_id integer
game_id integer
team_id integer
minute integer NOT NULL
offset integer 0
score1 integer NOT NULL
score2 integer NOT NULL
penalty boolean f
owngoal boolean f
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table grounds

Name Type Default Description
id integer
key varchar
title varchar
synonyms varchar NOT NULL
country_id integer
city_id integer NOT NULL
since integer NOT NULL
capacity integer NOT NULL
address varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table group_standing_entries

Name Type Default Description
id integer
group_standing_id integer
team_id integer
pos integer NOT NULL
played integer NOT NULL
won integer NOT NULL
lost integer NOT NULL
drawn integer NOT NULL
goals_for integer NOT NULL
goals_against integer NOT NULL
pts integer NOT NULL
comments varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table group_standings

Name Type Default Description
id integer
group_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table groups

Name Type Default Description
id integer
event_id integer
title varchar
pos integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table groups_teams

Name Type Default Description
id integer
group_id integer
team_id integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table leagues

Name Type Default Description
id integer
key varchar
title varchar
country_id integer NOT NULL
club boolean f
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table persons

Name Type Default Description
id integer
key varchar
name varchar
synonyms varchar NOT NULL
code varchar NOT NULL
born_at date NOT NULL
city_id integer NOT NULL
region_id integer NOT NULL
country_id integer NOT NULL
nationality_id integer NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table rosters

Name Type Default Description
id integer
person_id integer
team_id integer
event_id integer NOT NULL
pos integer
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table rounds

Name Type Default Description
id integer
event_id integer
title varchar
title2 varchar NOT NULL
pos integer
knockout boolean f
start_at date
end_at date NOT NULL
auto boolean t
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table seasons

Name Type Default Description
id integer
key varchar
title varchar
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table teams

Name Type Default Description
id integer
key varchar
title varchar
title2 varchar NOT NULL
code varchar NOT NULL
synonyms varchar NOT NULL
country_id integer
city_id integer NOT NULL
club boolean f
since integer NOT NULL
address varchar NOT NULL
web varchar NOT NULL
assoc_id integer NOT NULL
national boolean f
created_at datetime NOT NULL
updated_at datetime NOT NULL

world Tables

cities •continents •countries •country_codes •langs •names •places •regions •usages •

Table cities

Name Type Default Description
id integer
name varchar
key varchar
place_id integer
code varchar NOT NULL
alt_names varchar NOT NULL
country_id integer
region_id integer NOT NULL
city_id integer NOT NULL
pop integer NOT NULL
popm integer NOT NULL
area integer NOT NULL
m boolean f
c boolean f
d boolean f
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table continents

Name Type Default Description
id integer
name varchar
slug varchar
key varchar
place_id integer
alt_names varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table countries

Name Type Default Description
id integer
name varchar
slug varchar
key varchar
place_id integer
code varchar
alt_names varchar NOT NULL
hist_names varchar NOT NULL
pop integer
area integer
continent_id integer NOT NULL
country_id integer NOT NULL
s boolean f
c boolean f
d boolean f
m boolean f
motor varchar NOT NULL
alpha2 varchar NOT NULL
alpha3 varchar NOT NULL
num varchar NOT NULL
fifa varchar NOT NULL
ioc varchar NOT NULL
fips varchar NOT NULL
net varchar NOT NULL
wikipedia varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table country_codes

Name Type Default Description
id integer
name varchar
kind varchar
country_id integer

Table langs

Name Type Default Description
id integer
key varchar
name varchar
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table names

Name Type Default Description
id integer
name varchar
place_id integer
lang varchar en
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table places

Name Type Default Description
id integer
name varchar
kind varchar
lat float NOT NULL
lng float NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table regions

Name Type Default Description
id integer
name varchar
key varchar
place_id integer
code varchar NOT NULL
abbr varchar NOT NULL
iso varchar NOT NULL
nuts varchar NOT NULL
alt_names varchar NOT NULL
country_id integer
pop integer NOT NULL
area integer NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table usages

Name Type Default Description
id integer
country_id integer
lang_id integer
official boolean t
minor boolean f
percent float NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

support Tables

logs •props •taggings •tags •

Table logs

Name Type Default Description
id integer
msg varchar
level varchar
app varchar NOT NULL
tag varchar NOT NULL
pid integer NOT NULL
tid integer NOT NULL
ts varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table props

Name Type Default Description
id integer
key varchar
value varchar
kind varchar NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table taggings

Name Type Default Description
id integer
tag_id integer
taggable_id integer
taggable_type varchar
created_at datetime NOT NULL
updated_at datetime NOT NULL

Table tags

Name Type Default Description
id integer
key varchar
slug varchar
name varchar NOT NULL
grade integer 1
parent_id integer NOT NULL
created_at datetime NOT NULL
updated_at datetime NOT NULL