SRI Storage Component - Database Preparation Tasks

[Ybittan]

Overview

It has been determined that the SRI will need a database. Postgres is the current system of choice. This issue will outline the initial tasks necessary to spin up a DB.

Reference

• SRI Storage

Acceptance

• Should have a list of items to be stored in the DB
• Should have a 3NF relational diagram

Tasks

• [ ] Gather a list of items that could be stored in the DB
• [ ] Construct relational diagram
• [ ] Normalization through to 3NF

[ognjenkurtic]

Please research tools to enable easy migrations of the db as we introduce new functionalities and models.

[Ybittan]

What data must be stored document

[Ybittan]

Updated based on suggestions from a comment, reference below:

"I do not think you should and could map all the necessary data at this point.For the purpose of issue https://github.com/eea-oasis/baseline/issues/482, i think it is enough to map the general requirements from the storage layer (as you already did bellow), and then decide on the storage tech itself as well as the client to be used to communicate with it. As part of https://github.com/eea-oasis/baseline/issues/483, you can then implement the client with these basic functionalities setup (i.e. migrations, CRUD patterns...) and every dev will implement the necessary migrations for the scope of the issue he\she is working on." -Ogjnen