gotquiz - Laravel Schema Designer

got_characters

id integer
name string (255)
culture string (255)
father ^FK integer
mother ^FK integer
spouse ^FK integer

got_houses

id integer
name string (255)
region string (255)
coatOfArms string (255)
words string (255)
heir ^FK integer
founder ^FK integer
currentLord ^FK integer

titles

id increments
title string (255)
character_id ^FK integer

seats

id increments
seat string (255)
house_id ^FK integer

aliases

id increments
alias string (255)
character_id ^FK integer

link_got_characters_got_houses

id increments
character_id ^FK integer
house_id ^FK integer

participations

id increments
timestamps timestamps
points integer
amountToday integer
amountTotal integer
user_id ^FK integer
contest_id ^FK integer

users

id increments
name string (255)
email string (255)
password string (255)
ipaddress ipAddress
address string (255)
town string (255)
softDeletes softDeletes
rememberToken rememberToken
timestamps timestamps
isAdmin integer

contests

id increments
timestamps timestamps
winner_id ^FK integer
start datetime
status string

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