football_fun - Laravel Schema Designer

users

id increments
username string (30)
email string (100)
password string (100)
register_ip string (15)
salt string (30)
forget_token string (100)
active_token string (100)
timestamps timestamps

pages

id increments
user_id ^FK bigInteger
name string
slug string
excerpt text
content text
meta_title string
meta_description string
meta_keywords string
status string
timestamps timestamps

posts

id increments
user_id ^FK bigInteger
name string
slug string
excerpt text
content text
meta_title string
meta_description string
meta_keywords string
status enum
post_type string
viewed integer
timestamps timestamps

tournaments

id increments
name string
slug string
year_foundation integer
country_id integer
popular integer

tournament_seasons

id increments
season_id ^FK integer
tournament_id ^FK integer
date_start date
date_finish string
lwinter_tid ^FK bigInteger
winter_team_id ^FK bigInteger
status tinyInteger
total_game integer
played_game integer
home_wins integer
draws integer
guest_wins string
total_goals integer
home_goals integer
quest_goals integer
viewers integer

teams

id increments
name string
slug string
img string
foundation_year date
country_id ^FK integer
city_id ^FK integer
instagram string
wikipedia string
facebook string
twitter string
site string
type enum
timestamps timestamp
about text

matches

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
tournament_round_id ^FK integer
tournament_group_id ^FK integer
tour smallInteger
play_date date
play_time time
team_home_id ^FK bigInteger
team_away_id ^FK bigInteger
result_1 smallInteger
result_2 smallInteger
result_extra_time string
result_match smallInteger
viewed integer
stadium_id ^FK integer
referee_id ^FK integer
description text
status smallInteger

referees

id increments
name string
slug string
img string
city_id ^FK integer
birthday date

countries

id increments
name string

cities

id increments
name string
country_id ^FK integer

stadiums

id increments
name string
slug string
img string
city_id ^FK integer
capacity integer
content text

coaches

id increments
name string
img string
birthday date
slug string

players

id increments
name string
slug string
about text
career text
img string
birthday date
growth smallInteger
weight smallInteger
instagram string
wikipedia string
facebook string
twitter string
site string

team_sesons

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id integer
team_id ^FK integer
stadium_id ^FK integer
coach_id ^FK integer
timestamps timestamp

seasons

id increments
name string
full_name string

ampluas

name string
id increments

tournament_groups

id increments
name string

tournament_types

id increments
name string

match_goals

id increments
match_id ^FK integer
player_id ^FK integer
time smallInteger
overtime smallInteger
type tinyInteger

match_cards

id increments
match_id ^FK integer
player_id ^FK integer
time integer
overtime integer
type enum

match_plaers

id increments
match_id ^FK integer
player_id ^FK integer
type tinyInteger
time_out smallInteger
time_in smallInteger

match_statistics

id increments
match_id ^FK integer
attacks smallInteger
dangerous_attacks smallInteger
shots_on_goal smallInteger
shots_on_target smallInteger
shot_on_rod smallInteger
fouls smallInteger
corner smallInteger
offside smallInteger
possession smallInteger
blocked_kicks smallInteger
penalty_kicks smallInteger
goal_kick smallInteger
outs smallInteger
yc smallInteger
rc smallInteger

tournament_stadiums

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
stadium_id ^FK integer

tournament_coaches

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
coach_id ^FK integer
games integer
wins integer
draws integer
loses integer

tournament_referees

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
referee_id ^FK integer
games integer
yc integer
2yc integer
rc integer
penalty integer

languages

id increments
code string (5)
locale string
directory string
name string

tournament_players

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
team_id ^FK integer
player_id ^FK integer
player_number smallInteger
amplua_id ^FK integer
total_minutes integer
total_games integer
start_games integer
out_games integer
subst_games integer
noplay_games integer
scored_goals integer
penalty_goals integer
nopenalty_goals integer
missed_goals integer
passes integer
yc integer
2yc integer
rc integer
type string
timestamps timestamp

tournament_tables

id increments
season_id ^FK integer
tournament_id ^FK integer
tournament_season_id ^FK integer
tournament_round_id ^FK integer
tournament_group_id ^FK integer
team_id ^FK integer
games smallInteger
wins smallInteger
draws smallInteger
loses smallInteger
scored_goals smallInteger
missed_goals smallInteger
points smallInteger
type integer

tournament_passes

id increments
match_id ^FK integer
player_id ^FK integer
time smallInteger
overtime smallInteger
timestamps timestamps

tournament_table_performances

id increments
tournament_table_id ^FK integer
position integer
game integer
match_id ^FK integer
timestamps timestamps

galleries

id increments
user_id ^FK integer
name string
url string
type_media char (6)
entity_id integer
entity_type string
timestamps timestamps
viewed integer

player_statistics

id increments
player_id ^FK integer
goals integer
passes integer
titles integer
awards integer
goal_ratio integer
penalty integer
yc string
rc integer
games string
wins integer
draws integer
loses integer
timestamps timestamps

team_rating_uefa

id increments
season_id ^FK integer
team_id ^FK integer
position integer
timestamps timestamps
old_position integer
points_1 integer
points_2 integer
points_3 integer
points_4 integer
points_5 integer
total_points integer

comments

id increments
timestamps timestamps
user_id ^FK bigInteger
comment text
parent_id integer
likes integer
dislikes integer
object_type string
object_id bigInteger

bookmakers

id increments
name integer
slug string
meta_title string
meta_description string
meta_keyword string
img string
reg_date date
bonus integer
bonus_currency char
rating integer
google_play string
app_store string
site string
phone string
email string
live_chat string
timestamps timestamps

bookmaker_faqs

id increments
bookmaker_id ^FK integer
question string
answer string
sort_order integer
status tinyInteger
timestamps timestamps

bookmaker_descriptions

id increments
bookmaker_id ^FK integer
about text
plus text
minuses text
specifications text
storage float
line_prematch float
line_life float
coefficients float
convenience float
support float
bonuses float
manufacturability float
timestamps timestamps

match_coefficients

id increments
match_id ^FK bigInteger
bookmaker_id ^FK integer
1 float
x float
2 float
1x float
x2 float
over_25 float
under_25 float
timestamps timestamps

bookmaker_reviews

id increments
user_id ^FK bigInteger
bookmaker_id ^FK integer
review text
total_rating float
storage float
line_prematch float
line_life float
coefficients float
convenience float
support float
bonuses float
manufacturability float
timestamps timestamps

tournament_raunds

id increments
timestamps timestamps
name string
slug string