[DevOps] Initialize Postgres DB Schema

[RenanKummer]

As an architect, I want to apply database migration scripts to create the schemas in production database, So that the database is initialized without affecting existing configurations.

Acceptance Criteria

• The migration scripts are reviewed for accuracy and potential data loss before applying to the production database.
• The migration scripts are applied using the migration user.
• The migration scripts update the __EFMigrationsHistory table with the applied migrations.
• The application user has read/write access to the new tables and columns, but not privileges to drop or alter them.
• The changes are tested in structure and security privileges.

Assumptions

• The admin, migration and application users have already been setup with the appropriate roles and permissions.