<class name="SpecBench.CoreData.Category">
    <id name="id" type="long" access="field" unsaved-value="-1">
        <generator class="native"/>
    </id>
    <many-to-one name="parentCategory" class="SpecBench.CoreData.Category" column="parent_id"/>
    <list name="subCategories">
        <key column="parent_id"/>
        <index column="list_ndx"/>
        <one-to-many class="SpecBench.CoreData.Category"/>
    </list>
    <property name="name" column="name" type="string"/>
    <property name="description" column="description" type="string"/>
</class>

<hibernate-mapping package="com.invidex.videolinx.common.persistence.dto.request">

   <class name="UserRequestChangeDTO" table="User_Request_Change">

      <cache usage="read-write"/>

      <id name="id">
         <generator class="native"/>
      </id>

      <property name="status" column="status_id" not-null="true"/>

      <many-to-one name="parentUserRequest" column="user_request_id" cascade="none" not-null="true"/>

      <list name="innerChangeComments" table="User_Request_Change_Info" inverse="false" cascade="all-delete-orphan">
         <cache usage="read-write"/>
         <key column="user_request_change_id"/>
         <index column="sequence_number"/>
         <one-to-many class="UserRequestChangeCommentDTO"/>
      </list>

   </class>

</hibernate-mapping>

<hibernate-mapping package="com.invidex.videolinx.common.persistence.dto.request">

   <class name="UserRequestChangeCommentDTO" table="User_Request_Change_Info">

      <cache usage="read-write"/>

      <id name="id">
         <generator class="native"/>
      </id>

      <property name="description" column="description" not-null="true"/>
      <property name="createdBy" column="created_by" not-null="true"/>
      <property name="createdDate" column="creation_date" not-null="true"/>

   </class>

</hibernate-mapping>