As I discussed that I will list down the functionalities of the application in my previous blog. You can visit that from here.

There will be so many functionalities for this app that's why I have decided to break this application into two parts first is for single users and the second is for groups.

In this blog, we will discuss the single user

Functionalities

1. User can register

2. Users can log in

3. TODO crud

4. TODO analytics

So above are the basic and upper-level functionalities.

For what kind of fields are required for the database let's discuss about each

For user registration

1. Username

2. Email

3. Password

For User Log In

1. Email

2. Password

For TODO

1. Task

2. IsCompleted

3. Deadline

For TODO analytics

For this, we need all users to do history so that we can show users how many they have completed, how many missed, how many are completed by them but late, etc...

Now it's time to create DB for above

From the above diagram, it is clear that one user has many TODOs.

So this is it for this blog from the next blog onwards we will start to implement APIs for the single-user module.