mealplanner - Laravel Schema Designer

recipes

id increments
id_hash string (40)
timestamps timestamps
softDeletes softDeletes
title string (256)
description text
servings integer
cooking_time integer
difficulty integer
prep_notes text
instructions text

recipe_ingredients

recipe_id integer
ingredients_id integer
amount integer
unit_measurement_id integer

ingredients

id increments
items_id integer
title string (64)
density decimal (8,4)

dressings

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
items_id integer

recipe_dressings

recipe_id integer
dressings_id integer

meats

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
items_id integer

recipe_meats

recipe_id integer
meats_id integer

sides

id increments
timestamps timestamps
softDeletes softDeletes
title string (256)
items_id integer

recipe_sides

recipe_id integer
sides_id integer

products

id increments
id_hash string (40)
companies_id integer
timestamps timestamps
softDeletes softDeletes
name string (256)
package_unit_id integer
package_weight integer
price decimal (5,2)
price_unit_id integer
price_unit_cost integer
description string (1024)
wholesalers_stockcode string (16)
is_on_special boolean
is_in_stock boolean
item_count integer
price_was decimal (5,2)
price_savings decimal (5,2)

unit_measurements

id increments
name string (32)
symbol string (10)
symbol_read string (10)
worth decimal (8,4)
regex string (100)
relative_to_id integer

items

id increments
title string (256)
keep_unit_id integer
keep_time_max integer
keep_amount_min integer

products_items

product_id integer
items_id integer

companies

id increments
timestamps timestamps
softDeletes softDeletes
title string (128)

meal_planner

id increments
timestamps timestamps
softDeletes softDeletes
date date
recipe_id integer
user_id integer

users

id increments
timestamps timestamps
softDeletes softDeletes
given_name string (32)
last_name string (32)
google_id string
email string (128)
username string (32)

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