vigrid2 - Laravel Schema Designer

identifications

id increments
login string
password string
user_id ^FK integer
timestamps timestamps

users

id increments
name string
firstname string
nickname string
email string
notifications boolean
timestamps timestamps

games

id increments
name string
public boolean
password string
active boolean
timestamps timestamps

rounds

id increments
game_id ^FK integer
world_id ^FK integer
timestamps timestamps
fighter_id ^FK integer

worlds

id increments
name string
description text
timestamps timestamps

actions

id increments
type string
pa_cost smallInteger
sp_cost smallInteger
dodge_win smallInteger
xp_win smallInteger
sp_win smallInteger
timestamps timestamps

characters

id increments
name string
pv smallInteger
str smallInteger
def smallInteger
dodge smallInteger
pa smallInteger
sp smallInteger
xp smallInteger
lvl smallInteger
world_id ^FK integer
available boolean
timestamps timestamps

levels

id increments
lvl tinyInteger
xp_cap smallInteger
pv_bonus smallInteger
str_bonus smallInteger
def_bonus smallInteger
dodge_bonus smallInteger
timestamps timestamps

fighters

id increments
name string
pv smallInteger
str smallInteger
def smallInteger
dodge smallInteger
pa smallInteger
sp smallInteger
xp smallInteger
lvl smallInteger
game_id ^FK integer
character_id ^FK integer
user_id ^FK integer
timestamps timestamps

moves

id increments
action_id ^FK integer
fighter_id ^FK integer
target_id integer
round_id ^FK integer
timestamps timestamps

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