Leagues - Laravel Schema Designer

users

timestamps timestamps
id increments
name string
email string
password string
avatar string
remember_token string
role_id ^FK integer
country_id integer
state_id integer
postal_code string
street string
stripe_id string
card_brand string
card_last_four string
date_of_birth datetime
balance decimal
username string
city string

posts

id increments
timestamps timestamps
author_id ^FK integer
title string
body text
image string
category_id ^FK integer
slug string
excerpt text
caption string
status enum
featured tinyInteger

roles

id increments
timestamps timestamps
name string
display_name string

leagues

id increments
timestamps timestamps
name string
creator_id ^FK integer
avatar string
scoring_type ^FK integer
is_public tinyInteger
team_count integer

teams

id increments
timestamps timestamps
league_id ^FK integer
user_id ^FK integer
name string
avatar string
abbreviation string
winnings integer
is_commissioner tinyInteger
points decimal
points_last decimal
position integer
auction_budget decimal
accepted_terms timestamp

comments

id increments
timestamps timestamps
creator_id ^FK integer
title string
comment text
post_id ^FK integer

league_schedules

id increments
timestamps timestamps
league_id ^FK integer
schedule_id ^FK integer

scoring_types

id increments
timestamps timestamps
type string

permissions

id increments
timestamps timestamps
key string
table_name string

permission_role

id increments
timestamps timestamps
role_id ^FK integer
premission_id ^FK integer

player_news

id increments
timestamps timestamps
player_id ^FK integer
title string
body string
posted datetime

players

id increments
timestamps timestamps
team_id ^FK integer
first_name string
last_name string
abbr_name string
birthday datetime
position string
status string
owner string
preferred_name string
weight double
height integer
birth_place string
high_school string
college string
college_conf string
rookie_year integer
draft_year integer
draft_round integer
draft_number integer
draft_team_id integer
avatar string
depth integer

stats_player

id increments
timestamps timestamps
player_id ^FK integer
season string
field string
value string

matchups

id increments
timestamps timestamps
scheduleable_id ^FK integer

games

id increments
timestamps timestamps
week integer
season string
status string
scheduled datetime
broadcast string
utc_offset integer
time_zone string

original_teams

id increments
timestamps timestamps
name string
division string
conference string
market string
alias string

stats_team

id increments
timestamps timestamps
team_id ^FK integer
field string
value double
season string

post_categories

id increments
timestamps timestamps
parent_id integer
order integer
name string
slug string

draftable_types

id increments
timestamps timestamps
name string
rule_handle_active string
rule_handle_bench string
sort_order integer

draftables

id increments
timestamps timestamps
display_name string
draftable_type_id ^FK integer
lookupKey string

friends

id increments
timestamps timestamps
user_id ^FK integer
friend_id ^FK integer

scheduleable_groups

id increments
timestamps timestamps
name string

scheduleables

id increments
timestamps timestamps
dateTime datetime
season string

matchup_teams

id increments
timestamps timestamps
team_id ^FK integer
matchup_id ^FK integer
win boolean
loss boolean
tie boolean
rank integer
points float

default_rule_categories

id increments
timestamps timestamps
name string
priority string

default_rules

id increments
timestamps timestamps
rule_category ^FK integer
lable string
type enum
help_text text
defauly_value string

league_rules

id increments
timestamps timestamps
league_id ^FK integer
defaultrule_id ^FK integer
value string

invitations

id increments
timestamps timestamps
emailAddress string
league_id ^FK integer
joined datetime
unique_id string

rosters

id increments
timestamps timestamps
team_id ^FK bigInteger
draftable_id ^FK integer
lookupKey string (100)
is_bench tinyInteger
is_starter tinyInteger
is_flex tinyInteger
order integer

matchup_rosters

id increments
timestamps timestamps
team_id ^FK integer
matchup_id ^FK integer
draftableTypeId ^FK integer
draftable_id ^FK integer
lookup_key string
position string
place integer

coaches

id increments
timestamps timestamps
team_id string
full_name string
first_name string
last_name string
position string

injuries

id increments
timestamps timestamps
season_year string
player_id ^FK integer
status string
status_date datetime
practice_status string
description string

game_team

id increments
timestamps timestamps
game_id ^FK integer
team_id ^FK integer
home_team tinyInteger

states_labels

id increments
timestamps timestamps
field string
label string

game_stats

id increments
timestamps timestamps
player_id ^FK integer
field string
value double

game_events

id increments
timestamps timestamps
game_id ^FK integer
field string
value double

game_clock

id increments
timestamps timestamps
game_id ^FK integer
field string
value double

player_points

id increments
timestamps timestamps
player_id ^FK integer
rule_hash binary
week tinyInteger
season integer
points decimal

trades

id increments
timestamps timestamps
user_id ^FK integer
is_proposed tinyInteger
is_approved tinyInteger
is_denied tinyInteger

trades_players

id increments
timestamps timestamps
trade_id ^FK integer
player_id ^FK integer
team_id ^FK integer
destination_team_id ^FK integer

trades_teams

id increments
timestamps timestamps
trade_id ^FK integer
team_id ^FK integer
is_approved tinyInteger
is_denied tinyInteger

update_players

id increments
timestamps timestamps
league_id ^FK integer
team_id ^FK integer
player_id ^FK integer
is_starter tinyInteger
is_bench integer
is_flex tinyInteger
order integer

league_divisions

id increments
timestamps timestamps
name string
league_id ^FK integer

league_divisions_team

id increments
timestamps timestamps
league_id ^FK integer
division_id ^FK integer
team_id ^FK integer