Database Schemata

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 •

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 •

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