createIndex
Uniqueness might be required for foreign key constraints.
In PostgreSQL (https://www.postgresql.org/docs/current/indexes-unique.html), UNIQUE means B-tree only. Unique constraints can not be partial Unique indexes can be partial