[Infrastructure] prepare Postgres DB as a unified DB for all components

We need to set up a centralized PostgreSQL database to serve as a unified data store for all components. This will help streamline data access, reduce duplication, and simplify infrastructure management.

Each module must implement its own setup process for defining the required schema, creating tables, and loading initial data into the unified Postgres DB.

/cc @emiedesiti