02 - Database Design

To start building the different parts of the application we shall first start working on database design, where all the data is stored related to the application. As mentioned earlier we shall be using PostgreSQL to store our data.
Following is the initial design of the application which will get modified over a period of time as the application evolves.

image.png

We shall be hosting the database on a local docker container till we start the DevOps work, where we shall be hosting the database on amazon rds.

Following is the link to database to set up the tables: DBSchema