[db] Create ERD diagram - Githubissues

dae-ne / zpi-project

https://dietly.vercel.app/

MIT License

0 stars 0 forks source link

[db] Create ERD diagram #17

Open dae-ne opened 11 months ago

dae-ne commented 11 months ago

Just suggestions, there may be small changes in the future.

users

id (pk)
nickname
email
password

recipes

id (pk)
id_difficulty_levels (fk)
id_users (fk)
name
description
image_url
time
energy

difficutly_levels

id (pk)
name

ingredients

id (pk)
id_users (fk)
name

directions

id (pk)
id_recipes (fk)
description
step_number

tags

id (pk)
id_users (pk)
text

recipes_ingredients

id_recipes (fk)
id_ingredients (fk)

recipes_tags

id_recipes (fk)
id_tags (fk)

meals

id (pk)
id_recipes (fk)
date_time
eaten (informacja, czy już jest zjedzony ten posiłek)