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

   1 <?xml version="1.0"?>
   2 <!DOCTYPE hibernate-mapping PUBLIC
   3     "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   4     "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >   \r
   5
   6 <hibernate-mapping>
   7         <joined-subclass extends="org.codecoop.mir.core.model.Media"
   8                 name="org.codecoop.mir.core.model.Article"
   9                 table="article">
  10
  11                 <key column="media_id" foreign-key="fk_article_media"/>
  12
  13                 <property
  14                         column="date"
  15                         length="8"
  16                         name="date"
  17                         not-null="true"
  18                         type="java.lang.String"
  19                  />
  20                 <property
  21                         column="subtitle"
  22                         length="255"
  23                         name="subtitle"
  24                         type="java.lang.String"
  25                  />
  26                 <property
  27                         column="edittitle"
  28                         length="255"
  29                         name="edittitle"
  30                         type="java.lang.String"
  31                  />
  32                 <property
  33                         name="content"
  34                         type="java.lang.String">
  35                         <column name="content"
  36                                 sql-type="text"
  37                                 not-null="true"/>
  38                 </property>
  39                 <property
  40                         column="is_html"
  41                         length="1"
  42                         name="html"
  43                         not-null="true"
  44                         type="boolean"
  45                  />
  46                 <!-- Associations -->
  47                 <many-to-one
  48                         class="org.codecoop.mir.core.model.ArticleStatus"
  49                         column="to_article_status"
  50                         name="status"
  51                         foreign-key="fk_article_articlestatus"
  52                  />
  53                 <many-to-one
  54                         class="org.codecoop.mir.core.model.User"
  55                         column="to_locking_user"
  56                         name="lockingUser"
  57                         foreign-key="fk_article_lockinguser"
  58                 />
  59                 <many-to-one
  60                         class="org.codecoop.mir.core.model.Language"
  61                         column="to_language"
  62                         name="language"
  63                         foreign-key="fk_article_language"
  64                  />
  65                 <set name="typedCategories" table="article_x_category" inverse="false" cascade="save-update">
  66                         <key column="article_id"
  67                                 foreign-key="fk_article_category"/>
  68                         <!--
  69                         <composite-element class="org.codecoop.mir.core.model.TypedCategory">
  70                                 <many-to-one
  71                                         class="org.codecoop.mir.core.model.ArticleType"
  72                                         column="article_type_id"
  73                                         name="articleType"
  74                                         foreign-key="fk_articlexcategory_article_type"
  75                                 />
  76                                 <many-to-one
  77                                         class="org.codecoop.mir.core.model.Category"
  78                                         column="category_id"
  79                                         name="category"
  80                                         foreign-key="fk_articlexcategory_category"
  81                                 />
  82                         </composite-element>
  83                         -->
  84                         <many-to-many class="org.codecoop.mir.core.model.TypedCategory"
  85                                 foreign-key="fk_articlexcategory">
  86                                 <column name="article_type_id"/>
  87                                 <column name="category_id"/>
  88                         </many-to-many>
  89                 </set>
  90         </joined-subclass>
  91 </hibernate-mapping>