Página do Banco de Dados

Olive DB

1. Conceptual schema:

Users - have an email as a primary key to login, profile image, level points, role, name, favorite tags and favorite recipes.

Recipes – have a title, description, level difficult, user_id from user has made, status (‘P’ = pendent; ‘R’ = reproved; ’A’ = approved), numbers of likes in recipes, time of preparation, **steps **with title and description, **images **with a link and index saving the position in recipe, **tags **containing a title.

2. Logic schema

Decisions: We have decided to use two types of database Firebase noSQL for user and Postgrees SQL for recipes, because is faster to load the user information in profile with noSQL and recipes have more information to storage.

Schema:

Aqui deve ser explicado com modelos e explicações como o Banco de Dados foi construido, onde se deve focar em:

• Como ele foi desenvolvido, com Imagens e Diagramas
• o Collections(Entities)
• o ScriptSQL