As a workaround, I removed the primary key creation from the @ElementCollection audit table DDL, which only is possible because we store the DDL scripts redundantly to be used by e.g. Flyway to migrate manually instead of letting Hibernate generate the database structure from scratch.

Do you see any unaddressed problem in this process?