mebooze - Laravel Schema Designer

users

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

contests

id increments
timestamps timestamps
startDate datetime
endDate datetime

participations

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

spotify

id increments
timestamps timestamps

artists

id increments
timestamps timestamps
name string (255)
spotify_id ^FK integer

tracks

id increments
timestamps timestamps
name string (255)
artist_id ^FK integer

contests_users

id increments
timestamps timestamps
contest_id ^FK integer
user_id ^FK integer

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