Hi !
I am experimenting annotations
and writing a class which describe the following table:
Quote:
CREATE TABLE admissible_values
(
admissible_value_id bigserial NOT NULL,
attribute_id int8 NOT NULL,
class_id int8 NOT NULL,
start_value varchar(50) NOT NULL,
end_value varchar(50) NOT NULL,
default_value varchar(50),
status int4 NOT NULL DEFAULT 0,
CONSTRAINT admissible_pkey PRIMARY KEY (admissible_value_id),
CONSTRAINT admissible_classid_attributeid_key UNIQUE (class_id, attribute_id)
)
How can I annotate the composite UNIQUE KEY
(class_id, attribute_id) which is composed by 2 foreign key ?
Quote:
/**
* AdmissibleValues generated by hbm2java
*/
@Entity
@Table(name = "admissible_values", schema = "public")
public class AdmissibleValues implements java.io.Serializable {
// Fields
private java.lang.Long AdmissibleValueId;
private com.aaa.entity.Classes Classes;
private com.aaa.entity.Attributes Attributes;
[...cut]
@ManyToOne
@JoinColumn(name = "class_id")
public com.aaa.entity.Classes getClasses () {
return this.Classes;
}
public void setClasses (com.aaa.entity.Classes Classes) {
this.Classes = Classes;
}
@ManyToOne
@JoinColumn(name = "attribute_id")
public com.aaa.entity.Attributes getAttributes () {
return this.Attributes;
}
public void setAttributes (com.aaa.entity.Attributes Attributes) {
this.Attributes = Attributes;
}
I cannot use UNIQUE parameter into @JoinColumn
in Classes and Attributes.
How can I solve this ?
Thank in advance,
Nicola