<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE orion-ejb-jar PUBLIC "-//Evermind//DTD Enterprise JavaBeans 1.1 runtime//EN" "http://xmlns.oracle.com/ias/dtds/orion-ejb-jar.dtd">

<orion-ejb-jar>
    <enterprise-beans>
        <entity-deployment name="Area" table="AREA">
            <primkey-mapping>
                <cmp-field-mapping name="areaID" persistence-name="areaID"/>
            </primkey-mapping>
            <cmp-field-mapping name="areaDesc" persistence-name="areaDesc"/>
            <cmp-field-mapping name="topics">
                <collection-mapping table="TOPIC">
                    <primkey-mapping>
                        <cmp-field-mapping name="area">
                            <entity-ref home="Area">
                                <cmp-field-mapping name="area" persistence-name="area"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </primkey-mapping>
                    <value-mapping type="faqapp.TopicLocal">
                        <cmp-field-mapping name="topicID">
                            <entity-ref home="Topic">
                                <cmp-field-mapping name="topicID" persistence-name="topicID"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </value-mapping>
                </collection-mapping>
            </cmp-field-mapping>
            <cmp-field-mapping name="faqs">
                <collection-mapping table="FAQ_AREA">
                    <primkey-mapping>
                        <cmp-field-mapping name="Area_areaID">
                            <entity-ref home="Area">
                                <cmp-field-mapping name="Area_areaID" persistence-name="area"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </primkey-mapping>
                    <value-mapping type="faqapp.FAQLocal">
                        <cmp-field-mapping name="FAQ_questionID">
                            <entity-ref home="FAQ">
                                <cmp-field-mapping name="FAQ_questionID" persistence-name="question"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </value-mapping>
                </collection-mapping>
            </cmp-field-mapping>
        </entity-deployment>
        <entity-deployment name="Topic" table="TOPIC">
            <primkey-mapping>
                <cmp-field-mapping name="topicID" persistence-name="topicID"/>
            </primkey-mapping>
            <cmp-field-mapping name="topicDesc" persistence-name="topicDesc"/>
            <cmp-field-mapping name="area">
                <entity-ref home="Area">
                    <cmp-field-mapping name="area" persistence-name="area"/>
                </entity-ref>
            </cmp-field-mapping>
            <cmp-field-mapping name="faqs">
                <collection-mapping table="FAQ_TOPIC">
                    <primkey-mapping>
                        <cmp-field-mapping name="Topic_topicID">
                            <entity-ref home="Topic">
                                <cmp-field-mapping name="Topic_topicID" persistence-name="topic"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </primkey-mapping>
                    <value-mapping type="faqapp.FAQLocal">
                        <cmp-field-mapping name="FAQ_questionID">
                            <entity-ref home="FAQ">
                                <cmp-field-mapping name="FAQ_questionID" persistence-name="question"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </value-mapping>
                </collection-mapping>
            </cmp-field-mapping>
        </entity-deployment>
        <entity-deployment name="FAQ" table="FAQ">
            <primkey-mapping>
                <cmp-field-mapping name="questionID" persistence-name="questionID"/>
            </primkey-mapping>
            <cmp-field-mapping name="question" persistence-name="question"/>
            <cmp-field-mapping name="answer" persistence-name="answer"/>
            <cmp-field-mapping name="internalFlag" persistence-name="internalFlag"/>
            <cmp-field-mapping name="productVersion" persistence-name="productVersion"/>
            <cmp-field-mapping name="createdBy" persistence-name="createdBy"/>
            <cmp-field-mapping name="creationDate" persistence-name="creationDate"/>
            <cmp-field-mapping name="modifiedBy" persistence-name="modifiedBy"/>
            <cmp-field-mapping name="modificationDate" persistence-name="modificationDate"/>
            <cmp-field-mapping name="areas">
                <collection-mapping table="FAQ_AREA">
                    <primkey-mapping>
                        <cmp-field-mapping name="FAQ_questionID">
                            <entity-ref home="FAQ">
                                <cmp-field-mapping name="FAQ_questionID" persistence-name="question"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </primkey-mapping>
                    <value-mapping type="faqapp.AreaLocal">
                        <cmp-field-mapping name="Area_areaID">
                            <entity-ref home="Area">
                                <cmp-field-mapping name="Area_areaID" persistence-name="area"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </value-mapping>
                </collection-mapping>
            </cmp-field-mapping>
            <cmp-field-mapping name="topics">
                <collection-mapping table="FAQ_TOPIC">
                    <primkey-mapping>
                        <cmp-field-mapping name="FAQ_questionID">
                            <entity-ref home="FAQ">
                                <cmp-field-mapping name="FAQ_questionID" persistence-name="question"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </primkey-mapping>
                    <value-mapping type="faqapp.TopicLocal">
                        <cmp-field-mapping name="Topic_topicID">
                            <entity-ref home="Topic">
                                <cmp-field-mapping name="Topic_topicID" persistence-name="topic"/>
                            </entity-ref>
                        </cmp-field-mapping>
                    </value-mapping>
                </collection-mapping>
            </cmp-field-mapping>
        </entity-deployment>
    </enterprise-beans>
</orion-ejb-jar>
