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