steamsurfing_dev - Laravel Schema Designer

users

id increments
userDisplayName string (255)
userName string (255)
userLastName string (255)
userEmail string (255)
userPasswd text
userBirthDay date
userGender string (2)
userAdress string (255)
userCity string (255)
userCountry string (255)
userFacebookProfile string (255)
userGoogleProfile string (255)
userTwitterProfile string (255)
userWebsiteUrl string (255)
userBiography text
userHomeBackgroundPic string (255)
userProfilePic string (255)
userDateOfCreation datetime
userAccountValidation boolean
timestamps timestamps

events

id increments
idCreator ^FK integer
eventDateTime datetime
EventAdress text
eventCity string (100)
eventCountry string (100)
eventPermission boolean

settings

id increments
timestamps timestamps

recipes

id increments
recipeTitle string (255)
recipePic string (255)
recipeDescription text
timestamps timestamps
idIntolerence ^FK integer

intolerences

id increments
intoName string (255)
intoDescription string
intoActivation boolean

freindship

id increments
userId1 integer
userId2 integer
timestamps timestamps

messages

id increments
idSender ^FK integer
idReciever ^FK integer
msgSubject text
msgContent text
msgSentTime datetime
msgDate datetime
timestamps timestamps

roles

id increments
roleTitle string (150)
roleDescription text

user_intolerence

id increments
idIntolerence ^FK integer
idUser ^FK integer
timestamps timestamps

user_role

id increments
idUser ^FK integer
idRole ^FK integer
timestamps timestamps

event_members

id increments
idEvent ^FK integer
idMember ^FK integer
timestamps timestamps
eventParticipationDate datetime

event_recipes

id increments
timestamps timestamps
idEvent ^FK integer
idRecipe ^FK integer

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