Foreign key has obvious disadvantages, and the only one advantage is Referential Integrity, which is a bit unworthy for ORM. hibernate should provide a configurable option in AvailableSettings to skip foreign key creation for ConstraintMode.PROVIDER_DEFAULT.
https://stackoverflow.com/questions/56693633/how-to-set-default-constraintmode-in-jpa-hibernate
It would be nice if backport to 5.4.
Backported to 5.4 branch.