Database Schema Migration for Hub-wise Compatibility

[prnv404]

Objective

Migrate our existing database schema to ensure compatibility with Hub-wise.
Background

Hub-wise integration requires specific adaptations to our current database schema. This issue is created to track the tasks and progress related to this migration.

Tasks

1. Analysis of Current Schema
   Conduct a thorough analysis of our current database schema.
   Identify components that need modification for Hub-wise compatibility.

2. Schema Remodeling
   Modify the schema to align with Hub-wise requirements.
   Ensure data integrity is maintained during the migration

3. Testing and Quality Assurance
   Conduct comprehensive testing of the new schema with Hub-wise integration.
   and make sure its not breaking the old version