table1: insurance_companies
-------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.aedsys.insurance.model.InsuranceCompaniesImpl" table="insurance_companies" lazy="true">
<id name="ins_co_id" column="ins_co_id">
<generator class="increment" />
</id>
<property name="ins_co_name" column="ins_co_name" />
<property name="ins_co_symbol" column="ins_co_symbol" />
<set name="company_terrifs" table="insurance_companies_terrifs" cascade="all" lazy="true">
<key column="ins_co_id" />
<many-to-many class="com.aedsys.insurance.model.InsuranceCompTerrifsImpl" unique="true" />
</set>
</class>
</hibernate-mapping>
-----------------------------------
table-2 insurance_companies_terrifs
------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.aedsys.insurance.model.InsuranceCompTerrifsImpl" table="insurance_companies_terrifs" lazy="true">
<composite-id name="insuranceCompTerrifsPK" class="com.aedsys.insurance.model.InsuranceCompTerrifsPK">
<key-property name="ins_co_id" column="ins_co_id" />
<key-property name="vechicle_type_id" column="vechicle_type_id" />
</composite-id>
<property name="nill_rate" column="nill_rate" />
<property name="self_declaration" column="self_declaration" />
<property name="one_year" column="one_year" />
<property name="two_year" column="two_year" />
<property name="three_year" column="three_year" />
<property name="five_plus" column="five_plus" />
<property name="age" column="age" />
<property name="nationality_uae" column="nationality_uae" />
<property name="nationality_others" column="nationality_others" />
<property name="uae_dl_convertible" column="uae_dl_convertible" />
<property name="uae_dl_nonconvertible" column="uae_dl_nonconvertible" />
<property name="comp_nationality" column="comp_nationality" />
<property name="comp_dl" column="comp_dl" />
<property name="comp_named_driver" column="comp_named_driver" />
<property name="excess_less_50k" column="excess_less_50k" />
<property name="excess_less_200k" column="excess_less_200k" />
<property name="excess_less_50k" column="excess_less_50k" />
<property name="excess_less_350k" column="excess_less_350k" />
<property name="off_roadcover" column="off_roadcover" />
</class>
</hibernate-mapping>
in table2 there is a vehicle_type_id which is foregin key from another table which is vehicle_type so the composite id for the table2 is foreign key from table vehicle_type and from insurance_companies i-e (insurance_co_id,vehicle_type_id)
thanks for your help
Login
FAQ
Search
