source/org/codecoop/mir/core/model/Category.hbm.xml

   1 <?xml version="1.0"?>\r
   2 <!DOCTYPE hibernate-mapping PUBLIC\r    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"\r    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >\r\r<hibernate-mapping>
   3         <class \r                name="org.codecoop.mir.core.model.Category" \r           table="category">
   4                 <id
   5                         column="id"
   6                         name="id"
   7                         type="java.lang.Integer"
   8                 >
   9                         <generator class="native">\r                             <param name="sequence">category_id_seq</param>\r                 </generator>
  10                 </id>
  11                 <property
  12                         column="title"
  13                         length="80"
  14                         name="title"
  15                         not-null="true"
  16                         type="java.lang.String"
  17                  />
  18                 <property
  19                         column="description"
  20                         name="description"
  21                         type="java.lang.String"
  22                  />
  23                 <property
  24                         column="filename"
  25                         length="20"
  26                         name="filename"
  27                         not-null="true"
  28                         type="java.lang.String"
  29                  />
  30                 <!-- Associations -->\r          <many-to-one \r                  class="org.codecoop.mir.core.model.CategoryType"\r                       column="category_type"\r                 name="categoryType"\r                    foreign-key="fk_category_categorytype"\r         />
  31                 <many-to-one
  32                         class="org.codecoop.mir.core.model.Category"
  33                         column="parent_id"
  34                         name="parentCategory"\r                  foreign-key="fk_category_parentcategory"
  35                  />
  36                 <set name="childCategories">
  37                         <key column="parent_id" \r                               foreign-key="fk_topic_childcategories"/>
  38                         <one-to-many class="org.codecoop.mir.core.model.Category" />
  39                 </set>
  40                 <set name="articles" table="article_x_category" lazy="true">
  41                         <key column="category_id" \r                             foreign-key="fk_category_article"/>
  42                         <many-to-many \r                         class="org.codecoop.mir.core.model.Article"\r                            foreign-key="fk_article_category_2" \r                           column="article_id" />
  43                 </set>
  44         </class>
  45 </hibernate-mapping>