Unique constraints work as long as the partition key is included in the constraint (which makes sense, so a table knows it’s the only partition for a value and checks it’s unique index).