Página do Banco de Dados

Olive DB

1. Conceptual schema:

Users - have a 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