Database

This document describes the database configuration and setup.

The schemas are near identical for both SQLite and PostgreSQL configurations. The only exception is that PostgreSQL uses an enumeration type for user roles. You can find the database schema here. An image of the schema is also attached below.

SQLite

For local deployment, the database comes with the jar file. The database has seeded data to allow the user to use the application. It creates a local user who is part of the 'all data' team. This allows them to visualise and manage all uploaded data. There are no admin controls for this configuration as the intended purpose is for a single user.

PostgreSQL

For remote deployment, a database called "qadata'' must be created on port 5432, where you can add the schema files. They can be found within the db folder in the repository.

To configure