[Apache JDO Wiki] New: EmployeeInsuranceMapping

[jd...@db.apache.org]

   Date: 2005-02-14T15:24:18
   Editor: MichelleCaisse
   Wiki: Apache JDO Wiki
   Page: EmployeeInsuranceMapping
   URL: http://wiki.apache.org/jdo/EmployeeInsuranceMapping

   no comment

New Page:

This is the proposed mapping for the employee/insurance bidirectional relationship.  Key features of this mapping are:
 *The insurance table contains a foreign key to the persons table.
 *The MedicalInsurance and DentalInsurance reference fields of Employee are mapped-by the employee field of Insurance.

{{{
<class name="PartTimeEmployee">
    <inheritance strategy="superclass-table"/>
    <field name="wage" column="wage"/>
</class>

<class name="FullTimeEmployee">
    <inheritance strategy="superclass-table"/>
    <field name="salary" column="salary"/>
</class>

<class name="Employee">
    <inheritance strategy="superclass-table"/>
    <field name="hiredate" column="hiredate"/>
    <field name="weeklyhours" column="weeklyhours"/>
    <field name="dentalInsurance" mapped-by="employee"/>
    <field name="medicalInsurance" mapped-by="employee"/>
    <field name="department" column="department">
                <foreign-key/>
    </field>
    <field name="fundingDept" column="fundingdept">
                <foreign-key/>
    </field>
    <field name="manager" column="manager">
                <foreign-key/>
    </field>
    <field name="mentor" column="mentor">
                <foreign-key/>
    </field>
    <field name="protege" column="protege">
                <foreign-key/>
    </field>
    <field name="hradvisor" column="hradvisor">
                <foreign-key/>
    </field>
    <field name="reviewedProjects" mapped-by="reviewers"/>
    <field name="projects" mapped-by="members"/>
    <field name="team" mapped-by="manager"/>
    <field name="hradvisees" mapped-by="hradvisor"/>
</class>
        
<class name="Person" table="persons">
    <inheritance strategy="new-table">
        <discriminator strategy="class-name" column="discriminator"/>
    </inheritance>
    <field name="personid" column="personid"/>
    <field name="firstname" column="firstname"/>
    <field name="lastname" column="lastname"/>
    <field name="middlename column="middlename"/>
    <field name="address">
        <embedded>
            <field name="street" column="street"/>
            <field name="city" column="city"/>
            <field name="state" column="state"/>
            <field name="zipcode" column="zipcode"/>
            <field name="country" column="country"/>
        </embedded>
    </field>
    <field name="phoneNumbers" table="employee_phoneno_type" >
        <join column="personid"/>
        <key column="type"/>
        <value column="phoneno"/>
    </field>
</class>

<class name="Insurance" table="insuranceplans">
    <inheritance strategy="new-table">
        <discriminator strategy="class-name" column="discriminator"/>
    <inheritance/>
    <field name="insid" column="insid"/>
    <field name="carrier" column="carrier"/>
    <field name="employee" column="empid">
         <foreign-key/>
    </field
</class>

<class name="DentalInsurance">
    <inheritance strategy="superclass-table"/>
    <field name="lifetimeOrthoBenefit" column="lifetimeOrthoBenefit"/>
</class>

<class name="MedicalInsurance">
    <inheritance strategy="superclass-table"/>
    <field name="planType" column="planType"/>
</class>
}}}