The migration guide https://github.com/hibernate/hibernate-orm/blob/6.2/migration-guide.adoc#logical-1-1-unique tells people to use @ForeignKey(NO_CONSTRAINT) to disable the unique constraint generation which is wrong.

Dig into the code and figure out if there is a way to disable uniqueness. Either way, update the migration guide accordingly.