[Persistence] Organization / Unit / Context / etc. Names Should Be Unique

[wwerner]

Currently creating organizations, units and contexts with the resp. same name is possible.
This can lead to them not being distinguishable from the UI. We could either also show the resp. IDs (but Users having to compare UUIDs is probably not the UX we're aiming for) or constrain the names to have to be unique.

Currently, this is possible:

[VaughnVernon]

They should be unique. I think there are issues with unique constraints on HSQLDB and I may have relaxed those initially for the sake of progress. HSQLDB is not the production database, it is only for development. I think this needs to remain as an issue to ensure it is addressed, but for now let's not be concerned about it for the sake of progress.

[Florian-Schoenherr]

This is mitigated by the new details-toggle.


If so desired, we could warn before someone creates with a non-unique name (because id's still look pretty ugly).

[VaughnVernon]

@Florian-Schoenherr We will address this in a later version. We will be creating a separate backlog so leave this open and remember it for later inclusion.

[Florian-Schoenherr]

Another id I had was to ditch ids completely and have the names be unique. That way people would use:
GET /organizations/org/units/unit/contexts/context/schemas/schema/1.0.0.
But that would require more changes. Let's keep this open, yes.