A thousand thanks to @Dai from here as well!
UNIQUE INDEX/UNIQUE CONSTRAINTobjects ensure uniqueness, not types.
So, the only distinguishing feature of a "UUID" column compared to a regular string column is that it is of the UNIQUE property, and that's it. I overthought it.