By default, NULL values are treated as distinct entries. Specifying NULLS NOT DISTINCT on unique indexes / constraints will cause NULL to be treated as not distinct, or in other words, equivalently.
NULL
NULLS NOT DISTINCT