Fix the foreign key and enum issues that occur when switched to postgresql database

[firepenguindisopanda]

As a database administrator or software engineer I need to fix foreign key and enum issues that arise when switching to a PostgreSQL database So that the data can be stored without error

Acceptance Criteria

Given a database migration from another system (e.g., MySQL) to PostgreSQL
When the migration is performed
Then the foreign key constraints are correctly applied in PostgreSQL
And the enum types are correctly defined and utilized without causing application errors

[uni-paul-taylor2]

is the postgres db cleared from the start?

[firepenguindisopanda]

is the postgres db cleared from the start?

When the application is started it is cleared depending on the .env variable

It's refreshed when using npm run dev

[firepenguindisopanda]

Fixed issue

Git commit with fixes