Database Creation and Expansion

The data in the Cognitivity system is stored in a MySQL database, hosted by an Azure server.

Cognitivity defines tables in that server for storing all the information saved for each data type.

The database definition setting is in the database/database.sql file of the backend code section.

---

In order to create the database

You should copy and paste the content of the database settings file to a mysql console, either in the a docker or not.

---

In order to expand the database

You should add the fields to the existing tables, or create new tables with new fields for a new data type you want to maintain.

Remember to reinitialize the database with the new database settings file content.