runtime/org.argeo.slc.support.hibernate/src/main/resources/org/argeo/slc/hibernate/test/tree/TreeTestResult.hbm.xml

   1 <?xml version="1.0"?>
   2 <!DOCTYPE hibernate-mapping PUBLIC
   3         "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   4         "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
   5 <hibernate-mapping package="org.argeo.slc.core.test.tree">
   6         <class name="TreeTestResult" table="TREE_TEST_RESULT">
   7                 <cache usage="read-write" />
   8                 <id name="uuid" column="UUID" />
   9
  10                 <property name="closeDate" column="CLOSE_DATE" type="timestamp"
  11                         not-null="false" />
  12
  13                 <map name="attributes" table="TTR_ATTRS_MAP" cascade="all" lazy="false"
  14                         sort="natural">
  15                         <cache usage="read-write" />
  16                         <key column="PARENT_ID" />
  17                         <map-key column="ATTR_NAME" type="string" />
  18                         <element column="NAME" type="string" />
  19                 </map>
  20
  21                 <map name="resultParts" table="RESULT_PARTS_MAP" cascade="all"
  22                         sort="natural">
  23                         <cache usage="nonstrict-read-write" />
  24                         <key column="PARENT_ID" />
  25                         <composite-map-key class="org.argeo.slc.core.structure.tree.TreeSPath">
  26                                 <key-property name="asUniqueString" column="PATH" />
  27                         </composite-map-key>
  28                         <many-to-many class="PartSubList" column="PART_SUB_LIST_ID"
  29                                 unique="true" />
  30                 </map>
  31
  32                 <map name="elements" table="RESULT_ELEMENTS_MAP" cascade="all"
  33                         sort="natural">
  34                         <cache usage="nonstrict-read-write" />
  35                         <key column="PARENT_ID" />
  36                         <composite-map-key class="org.argeo.slc.core.structure.tree.TreeSPath">
  37                                 <key-property name="asUniqueString" column="PATH" />
  38                         </composite-map-key>
  39                         <many-to-many class="org.argeo.slc.core.structure.SimpleSElement"
  40                                 column="ELEMENT_ID" unique="true" />
  41                 </map>
  42
  43                 <list name="attachments" table="RESULTS_ATTACHMENTS" cascade="all">
  44                         <cache usage="nonstrict-read-write" />
  45                         <key column="RESULT_ATTACHMENT_ID" />
  46                         <list-index column="INDX" />
  47                         <many-to-many class="org.argeo.slc.core.attachment.SimpleAttachment"
  48                                 column="ATTACHMENT_ID" unique="true" />
  49                 </list>
  50         </class>
  51 </hibernate-mapping>