I have a Catagory table, with composite primary key and foreign key. My table structure is like
CREATE TABLE CATAGORY (
CATAGORY_ID int(11) NOT NULL,
CATAGORY_NAME varchar(50) DEFAULT NULL,
VERSION int(11) NOT NULL,
PARENT_ID int(11) DEFAULT NULL,
PRIMARY KEY (CATAGORY_ID,VERSION)
);
ALTER TABLE CATAGORY ADD CONSTRAINT FOREIGN KEY (PARENT_ID, VERSION) REFERENCES CATAGORY (CATAGORY_ID, VERSION);
and I want a ORM mapping with Catagory class like this
public class Catagory {
@EmbeddedId
private CatagoryPk pk ;
@Column(name="CATAGORY_NAME")
private String catagoryName;
private Catagory parentId;
private List<Catagory> childs ;
}
@Embeddable
public class CatagoryPk {
@Column(name="VERSION")
private Integer version;
@Column(name="CATEGORY_ID")
private Integer catagoryId;
}
Now how to annotate
private Catagory parentId;
private List<Catagory> childs ;
Aucun commentaire:
Enregistrer un commentaire