Project

General

Profile

Actions
Copy link

Story #3758

open

Epic #3756: EPIC: Multi-Tenant Architecture (Hotel as Tenant)

As a developer, I want all key models (Device, Promotion, MediaAsset, WidgetConfig, AnalyticsEvent) to carry a ForeignKey to Hotel so that all data is tenant-scoped

Added by Suraj Risal 10 days ago. Updated 3 days ago.

Status:
QA
Priority:
High
Assignee:
Ajay Maharjan
Start date:
03/27/2026
Due date:
% Done:

0%

Estimated time:
0:00 h
Type:
Planned
Actions
Copy link
 #1

Updated by Suraj Risal 10 days ago

  • Assignee set to Ajay Maharjan
Actions
Copy link
 #2

Updated by Ajay Maharjan 3 days ago

  • Status changed from To Do to In Progress
Actions
Copy link
 #3

Updated by Ajay Maharjan 3 days ago

Model │ Tenant column │
├──────────────────┼─────────────────────────────────────────────┤
│ Template │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ Slide │ slide → template → tenant (2 hops) │
├──────────────────┼─────────────────────────────────────────────┤
│ Playlist │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ PlaylistItem │ playlist → tenant (1 hop) │
├──────────────────┼─────────────────────────────────────────────┤
│ Schedule │ playlist → tenant (1 hop) │
├──────────────────┼─────────────────────────────────────────────┤
│ DeviceGroup │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ Device │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ DeviceHeartbeat │ device → tenant (1 hop) │
├──────────────────┼─────────────────────────────────────────────┤
│ MediaAsset │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ WidgetSettings │ tenant (OneToOne) │
├──────────────────┼─────────────────────────────────────────────┤
│ ForexCache │ tenant (OneToOne) │
├──────────────────┼─────────────────────────────────────────────┤
│ PlayEvent │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ AppEvent │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ ShortUrl │ tenant (direct FK) │
├──────────────────┼─────────────────────────────────────────────┤
│ UrlClick │ short_url → tenant (1 hop) │
├──────────────────┼─────────────────────────────────────────────┤
│ TenantMembership │ tenant (direct FK) — links users to tenants │

Actions
Copy link
 #4

Updated by Ajay Maharjan 3 days ago

  • Status changed from In Progress to QA
Actions
Copy link

Also available in: Atom PDF