hibernate的join标签

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

<class name="com.citigroup.cib.marx.curve.CDSCurveDefinition"
table="instrument" lazy="false"><!--cds_curve where="status='ok'"-->

<id name="curveId" column="instrument_id" type="integer">
<generator class="assigned" />
</id>

<many-to-one name="instrumentType" column="instrument_code"
class="com.citigroup.cib.marx.curve.InstrumentType" lazy="false"/>
<property name="instrumentDetails" column="instrument_details"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<many-to-one name="owner" column="owner_code"
class="com.citigroup.cib.marx.businessOrg.Desk" lazy="false" />

<property name="status" column="status"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<property name="enteredDate" column="entered_date" />
<property name="enteredUser" column="entered_user"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />

<set name="levels" cascade="all" inverse="true"
collection-type="com.citigroup.cib.marx.levels.collections.LevelCollectionType">
<key column="instrument_id" />
<one-to-many class="com.citigroup.cib.marx.levels.CDSLevel" />
</set>

<join table="cds_instrument" optional="false">
<key column="instrument_id"/>
<many-to-one name="referenceEntity" column="issuer_id" fetch="join"
lazy="false"
class="com.citigroup.cib.marx.referenceData.MarxReferenceEntity" />
<many-to-one name="subord" lazy="false"
class="com.citigroup.cib.marx.referenceData.Tier" />
<many-to-one name="currency" lazy="false"
class="com.citigroup.cib.marx.shared.Currency" />
<many-to-one name="source" column="source" lazy="false"
class="com.citigroup.cib.marx.referenceData.Source" />
<many-to-one name="type" lazy="false"
class="com.citigroup.cib.marx.curve.CurveType" />

<property name="curve" column="external_name"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<!--  <property name="recovery" /> -->
<property name="path"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<property name="creditEntityId" column="credit_entity_id" />
<property name="inactiveDate" column="inactive_date" />
<property name="shortCode" column="short_code"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<many-to-one name="rollType" column="roll_type"
class="com.citigroup.cib.marx.referenceData.RollType" lazy="false"/>
<property name="maturityDate" column="maturity_date" />

<property name="keyVersion" column="keyversion" />
<property name="active" column="isActive" type="boolean"/>
<property name="stale" column="isStale" type="boolean"/>
<property name="defaulted" column="isDefaulted" type="boolean"/>
<property name="clearingEligible" column="isClearingEligible" type="boolean"/>
<property name="defaultDate" column="defaultDate" />
<property name="noticeDate" column="noticeDate" />
<property name="settlementDate" column="settlementDate" />
<many-to-one name="docClause" column="doc_clause" class="com.citigroup.cib.marx.curve.DocClause" lazy="false"/>
<many-to-one name="txnTypeCurveExt" column="transaction_type" class="com.citigroup.cib.marx.referenceData.ReferenceEntityTxnType" lazy="false"/>

<property name="cdsStatus" column="status"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
<property name="cdsEnteredDate" column="entered_date" />
<property name="cdsEnteredUser" column="entered_user"
type="com.citigroup.cib.marx.persistence.util.TrimmedString" />
</join>

<join table="curve_rules" optional="true">
<key column="pr_curve_id" />
<many-to-one name="refCurve" column="ref_curve_id" cascade="save-update"
lazy="false"
class="com.citigroup.cib.marx.curve.CDSCurveDefinition" />
<property name="rulesType" column="type" type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="rulesIssuerId" column="issuer_id" type="integer"/>
<property name="rulesCurrency" column="currency" type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="rulesSubord" column="subord" type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
    <property name="rulesRefSource" column="ref_source" type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="defaultCurve" column="is_default" type="boolean"/>
<property name="rulesEnteredUser" column="entered_user" />
<property name="rulesEnteredDate" column="entered_date" />
</join>

<join table="blotter_curve" optional="true">
<key column="instrument_id"/>
<property name="bsecBloombergTicker3"
column="bloomberg_ticker3"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="bsecBloombergTicker"
column="bloomberg_ticker"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="bsecBloombergTicker7"
column="bloomberg_ticker7"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="bsecBloombergTicker10"
column="bloomberg_ticker10"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="bsecFlag" column="manifold_flag"/>
<property name="bsecComment" column="comment"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
<property name="bsecEnteredDate" column="entered_date"/>
<property name="bsecEnteredUser" column="entered_user"
type="com.citigroup.cib.marx.persistence.util.TrimmedString"/>
</join>
</class>
</hibernate-mapping>