Unique Constraint Over Multiple Columns Unique Constraint Over Multiple Columns postgresql postgresql

Unique Constraint Over Multiple Columns


There is no Hibernate annotation that checks uniqueness before insert/update. But there is annotation which will generate such a constraint to database if automatic database creation is used:

 @Table(    name="ACTIVE_BAND",     uniqueConstraints=        @UniqueConstraint(columnNames={"active_band_user", "active_band_date"}))


In a more modern syntax, it would be :

@Table(    name="ACTIVE_BAND",     uniqueConstraints =        [UniqueConstraint(                columnNames = ["active_band_user", "active_band_date"]        )])