Database

This document describes the database configuration.

There are two available database mangement systems (DBMS).

1. PostgreSQL

   1. This can be used for both local and azure deployment.

   2. For local deployment, create a database called 'protocol_deviations.db'.

   3. Use the schema files in the db/postgres/schema to set up the entities and their relation.

   4. Then add the seed data.

   5. If you want to configure your database url, you must ensure it matches the appropriate properties files.

      1. application-postgres.properties

      2. application-postgres-azure.properties

   6. Ensure the correct credentials are in the relevant properties file.

2. SQLite

   1. No additional setup is required as SQLite uses a local file-based database.

   2. Ensure `application-sqlite.properties` points to the correct SQLite database file.