<hibernate-mapping schema="generalledger">
  <class name="Account" table="Account" dynamic-insert="true" dynamic-update="true">
    <bag name="credits" inverse="true" access="field" where="type='C'">
      <key column="account"/>
      <one-to-many class="CreditEntry"/>
    </bag>

    <bag name="debits" inverse="true" access="field" where="type='D'">
      <key column="account"/>
      <one-to-many class="DebitEntry" />
    </bag>
  </class>
</hibernate-mapping>

<hibernate-mapping schema="generalledger">
  <class name="AccountEntry" table="accountentry" dynamic-insert="true" dynamic-update="true">
    <discriminator column="type" type="string"/>

    <many-to-one name="period" cascade="none"/>
    <many-to-one name="account" class="Account" column="account"
                 cascade="none" not-null="true"/>

    <subclass name="net.tradestream.generalledger.domain.gl.CreditEntry" discriminator-value="C">
    </subclass>

    <subclass name="net.tradestream.generalledger.domain.gl.DebitEntry" discriminator-value="D">
    </subclass>
  </class>
</hibernate-mapping>

<hibernate-mapping schema="generalledger">
  <class name="Period" table="Period" dynamic-insert="true" dynamic-update="true">
    <property name="sequence" column="sequence" type="long"/>
  </class>
</hibernate-mapping>

<hibernate-mapping schema="generalledger">

  <class name="AccountTransaction" table="AccountTransaction" dynamic-insert="true" dynamic-update="true" >
    <many-to-one name="period" column="period" cascade="none" not-null="true"/>

    <bag name="entries" access="field" cascade="all-delete-orphan" inverse="true">
      <key column="accountTransaction"/>
      <one-to-many class="AccountEntry"/>
    </bag>

  </class>
</hibernate-mapping>