Setting Up The Database - KSU-CS-Software-Engineering/HSPC GitHub Wiki

To set up the tables on the database, refer to the following instructions:

1. Open the terminal and type "sudo docker ps" to ensure the database container is running.
2. Right click the newly created connect and select "SQL Editor".
3. Within the "API" folder of the repo, copy the SQL code found within the "Database" folder into the dbeaver SQL editor.
4. Run the commands to create the database and the list of tables.
5. Refresh the list of databases within the connection and ensure "hspc_database" is set to actice.