RecipeDB: database design
Yesterday I wrote the database schema for the recipe app I’m working on. The files only come inserting recipes; I will add more files as I progress into other parts of the project.
Tables:
- Recipe
- Category
- Nutritional_Info
- Ingredient
- Directions
- Comments
category:
id
category_name
created_by
created_at
updated_by
updated_at
is_active
recipe:
id
recipe_name
blurb
category_id
number_of_servings
prep_time
cook_time
created_by
created_at
updated_by
updated_at
is_active
nutritional_info:
id
recipe_id
info_name
measure
unit
created_by
created_at
updated_by
updated_at
is_active
ingredient:
id
recipe_id
ingredient_name
adjective
measure
unit
created_by
created_at
updated_by
updated_at
is_active
directions:
id
recipe_id
step
direction
created_by
created_at
updated_by
updated_at
is_active
comments:
id
recipe_id
rating
comment
created_by
created_at
updated_by
updated_at
is_active
I also downloaded the symfony plugin sfGuard to deal with user management. It automatically builds the db tables and in about 15 minutes, I had a login form working with a defaul user name. Makes jumping into development a lot easier.
The Courtney said she would be willing to help me with some colour palette and page design, etc. That’s quite a way down the road though.
Next step will be some basic functionality.
Add A Comment