[BE-38] Multi-location support: backend data model

[yusuftomilola]

Overview

ManageHub supports only a single physical location. Hub operators running multiple sites (e.g. two Lagos branches, one Abuja branch) cannot manage all locations under one account. Multi-location support is a critical feature for growing hub operators.

Context

• Workspace entity: backend/src/workspaces/entities/workspace.entity.ts
• WorkspaceLog entity: backend/src/workspace-tracking/entities/workspace-log.entity.ts
• Booking entity: backend/src/bookings/entities/booking.entity.ts
• This is a schema-level change — requires a TypeORM migration, not just synchronize: true

Tasks

• Create Location entity: id, name, address, city, country (default "Nigeria"), timezone (IANA timezone string, e.g. "Africa/Lagos"), isActive (bool), createdAt, updatedAt
• Add nullable locationId FK to Workspace entity; existing workspaces get a default location seeded in migration
• POST /locations — create location (super_admin only)
• GET /locations — list all active locations (all authenticated users)
• PATCH /locations/:id — update location details (super_admin only)
• GET /workspaces — support ?locationId= filter to scope results to a location
• Admin analytics endpoints support ?locationId= filter for cross-location reporting
• Generate TypeORM migration: npm run migration:generate -- src/migrations/AddLocationEntity

Files to Modify / Create

• New: backend/src/locations/ (module, entity, controller, service)
• backend/src/workspaces/entities/workspace.entity.ts
• backend/src/workspaces/workspaces.controller.ts
• New: backend/src/migrations/AddLocationEntity.ts
• backend/src/app.module.ts

[sudo-robi]

@sudo-robi has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer I'm a full stack developer and smart contract developer let me help you resolve this issue and I assure you it will be thoroughly done neatly as I have seen my way around the issue.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @sudo-robi to this issue.

[madisonsc52-del]

@madisonsc52-del has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer i can work on this, I'll make sure to work on the issue asap

ℹ️ Repo Maintainers: To accept this application, review their application or assign @madisonsc52-del to this issue.

[lynaDev2]

@lynaDev2 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

can i work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @lynaDev2 to this issue.

[sudo-robi]

Hi @yusuftomilola you haven't assigned me

[grantfox-oss]

🦊 GrantFox — @lynaDev2 has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #1223)
2. Your PR will be reviewed by the DistinctCodes maintainers

Good luck! Track your progress on GrantFox.

[drips-wave]

Congratulations, @lynaDev2! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @lynaDev2: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox!

@lynaDev2's PR #1321 was approved and merged by @yusuftomilola.

🏆 @lynaDev2: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (541 total points). Track your full progress on GrantFox.

👏 Great work, @lynaDev2! Keep contributing to DistinctCodes.