trashers - Laravel Schema Designer

profiles

id increments
nickname string
naf_number string
quote string
birthday timestamp
coach_since timestamp
timestamps timestamps
softDeletes softDeletes
location_id ^FK integer

teams

id increments
profile_id ^FK integer
timestamps timestamps
softDeletes softDeletes

players

id increments
timestamps timestamps
softDeletes softDeletes
name string
race_id ^FK integer
player_type_id ^FK integer
cost integer
max_in_team integer
movement integer
strength integer
agility integer
armor_value integer

skills

id increments
name string
description longText
timestamps timestamps
softDeletes softDeletes

players_skills

player_id ^FK integer
skill_id ^FK integer

games

id increments
date timestamp
location_id ^FK integer
timestamps timestamps
softDeletes softDeletes

messages

id increments
conversation_id ^FK integer
content longText
timestamps timestamps
softDeletes softDeletes

conversations

receiver ^FK integer
name string
message ^FK integer
timestamps timestamps
softDeletes softDeletes

blogs

id increments
blog_post_id ^FK integer
profile_id ^FK integer
start_date timestamp
end_date timestamp
can_show boolean
timestamps timestamps
softDeletes softDeletes

blog_posts

id increments
title string
released_at timestamp
sub_title string
content string
reject_id ^FK integer
visible boolean
timestamps timestamps
softDeletes softDeletes

images

id increments
file_name string
model string
timestamps timestamps
softDeletes softDeletes

tags

id increments
timestamps timestamps
softDeletes softDeletes

images_tags

tag_id ^FK integer
image_id ^FK integer

rejects

id increments
rejected_by ^FK integer
reason longText
blog_id ^FK integer
timestamps timestamps
softDeletes softDeletes

locations

id increments
name string
zip_code string
latitude double
longitude double
timestamps timestamps
softDeletes softDeletes

users

id bigIncrements
firstname string
email string
email_verified_at timestamps
password string
role integer
profile_id string
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

players_conversations

profile_id ^FK integer
conversation_id ^FK integer

teams_players

team_id ^FK integer
player_id ^FK integer

profiles_games

profile_id ^FK integer
game_id ^FK integer

teams_games

team_id ^FK integer
game_id ^FK integer

upgrades

id increments
player_id ^FK integer
timestamps timestamps
softDeletes softDeletes
upgrade_type_id integer

races

id increments
timestamps timestamps
softDeletes softDeletes
name string
team_reroll_cost integer
position integer
experimantal boolean

player_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

upgrade_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01