trymydinner - Laravel Schema Designer

users

id increments
username string (255)
password string (255)
email string (255)
rememberToken rememberToken
timestamps timestamps

profile

id increments
user_id ^FK integer
firstname string (255)
lastname string (255)
birthdate date
about text
image string (255)
facebook string (254)

recipes

id increments
user_id ^FK integer
name string (255)
description text
time string (255)
difficulty integer
serves integer
timestamps timestamps
slug string (255)

addresses

id increments
user_id ^FK integer
country_id integer
street string (254)
city string (254)
zipcode string (6)
additional string (254)

countries

id increments
name string (254)
code string (5)

invitations

id increments
user_id ^FK integer
people integer
price integer
datetime timestamp
timestamps timestamps

applies

id increments
invitation_id ^FK integer
user_id ^FK integer
approved tinyInteger
timestamps timestamps

nutritions

id increments
name string (254)
amount string (254)
recipe_id ^FK integer

categories

id increments
name string (254)
slug string (254)
icon string (254)
timestamps timestamps

category_recipe

recipe_id ^FK integer
category_id ^FK integer

comments

id increments
user_id ^FK integer
text text
timestamps timestamps
invitation_id ^FK integer

ingredients

id increments
name string (254)
amount integer
type string (254)
recipe_id ^FK integer

preparations

id increments
recipe_id ^FK integer
step integer
description text
image string (254)

reviews

id increments
recipe_id ^FK integer
user_id ^FK integer
rating smallInteger
text text
timestamps timestamps

tags

id increments
name string (254)
slug string (254)
timestamps timestamps

recipe_tag

id increments
tag_id ^FK integer
recipe_id ^FK integer

recipe_images

id increments
recipe_id ^FK integer
image string (254)
title string

followers

id increments
user_id ^FK integer
follower_id ^FK integer
timestamps timestamps

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