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 |