I am new to Hibernate and I am trying to figure out how to create a mapping file based on the following:

Table A
id (primary key)
name
date

Table B
id(foreign key)
user_id (foreign key)
school_id (foreign key)

Basically, Table B primary key is a combination of all the foreign keys. And, it is used to figure out which item from Table A to view. Can someone please give me an example of how to map this file in a hibernate mapping file. Would I use a join or what?

Thanks

tablea.hbm.xml

<class name="tableA" table="TABLEA">
<id name="id" column="ID" >
<generator class="assigned"/>
</id>
<property name="name" column="NAME"/>
<property name="date" type="timestamp" column="DATE"/>
<set name="ID" lazy="false" inverse="false" >
<key column="ID" />
<one-to-many class="tableB" />
</set>
</class>

tableb.hbm.xml

<class name="tableB" table="TABLEB">
<composite-id >
<key-property name="id" column="ID" > </key-property>
<key-property name="user_id" column="USER_ID"></key-property>
<key-property name="school_id" column="SCHOOL_ID"></key-property>
</composite-id>
<property name="id" column="ID" insert="false" update="false" />
<property name="user_id" column="USER_ID" insert="false" update="false" />
<property name="school_id" column="SCHOOL_ID" insert="false" update="false" />
</class>

also, make the mappings for foriegn keys user_id and school_id in thier respective hbm.xml files.

I hope it helps !