Yes multiple types generate option conflicts, like defining a unique or not-unique index on the same columns.
Multiple indexes with different names having the same options do not generate option conflicts. So can be tolerate.
@UniqueConstraint(columnNames = "email") and @Index(columnList = "email", unique=true)` do not generate option conflicts, because they generate indexes with the same options.