+++ /dev/null
-<?xml version="1.0"?>\r
-<!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>
- <class \r name="org.codecoop.mir.core.model.Category" \r table="category">
- <id
- column="id"
- name="id"
- type="java.lang.Integer"
- >
- <generator class="native">\r <param name="sequence">category_id_seq</param>\r </generator>
- </id>
- <property
- column="title"
- length="80"
- name="title"
- not-null="true"
- type="java.lang.String"
- />
- <property
- column="description"
- name="description"
- type="java.lang.String"
- />
- <property
- column="filename"
- length="20"
- name="filename"
- not-null="true"
- type="java.lang.String"
- />
- <!-- 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 />
- <many-to-one
- class="org.codecoop.mir.core.model.Category"
- column="parent_id"
- name="parentCategory"\r foreign-key="fk_category_parentcategory"
- />
- <set name="childCategories">
- <key column="parent_id" \r foreign-key="fk_topic_childcategories"/>
- <one-to-many class="org.codecoop.mir.core.model.Category" />
- </set>
- <set name="articles" table="article_x_category" lazy="true">
- <key column="category_id" \r foreign-key="fk_category_article"/>
- <many-to-many \r class="org.codecoop.mir.core.model.Article"\r foreign-key="fk_article_category_2" \r column="article_id" />
- </set>
- </class>
-</hibernate-mapping>