Data model: Add optional relation between user and host

Parent: [EPIC] Host and User Profile Managment (aura#41 - closed)

In many existing radio environments technically a user equals a host. That means every host, also has a user account, they can login with.

In Steering, hosts and users have no relation with each other. Which allows great additional flexibility. But this has also downsides, like when a users wants to find and edit their host profile.

To keep supporting the traditional concept and keep maintenance low, we also need an optional 1:1 relation between user and host. This allows users to:

• edit their host profile in their personal Dashboard menu (as part of their user profile view)
• keep existing datasets consistent and relatable (e.g. migrations where each and every host is a user at the same time)
• visualize which hosts are real users (e.g. in list of hosts)
• only edit host profiles of their show, when they don't have an actual user account

changed milestone to %1.0-alpha3 — Playful Platypus

added P2 discuss labels

assigned to @eigenwijsje

This is this basis for providing an option to manage the host profile information from the user profile section, scheduled for alpha-4.

This data model addition is scheduled for alpha-3, being able to add it to the o94 migration already.

marked this issue as related to dashboard#86 (closed)

marked this issue as related to aura#41 (closed)

marked this issue as related to aura#206 (closed)

marked this issue as related to dashboard#180 (closed)

added P1 label and removed P2 label

added To Do label

mentioned in issue aura#206 (closed)

removed To Do label

Team 2023-07-13:

There could be some benefit to use a n:1 relation, because of this scenario documented in aura#206 (closed):

In anderen Fällen tritt ein Redaktionsteam unter einem Gemeinsamen Namen auf (z.B. "Musikredaktion").

@eigenwijsje suggested to review if it makes sense. It's open where the relationship should be set/read - on user or host site. ORM is easy, API gets bit more complex.

added To Do label

added 1 deleted label

I propose to add owners to the host model, similarly to the way the Show and the users are linked.

See: https://gitlab.servus.at/aura/aura/-/wikis/Anforderungen-und-Spezifikationen/AEP05-Erweiterung-Datenmodell#letzte-erweiterungen

A quick thought: Typically we need to query the hosts from the user site. So when a users logs in and chooses to change the host and profile details, there should be a reference to that:

But there could also be the need to query to user of a host, for example for this use case: UX: Simplify concept of assigning Show Hosts an... (dashboard#180 - closed)

---

Please do not edit finalized specs anymore, as discussed in the last Team Meeting. AEP05 got shipped with alpha-2 and should not change it's Done state anymore. Please compare the Roadmap for reference. It also complicates the discussion on specific cases. Why not describing the changes here in the ticket?

I'm gonna remove any additions from AEP05 now. Here's your addition:

Host

• Das Feld owners (many-to-many auf User) wird hinzugefügt.

changed title from Data model: Add optional 1:1 relation between user profile and host to Data model: Add optional relation between user and host

mentioned in issue dashboard#180 (closed)

added Blocked label and removed To Do label

removed discuss label

added 1 deleted label

added Doing label and removed Blocked label

added Blocked label and removed Doing label

The Host model now has an owners field and the serializer an ownerIds field.

added 1 deleted label and removed Blocked label

The implementation in steering is done in the develop branch and there is UX: Simplify concept of assigning Show Hosts an... (dashboard#180 - closed), therefore I'm closing this issue.

closed

removed 1 deleted label

changed the description

mentioned in issue aura#41 (closed)