LocationTag name uniqueness

Was it intentional to allow duplicate location tag names?

No, it was not intentional.

I will create a ticket to add the constraint in the DB and update the validator. I have also realized that on the add/edit attribute type forms, the datatype field is required but there is no not-null constraint on the associated columns in the DB, i guess that it just went through the cracks and needs to be fixed too, right?