771ccf6aed04bfe1e1beea72a253cc337fd49278
[mir.git] / source / mir / core / model / Audio.hbm.xml
1 <?xml version="1.0"?>\r
2 <!DOCTYPE hibernate-mapping PUBLIC\r
3     "-//Hibernate/Hibernate Mapping DTD//EN"\r
4     "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >\r
5     \r
6 <hibernate-mapping>\r
7 \r
8 <!-- \r
9     Created by Middlegen Hibernate plugin\r
10 \r
11     http://boss.bekk.no/boss/middlegen/\r
12     http://hibernate.sourceforge.net/\r
13 -->\r
14 \r
15 <class \r
16     name="mir.core.model.Audio" \r
17     table="audio"\r
18 >\r
19     <id\r
20         name="id"\r
21         type="int"\r
22         column="id"\r
23     >\r
24         <generator class="sequence"/>\r
25     </id>\r
26     <property\r
27         name="title"\r
28         type="java.lang.String"\r
29         column="title"\r
30         not-null="true"\r
31         length="80"\r
32     />\r
33     <property\r
34         name="subtitle"\r
35         type="java.lang.String"\r
36         column="subtitle"\r
37         length="30"\r
38     />\r
39     <property\r
40         name="edittitle"\r
41         type="java.lang.String"\r
42         column="edittitle"\r
43         length="30"\r
44     />\r
45     <property\r
46         name="date"\r
47         type="java.lang.String"\r
48         column="date"\r
49         not-null="true"\r
50         length="8"\r
51     />\r
52     <property\r
53         name="creator"\r
54         type="java.lang.String"\r
55         column="creator"\r
56         length="80"\r
57     />\r
58     <property\r
59         name="creatorMainUrl"\r
60         type="java.lang.String"\r
61         column="creator_main_url"\r
62         length="255"\r
63     />\r
64     <property\r
65         name="creatorEmail"\r
66         type="java.lang.String"\r
67         column="creator_email"\r
68         length="80"\r
69     />\r
70     <property\r
71         name="creatorAddress"\r
72         type="java.lang.String"\r
73         column="creator_address"\r
74         length="80"\r
75     />\r
76     <property\r
77         name="creatorPhone"\r
78         type="java.lang.String"\r
79         column="creator_phone"\r
80         length="20"\r
81     />\r
82     <property\r
83         name="description"\r
84         type="java.lang.String"\r
85         column="description"\r
86         length="-1"\r
87     />\r
88     <property\r
89         name="keywords"\r
90         type="java.lang.String"\r
91         column="keywords"\r
92         length="-1"\r
93     />\r
94     <property\r
95         name="comment"\r
96         type="java.lang.String"\r
97         column="comment"\r
98         length="-1"\r
99     />\r
100     <property\r
101         name="source"\r
102         type="java.lang.String"\r
103         column="source"\r
104         length="255"\r
105     />\r
106     <property\r
107         name="publishDate"\r
108         type="java.sql.Timestamp"\r
109         column="publish_date"\r
110         length="8"\r
111     />\r
112     <property\r
113         name="publishServer"\r
114         type="java.lang.String"\r
115         column="publish_server"\r
116         length="255"\r
117     />\r
118     <property\r
119         name="publishPath"\r
120         type="java.lang.String"\r
121         column="publish_path"\r
122         length="255"\r
123     />\r
124     <property\r
125         name="isPublished"\r
126         type="boolean"\r
127         column="is_published"\r
128         not-null="true"\r
129         length="1"\r
130     />\r
131     <property\r
132         name="isProduced"\r
133         type="boolean"\r
134         column="is_produced"\r
135         not-null="true"\r
136         length="1"\r
137     />\r
138     <property\r
139         name="webdbCreate"\r
140         type="java.sql.Timestamp"\r
141         column="webdb_create"\r
142         not-null="true"\r
143         length="8"\r
144     />\r
145     <property\r
146         name="webdbLastchange"\r
147         type="java.sql.Timestamp"\r
148         column="webdb_lastchange"\r
149         length="8"\r
150     />\r
151         <property\r
152         name="iconIsProduced"\r
153         type="boolean"\r
154         column="icon_is_produced"\r
155         not-null="true"\r
156         length="1"\r
157     />\r
158     <property\r
159         name="iconPath"\r
160         type="java.lang.String"\r
161         column="icon_path"\r
162         length="255"\r
163     />   \r
164     <property\r
165         name="kbits"\r
166         type="short"\r
167         column="kbits"\r
168         length="2"\r
169     />     \r
170     <!-- associations -->\r
171     <one-to-one\r
172         name="feature"\r
173         class="mir.core.model.Feature"\r
174         column="to_feature"\r
175     />\r
176     <one-to-one\r
177         name="mediaFolder"\r
178         class="mir.core.model.MediaFolder"\r
179         column="to_media_folder"\r
180     />\r
181     <one-to-one\r
182         name="mediaType"\r
183         class="mir.core.model.MediaType"\r
184         column="to_media_type"\r
185     />\r
186     <one-to-one\r
187         name="publisher"\r
188         class="mir.core.model.MirUser"\r
189         column="to_publisher"\r
190     />\r
191     <one-to-one\r
192         name="language"\r
193         class="mir.core.model.Language"\r
194         column="to_language"\r
195     />\r
196     <one-to-one\r
197         name="rights"\r
198         class="mir.core.model.Rights"\r
199         column="to_rights"\r
200     />\r
201     <set name="content" table="content_x_media" lazy="true">\r
202             <key column="media_id"/>\r
203             <many-to-many column="content_id" class="mir.core.model.Content"/>\r
204         </set>\r
205     \r
206 </class>\r
207 </hibernate-mapping>\r