Skip to main content

Database Design

The application has two databases:

  1. The main database, MySQL, which is the source of truth for all data in the application.
  2. The indexDB, which is a subset of the main database that allows the application to work offline.

MySQL: The fasp-api project uses a MySQL database. This database is stored on the server.

IndexDB: The fasp-ui project uses an IndexedDB database, which is a subset of the main database, and is saved on each user's computer.

All masters data is loaded by default (restricted by access rights), and users select specific program-versions to load.

See an overview of the QAT Data Model from 2020 in this PowerPoint presentation.

Entity-Relationship Diagrams (ERDs)​

Entity-Relationship Diagrams (ERDs) for the QAT Application DB: