Database Schemata

Symbols A-Z

ABCDEFGHIJKLMNOPQRSTUVWXYZ

A

alltime_standing_entries alltime_standings assocs assocs_assocs
abbr ( regions )
address ( grounds • teams )
alltime_standing_id ( alltime_standing_entries )
alpha2 ( countries )
alpha3 ( countries )
alt_names ( cities • continents • countries • regions )
app ( logs )
area ( cities • countries • regions )
assoc1_id ( assocs_assocs )
assoc2_id ( assocs_assocs )
assoc_id ( teams )
auto ( rounds )

B

badges
born_at ( persons )

C

cities continents countries country_codes
c ( cities • countries )
capacity ( grounds )
city_id ( cities • games • grounds • persons • teams )
club ( leagues • teams )
code ( cities • countries • persons • regions • teams )
comments ( alltime_standing_entries • event_standing_entries • group_standing_entries )
config ( events )
continent_id ( countries )
continental ( assocs )
country_id ( assocs • cities • countries • country_codes • grounds • leagues • persons • regions • teams • usages )
created_at ( alltime_standing_entries • alltime_standings • assocs • assocs_assocs • badges • cities • continents • countries • event_standing_entries • event_standings • events • events_grounds • events_teams • games • goals • grounds • group_standing_entries • group_standings • groups • groups_teams • langs • leagues • logs • names • persons • places • props • regions • rosters • rounds • seasons • taggings • tags • teams • usages )

D

d ( cities • countries )
drawn ( alltime_standing_entries • event_standing_entries • group_standing_entries )

E

event_standing_entries event_standings events events_grounds events_teams
end_at ( events • rounds )
event_id ( event_standings • events_grounds • events_teams • groups • rosters • rounds )
event_standing_id ( event_standing_entries )

F

fifa ( countries )
fips ( countries )

G

games goals grounds group_standing_entries group_standings groups groups_teams
game_id ( goals )
goals_against ( alltime_standing_entries • event_standing_entries • group_standing_entries )
goals_for ( alltime_standing_entries • event_standing_entries • group_standing_entries )
grade ( tags )
ground_id ( events_grounds • games )
group_id ( games • group_standings • groups_teams )
group_standing_id ( group_standing_entries )

H

hist_names ( countries )
home ( games )

I

id ( alltime_standing_entries • alltime_standings • assocs • assocs_assocs • badges • cities • continents • countries • country_codes • event_standing_entries • event_standings • events • events_grounds • events_teams • games • goals • grounds • group_standing_entries • group_standings • groups • groups_teams • langs • leagues • logs • names • persons • places • props • regions • rosters • rounds • seasons • taggings • tags • teams • usages )
intercontinental ( assocs )
ioc ( countries )
iso ( regions )

J

K

key ( alltime_standings • assocs • cities • continents • countries • events • games • grounds • langs • leagues • persons • props • regions • seasons • tags • teams )
kind ( country_codes • places • props )
knockout ( games • rounds )

L

langs leagues logs
lang ( names )
lang_id ( usages )
lat ( places )
league_id ( badges • events )
level ( logs )
lng ( places )
lost ( alltime_standing_entries • event_standing_entries • group_standing_entries )

M

m ( cities • countries )
minor ( usages )
minute ( goals )
motor ( countries )
msg ( logs )

N

names
name ( cities • continents • countries • country_codes • langs • names • persons • places • regions • tags )
national ( assocs • teams )
nationality_id ( persons )
net ( countries )
next_game_id ( games )
num ( countries )
nuts ( regions )

O

official ( usages )
offset ( goals )
owngoal ( goals )

P

persons places props
parent_id ( tags )
penalty ( goals )
percent ( usages )
person_id ( goals • rosters )
pid ( logs )
place_id ( cities • continents • countries • names • regions )
play_at ( games )
play_at_v2 ( games )
play_at_v3 ( games )
played ( alltime_standing_entries • event_standing_entries • group_standing_entries )
pop ( cities • countries • regions )
popm ( cities )
pos ( alltime_standing_entries • event_standing_entries • games • group_standing_entries • groups • rosters • rounds )
postponed ( games )
prev_game_id ( games )
pts ( alltime_standing_entries • event_standing_entries • group_standing_entries )

Q

R

regions rosters rounds
recs ( alltime_standing_entries )
region_id ( cities • persons )
round_id ( games )

S

seasons
s ( countries )
score1 ( games • goals )
score1et ( games )
score1i ( games )
score1ii ( games )
score1p ( games )
score2 ( games • goals )
score2et ( games )
score2i ( games )
score2ii ( games )
score2p ( games )
season_id ( badges • events )
since ( assocs • grounds • teams )
slug ( continents • countries • tags )
sources ( events )
start_at ( events • rounds )
synonyms ( grounds • persons • teams )

T

taggings tags teams
tag ( logs )
tag_id ( taggings )
taggable_id ( taggings )
taggable_type ( taggings )
team1_id ( games )
team2_id ( games )
team3 ( events )
team_id ( alltime_standing_entries • badges • event_standing_entries • events_teams • goals • group_standing_entries • groups_teams • rosters )
tid ( logs )
title ( alltime_standings • assocs • badges • grounds • groups • leagues • rounds • seasons • teams )
title2 ( rounds • teams )
ts ( logs )

U

usages
updated_at ( alltime_standing_entries • alltime_standings • assocs • assocs_assocs • badges • cities • continents • countries • event_standing_entries • event_standings • events • events_grounds • events_teams • games • goals • grounds • group_standing_entries • group_standings • groups • groups_teams • langs • leagues • logs • names • persons • places • props • regions • rosters • rounds • seasons • taggings • tags • teams • usages )

V

value ( props )

W

web ( assocs • teams )
wikipedia ( countries )
winner ( games )
winner90 ( games )
won ( alltime_standing_entries • event_standing_entries • group_standing_entries )

X

Y

Z