DataBase - Daniela4578/PlanMe GitHub Wiki

Used MySQL Workbench

We've done our connection with the database with MySQL.Data

PlanMe ER diagram

Database relationships descriptions

• check_time stores last date, user has been loged and current phrase id for the day.
• phrase stores phrases (total of 390 phrases) and has id as a primary key.
• users stores username and password for every user and has id as a primary key.
• list_of_tasks stores name of the list and has id as a primary key. Related to table users via id column that references the user_id column in that table.
• tasks stores status (i.e., whether it is done or not) and task text for every list. Related to the list_of_tasks table via list_id column that references the id column in that table.
• events stores event's name, date, time and info. It has name, date and time as primary keys. Related to table users via id column that references the user_id column in that table.