Rev 953 | Rev 998 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
110 | susana | 1 | <?xml version="1.0"?> |
2 | <!DOCTYPE hibernate-mapping |
||
3 | PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" |
||
4 | "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> |
||
5 | |||
6 | <hibernate-mapping> |
||
287 | jmachado | 7 | <class name="pt.estgp.estgweb.domain.CourseUnit" table="courseunit" abstract="true"> |
146 | jmachado | 8 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
110 | susana | 9 | <meta attribute="scope-class">public abstract</meta> |
10 | <id name="id" type="long"> |
||
11 | <generator class="native"/> |
||
12 | </id> |
||
13 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 14 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
110 | susana | 15 | <property name="saveDate" type="timestamp"/> |
206 | jmachado | 16 | <property name="semestre" type="string" index="semestreIndex"/> |
17 | <property name="name" type="string" index="nameIndex"/> |
||
225 | jmachado | 18 | <property name="code" type="string" index="codeIndex"/> |
19 | <property name="courseCode" type="string" index="courseCodeIndex"/> |
||
20 | <property name="courseName" type="string" index="courseNameIndex"/> |
||
21 | <property name="courseYear" type="string" index="courseYearIndex"/> |
||
206 | jmachado | 22 | <property name="importYear" type="string" index="importYearIndex"/> |
225 | jmachado | 23 | <property name="institutionCode" type="string" index="institutionCodeIndex" /> |
214 | jmachado | 24 | <property name="pathIntranet" type="string" /> |
25 | <property name="normalizedName" type="string" /> |
||
203 | jmachado | 26 | <property name="objectives" type="text"/> |
225 | jmachado | 27 | <property name="programStreamId" type="string" index="programStreamIdIndex" /> |
343 | jmachado | 28 | <property name="validProgram" type="boolean" index="validProgramIndex"/> |
225 | jmachado | 29 | <property name="status" type="boolean" index="statusIndex" /> |
489 | jmachado | 30 | <property name="contentsGrants" type="string"/> |
917 | jmachado | 31 | <property name="evaluationStreamId" type="string" index="evaluationStreamIdIndex" /> |
995 | jmachado | 32 | <property name="summariesJson" type="text"> |
33 | <column name="summariesJson" sql-type="TEXT"/> |
||
34 | </property> |
||
343 | jmachado | 35 | <many-to-one name="validatorUser" class="pt.estgp.estgweb.domain.Teacher" lazy="false" outer-join="true"/> |
208 | jmachado | 36 | <many-to-one name="course" class="pt.estgp.estgweb.domain.Course" lazy="false" outer-join="true"/> |
938 | jmachado | 37 | <many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="proxy"/> |
38 | <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="proxy"/> |
||
39 | <!--<many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="false" outer-join="true"/> |
||
40 | <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="false" outer-join="true"/>--> |
||
749 | jmachado | 41 | <many-to-one name="responsableTeacher" class="pt.estgp.estgweb.domain.Teacher" lazy="false" outer-join="true"/> |
208 | jmachado | 42 | <set name="blogs" cascade="delete" lazy="true" order-by="saveDate asc"> |
203 | jmachado | 43 | <key column="courseUnit"/> |
44 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitBlog" /> |
||
45 | </set> |
||
296 | jmachado | 46 | <set name="teachers" lazy="true" table="teachedunits"> |
180 | jmachado | 47 | <key column="courseUnitId"/> |
205 | jmachado | 48 | <many-to-many class="pt.estgp.estgweb.domain.TeacherImpl" column="teacherId"/> |
180 | jmachado | 49 | </set> |
50 | <set name="students" lazy="true" table="subscribedunits"> |
||
51 | <key column="courseUnitId"/> |
||
52 | <many-to-many class="pt.estgp.estgweb.domain.StudentImpl" column="studentId"/> |
||
53 | </set> |
||
202 | jmachado | 54 | <set name="announcements" cascade="delete" lazy="true" order-by="saveDate desc"> |
55 | <key column="courseUnit"/> |
||
56 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAnnouncement" /> |
||
57 | </set> |
||
203 | jmachado | 58 | <set name="questions" cascade="delete" lazy="true" order-by="saveDate desc"> |
59 | <key column="courseUnit"/> |
||
60 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitQuestion" /> |
||
61 | </set> |
||
207 | jmachado | 62 | <set name="assignements" cascade="delete" lazy="true" order-by="deliverDate desc"> |
205 | jmachado | 63 | <key column="courseUnit"/> |
64 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAssignement"/> |
||
65 | </set> |
||
358 | jmachado | 66 | <set name="summaries" cascade="delete" lazy="true" order-by="dataAula desc"> |
67 | <key column="courseUnit"/> |
||
68 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitSummary"/> |
||
69 | </set> |
||
110 | susana | 70 | <subclass name="pt.estgp.estgweb.domain.CourseUnitImpl" discriminator-value="CourseUnitImpl"/> |
71 | </class> |
||
203 | jmachado | 72 | |
296 | jmachado | 73 | <class name="pt.estgp.estgweb.domain.CourseUnitQuestion" table="courseunitquestion" abstract="true"> |
236 | jmachado | 74 | <meta attribute="extends">pt.estgp.estgweb.domain.OwnedDomainObject</meta> |
203 | jmachado | 75 | <meta attribute="scope-class">public abstract</meta> |
76 | <id name="id" type="long"> |
||
77 | <generator class="native"/> |
||
78 | </id> |
||
79 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 80 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 81 | <property name="saveDate" type="timestamp"/> |
82 | <property name="question" type="text"/> |
||
83 | <property name="answer" type="text"/> |
||
84 | <property name="answred" type="boolean" index="answredIndex"/> |
||
236 | jmachado | 85 | <many-to-one name="owner" class="pt.estgp.estgweb.domain.GenericUser" lazy="false" outer-join="true"/> |
203 | jmachado | 86 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
87 | <subclass name="pt.estgp.estgweb.domain.CourseUnitQuestionImpl" discriminator-value="CourseUnitQuestionImpl"/> |
||
88 | </class> |
||
89 | |||
296 | jmachado | 90 | <class name="pt.estgp.estgweb.domain.CourseUnitAssignement" table="courseunitassignement" abstract="true"> |
203 | jmachado | 91 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
92 | <meta attribute="scope-class">public abstract</meta> |
||
93 | <id name="id" type="long"> |
||
94 | <generator class="native"/> |
||
95 | </id> |
||
96 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 97 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 98 | <property name="saveDate" type="timestamp"/> |
99 | <property name="deliverDate" type="timestamp"/> |
||
100 | <property name="deliverType" type="string"/> |
||
101 | <property name="lateDelivers" type="boolean"/> |
||
205 | jmachado | 102 | <property name="title" type="string"/> |
103 | <property name="description" type="text"/> |
||
208 | jmachado | 104 | <property name="repositoryStream" type="string" index="repositoryStreamIndex"/> |
205 | jmachado | 105 | <property name="status" type="boolean"/> |
203 | jmachado | 106 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
208 | jmachado | 107 | <set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc"> |
207 | jmachado | 108 | <key column="courseUnitAssignement"/> |
109 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/> |
||
110 | </set> |
||
203 | jmachado | 111 | <subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/> |
112 | </class> |
||
113 | |||
296 | jmachado | 114 | <class name="pt.estgp.estgweb.domain.CourseUnitDeliverable" table="courseunitdeliverable" abstract="true"> |
203 | jmachado | 115 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
116 | <meta attribute="scope-class">public abstract</meta> |
||
117 | <id name="id" type="long"> |
||
118 | <generator class="native"/> |
||
119 | </id> |
||
120 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 121 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 122 | <property name="saveDate" type="timestamp"/> |
208 | jmachado | 123 | <property name="deliverDate" type="timestamp"/> |
124 | <property name="grade" type="string"/> |
||
125 | <property name="obs" type="text"/> |
||
428 | jmachado | 126 | <property name="studentId" type="long"/> |
127 | <property name="studentUsername" type="string"/> |
||
128 | <property name="studentCode" type="string"/> |
||
129 | <property name="studentName" type="string"/> |
||
208 | jmachado | 130 | <property name="deliverableRepositoryStream" type="string" index="deliverableRepositoryStreamIndex"/> |
203 | jmachado | 131 | <many-to-one name="courseUnitAssignement" class="pt.estgp.estgweb.domain.CourseUnitAssignement" lazy="false" outer-join="true"/> |
132 | <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/> |
||
133 | <subclass name="pt.estgp.estgweb.domain.CourseUnitDeliverableImpl" discriminator-value="CourseUnitDeliverableImpl"/> |
||
134 | </class> |
||
135 | |||
296 | jmachado | 136 | <class name="pt.estgp.estgweb.domain.CourseUnitGrade" table="courseunitgrade" abstract="true"> |
219 | jmachado | 137 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
138 | <meta attribute="scope-class">public abstract</meta> |
||
139 | <id name="id" type="long"> |
||
140 | <generator class="native"/> |
||
141 | </id> |
||
142 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 143 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
219 | jmachado | 144 | <property name="saveDate" type="timestamp"/> |
145 | <property name="publishDate" type="timestamp"/> |
||
146 | <property name="grade" type="int" index="gradeIndex"/> |
||
228 | jmachado | 147 | <property name="normalizedCourseUnitName" type="string"/> |
219 | jmachado | 148 | <property name="statusEpoca" type="int" index="statusEpocaIndex"/> |
149 | <property name="importYear" type="string" index="importYearIndex"/> |
||
150 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
||
151 | <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/> |
||
152 | <subclass name="pt.estgp.estgweb.domain.CourseUnitGradeImpl" discriminator-value="CourseUnitGradeImpl"/> |
||
153 | </class> |
||
154 | |||
358 | jmachado | 155 | <class name="pt.estgp.estgweb.domain.CourseUnitSummary" table="courseunitsummary" abstract="true"> |
156 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
157 | <meta attribute="scope-class">public abstract</meta> |
||
158 | <id name="id" type="long"> |
||
159 | <generator class="native"/> |
||
160 | </id> |
||
161 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 162 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
358 | jmachado | 163 | <property name="saveDate" type="timestamp"/> |
164 | <property name="dataAula" type="timestamp"/> |
||
165 | <property name="tipoAula" type="string"/> |
||
166 | <property name="codigoAula" type="string"/> |
||
167 | <property name="codigoSumario" type="string"/> |
||
168 | <property name="codigoSalaAula" type="string"/> |
||
169 | <property name="alunosPresentes" type="int"/> |
||
170 | <property name="numeroAula" type="int"/> |
||
171 | <property name="titulo" type="string" index="tituloIndex"/> |
||
172 | <property name="descricao" type="text"/> |
||
173 | <property name="cEstado" type="string"/> |
||
995 | jmachado | 174 | <property name="numeroHoras" type="string"/> |
358 | jmachado | 175 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
176 | <subclass name="pt.estgp.estgweb.domain.CourseUnitSummaryImpl" discriminator-value="CourseUnitSummaryImpl"/> |
||
177 | </class> |
||
178 | |||
726 | jmachado | 179 | |
180 | |||
181 | <class name="pt.estgp.estgweb.domain.CourseUnitProgram" table="courseunitprogram" abstract="true"> |
||
182 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
183 | <meta attribute="scope-class">public abstract</meta> |
||
184 | <id name="id" type="long"> |
||
185 | <generator class="native"/> |
||
186 | </id> |
||
187 | <discriminator column="discrimitator"/> |
||
188 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
189 | <property name="saveDate" type="timestamp"/> |
||
190 | <property name="bibliografia" type="text"/> |
||
730 | jmachado | 191 | <property name="bibliografiaComplementar" type="text"/> |
726 | jmachado | 192 | <property name="adaptacaoObjectivosMetodologia" type="text"/> |
193 | <property name="demonstracaoCargaEcts" type="text"/> |
||
194 | <property name="garantiaAvaliacaoFuncaObjectivos" type="text"/> |
||
195 | <property name="metodologiasActividadeCientifica" type="text"/> |
||
196 | <property name="ects" type="string"/> |
||
197 | <property name="prerequisitos" type="text"/> |
||
198 | <property name="obrigatoria" type="string"/> |
||
199 | <property name="lingua1" type="string"/> |
||
200 | <property name="lingua2" type="string"/> |
||
749 | jmachado | 201 | |
202 | <property name="cargaHorariaTotal" type="string"/> |
||
203 | <property name="cargaHorariaT" type="string"/> |
||
204 | <property name="cargaHorariaTP" type="string"/> |
||
205 | <property name="cargaHorariaPL" type="string"/> |
||
206 | <property name="cargaHorariaS" type="string"/> |
||
207 | <property name="cargaHorariaTC" type="string"/> |
||
208 | <property name="cargaHorariaO" type="string"/> |
||
209 | <property name="cargaHorariaOT" type="string"/> |
||
210 | |||
747 | jmachado | 211 | <many-to-one name="courseUnitProgramPart2" class="pt.estgp.estgweb.domain.CourseUnitProgramPart2" lazy="false" outer-join="true"/> |
726 | jmachado | 212 | <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramImpl" discriminator-value="CourseUnitProgramImpl"/> |
213 | </class> |
||
214 | |||
747 | jmachado | 215 | <class name="pt.estgp.estgweb.domain.CourseUnitProgramPart2" table="courseunitprogrampart2" abstract="true"> |
216 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
217 | <meta attribute="scope-class">public abstract</meta> |
||
218 | <id name="id" type="long"> |
||
219 | <generator class="native"/> |
||
220 | </id> |
||
221 | <discriminator column="discrimitator"/> |
||
222 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
223 | <property name="saveDate" type="timestamp"/> |
||
224 | <property name="objectivos" type="text"/> |
||
225 | <property name="conteudos" type="text"/> |
||
226 | <property name="demonstracaoCoerenciaConteudos" type="text"/> |
||
227 | <property name="metodologiasEnsino" type="text"/> |
||
228 | <property name="avaliacaoOrdinariosFrequencia" type="text"/> |
||
229 | <property name="avaliacaoOrdinariosExame" type="text"/> |
||
230 | <property name="avaliacaoEspeciaisFrequencia" type="text"/> |
||
231 | <property name="avaliacaoEspeciaissExame" type="text"/> |
||
232 | <property name="demonstracaoObjectivosMetodologia" type="text"/> |
||
233 | <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramPart2Impl" discriminator-value="CourseUnitProgramPart2Impl"/> |
||
234 | </class> |
||
726 | jmachado | 235 | |
747 | jmachado | 236 | |
881 | jmachado | 237 | |
238 | <class name="pt.estgp.estgweb.domain.CourseUnitEvaluation" table="courseunitevaluation" abstract="true"> |
||
239 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
240 | <meta attribute="scope-class">public abstract</meta> |
||
241 | <id name="id" type="long"> |
||
242 | <generator class="native"/> |
||
243 | </id> |
||
244 | <discriminator column="discrimitator"/> |
||
245 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
246 | <property name="saveDate" type="timestamp"/> |
||
887 | jmachado | 247 | <property name="closed" type="boolean"/> |
881 | jmachado | 248 | <property name="numAlunosInscritos" type="text"/> |
249 | <property name="numAlunosSemElementosAvaliacao" type="integer"/> |
||
250 | |||
251 | <property name="numAlunosAprovFrequencia" type="integer"/> |
||
252 | <property name="numAlunosAprovNormal" type="integer"/> |
||
253 | <property name="numAlunosAprovRecurso" type="integer"/> |
||
254 | <property name="numAlunosAprovEspecial" type="integer"/> |
||
255 | <property name="numAlunosAprovTotal" type="integer"/> |
||
256 | |||
257 | <property name="numAlunosAprov1013" type="integer"/> |
||
258 | <property name="numAlunosAprov1416" type="integer"/> |
||
259 | <property name="numAlunosAprov1720" type="integer"/> |
||
260 | |||
261 | <property name="numAlunosAprovados" type="integer"/> |
||
262 | <property name="numAlunosReprovados" type="integer"/> |
||
263 | |||
264 | <property name="qualApreciacaoQuantitivos" type="text"/> |
||
265 | <property name="qualApreciacaoUC" type="text"/> |
||
266 | <property name="qualApreciacaoCumprimentoPrograma" type="text"/> |
||
267 | <property name="qualConclusoes" type="text"/> |
||
268 | |||
953 | jmachado | 269 | |
881 | jmachado | 270 | <subclass name="pt.estgp.estgweb.domain.CourseUnitEvaluationImpl" discriminator-value="CourseUnitEvaluationImpl"/> |
271 | </class> |
||
272 | |||
273 | |||
296 | jmachado | 274 | <!--<class name="pt.estgp.estgweb.domain.CourseUnit" table="courseunitassignement" abstract="true">--> |
226 | jmachado | 275 | <!--<meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>--> |
276 | <!--<meta attribute="scope-class">public abstract</meta>--> |
||
277 | <!--<id name="id" type="long">--> |
||
278 | <!--<generator class="native"/>--> |
||
279 | <!--</id>--> |
||
280 | <!--<discriminator column="discrimitator"/>--> |
||
690 | jmachado | 281 | <!--<timestamp source="db" name="updateDate" unsaved-value="null"/>--> |
226 | jmachado | 282 | <!--<property name="saveDate" type="timestamp"/>--> |
283 | <!--<property name="deliverDate" type="timestamp"/>--> |
||
284 | <!--<property name="deliverType" type="string"/>--> |
||
285 | <!--<property name="lateDelivers" type="boolean"/>--> |
||
286 | <!--<property name="title" type="string"/>--> |
||
287 | <!--<property name="description" type="text"/>--> |
||
288 | <!--<property name="repositoryStream" type="string" index="repositoryStreamIndex"/>--> |
||
289 | <!--<property name="status" type="boolean"/>--> |
||
290 | <!--<many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>--> |
||
291 | <!--<set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc">--> |
||
292 | <!--<key column="courseUnitAssignement"/>--> |
||
293 | <!--<one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/>--> |
||
294 | <!--</set>--> |
||
295 | <!--<subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/>--> |
||
296 | <!--</class>--> |
||
225 | jmachado | 297 | |
110 | susana | 298 | </hibernate-mapping> |