idolpx / csdb-ng

Project to rebuild CSDb from scratch.
MIT License
3 stars 0 forks source link

"scener/handle" and "person" must be seperate things #5

Open mrdudz opened 2 years ago

mrdudz commented 2 years ago

in csdb "scener" is a person, and a scener can have a handle (or more than one).

the fundamental problem with this is, that there are cases where a handle was used by more than one person and appeared as one "scener" (but not as a group of sceners). famous example was "the ministry", which was two people, who joined groups under the single handle "the ministry". the same two people also had their individual handles (Jayce and Marcus). see https://csdb.dk/scener/?id=7956

so it must be possible to:

idolpx commented 2 years ago

Can you have a scener without a handle or a handle without a scener? This needs more clarification. The term "scener" seems to represent a single individual aka "person".

"The Ministry" (handle) "Jayce" (handle) "Marcus" (handle)

scener-a = "Jayce" = "The Ministry"

scener-b = "Marcus" = "The Minitry"

So a scener should be able to have more than one actively used handle at a time?

mrdudz commented 2 years ago

a scener (person) can have one or more handle at a time. this is not what this is about (and csdb can handle this fine already)

this is about the situation when a single handle is used by different sceners and those appear as a single entity in a group or in releases.

idolpx commented 2 years ago

How do you envision it being represented?

idolpx commented 2 years ago

On the "handle" page it could show the list of sceners using that handle if it is more than one. Would that work?

mrdudz commented 2 years ago

On the "handle" page it could show the list of sceners using that handle if it is more than one. Would that work?

no idea. i am only thinking in terms of the db structure. what the frontend does with it is irrelevant for the time being :)

in the frontend, it would show very similar to how a group is shown, i guess

idolpx commented 2 years ago

I added "SenerIDs" & "Sceners" arrays to the "Handle" type in the scheme to handle this.