LNRCompetition - Laravel Schema Designer

users

id increments
name string
lastname string
email string
timestamps timestamps

competitions

id increments
name string
description text
timestamps timestamps

categories

id increments
name string
description text
rules string
timestamps timestamps

categoryCompetition

id increments
competition_id ^FK integer
category_id ^FK integer
isEnabled boolean

homologations

id increments
competition_id ^FK integer
category_id ^FK integer
result string
robot_id ^FK integer
timestamps timestamps

robots

id increments
team_id ^FK integer
name string
picture string
timestamps timestamps

teams

id increments
name string
description text
location string
responsable_id ^FK integer
captain_id ^FK integer
timestamps timestamps

members

id increments
user_id ^FK integer
team_id ^FK integer
picture string
birthdate date
description text
isPublic boolean
timestamps timestamps

competitionRobot

id increments
competition_id ^FK integer
robot_id ^FK integer
timestamps timestamps

categoryRobot

id increments
category_id ^FK integer
robot_id ^FK integer

battle

id increments
timestamps timestamps
id_robot_1 ^FK integer
id_robot_2 ^FK integer
puntaje integer
ganador ^FK integer
categoria_id ^FK integer
ronda longText

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