That's right! UNIQUE constraint requires a value for a field, but this value cannot be duplicated anywhere in that column.
UNIQUE
Nope – that's not a constraint!