Rev 1024 | Rev 1057 | 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> |
||
999 | jmachado | 35 | <!--Not In Use--> |
1029 | jmachado | 36 | <many-to-one name="validatorUser" class="pt.estgp.estgweb.domain.User" lazy="false" outer-join="true" /> |
208 | jmachado | 37 | <many-to-one name="course" class="pt.estgp.estgweb.domain.Course" lazy="false" outer-join="true"/> |
1029 | jmachado | 38 | <many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="proxy" /> |
39 | <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="proxy" /> |
||
938 | jmachado | 40 | <!--<many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="false" outer-join="true"/> |
41 | <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="false" outer-join="true"/>--> |
||
998 | jmachado | 42 | <many-to-one name="responsableTeacher" class="pt.estgp.estgweb.domain.Teacher" lazy="false" outer-join="true" not-null="false"/> |
208 | jmachado | 43 | <set name="blogs" cascade="delete" lazy="true" order-by="saveDate asc"> |
203 | jmachado | 44 | <key column="courseUnit"/> |
45 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitBlog" /> |
||
46 | </set> |
||
296 | jmachado | 47 | <set name="teachers" lazy="true" table="teachedunits"> |
180 | jmachado | 48 | <key column="courseUnitId"/> |
205 | jmachado | 49 | <many-to-many class="pt.estgp.estgweb.domain.TeacherImpl" column="teacherId"/> |
180 | jmachado | 50 | </set> |
51 | <set name="students" lazy="true" table="subscribedunits"> |
||
52 | <key column="courseUnitId"/> |
||
53 | <many-to-many class="pt.estgp.estgweb.domain.StudentImpl" column="studentId"/> |
||
54 | </set> |
||
202 | jmachado | 55 | <set name="announcements" cascade="delete" lazy="true" order-by="saveDate desc"> |
56 | <key column="courseUnit"/> |
||
57 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAnnouncement" /> |
||
58 | </set> |
||
203 | jmachado | 59 | <set name="questions" cascade="delete" lazy="true" order-by="saveDate desc"> |
60 | <key column="courseUnit"/> |
||
61 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitQuestion" /> |
||
62 | </set> |
||
207 | jmachado | 63 | <set name="assignements" cascade="delete" lazy="true" order-by="deliverDate desc"> |
205 | jmachado | 64 | <key column="courseUnit"/> |
65 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAssignement"/> |
||
66 | </set> |
||
358 | jmachado | 67 | <set name="summaries" cascade="delete" lazy="true" order-by="dataAula desc"> |
68 | <key column="courseUnit"/> |
||
69 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitSummary"/> |
||
70 | </set> |
||
110 | susana | 71 | <subclass name="pt.estgp.estgweb.domain.CourseUnitImpl" discriminator-value="CourseUnitImpl"/> |
72 | </class> |
||
203 | jmachado | 73 | |
296 | jmachado | 74 | <class name="pt.estgp.estgweb.domain.CourseUnitQuestion" table="courseunitquestion" abstract="true"> |
236 | jmachado | 75 | <meta attribute="extends">pt.estgp.estgweb.domain.OwnedDomainObject</meta> |
203 | jmachado | 76 | <meta attribute="scope-class">public abstract</meta> |
77 | <id name="id" type="long"> |
||
78 | <generator class="native"/> |
||
79 | </id> |
||
80 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 81 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 82 | <property name="saveDate" type="timestamp"/> |
83 | <property name="question" type="text"/> |
||
84 | <property name="answer" type="text"/> |
||
85 | <property name="answred" type="boolean" index="answredIndex"/> |
||
236 | jmachado | 86 | <many-to-one name="owner" class="pt.estgp.estgweb.domain.GenericUser" lazy="false" outer-join="true"/> |
203 | jmachado | 87 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
88 | <subclass name="pt.estgp.estgweb.domain.CourseUnitQuestionImpl" discriminator-value="CourseUnitQuestionImpl"/> |
||
89 | </class> |
||
90 | |||
296 | jmachado | 91 | <class name="pt.estgp.estgweb.domain.CourseUnitAssignement" table="courseunitassignement" abstract="true"> |
203 | jmachado | 92 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
93 | <meta attribute="scope-class">public abstract</meta> |
||
94 | <id name="id" type="long"> |
||
95 | <generator class="native"/> |
||
96 | </id> |
||
97 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 98 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 99 | <property name="saveDate" type="timestamp"/> |
100 | <property name="deliverDate" type="timestamp"/> |
||
101 | <property name="deliverType" type="string"/> |
||
102 | <property name="lateDelivers" type="boolean"/> |
||
205 | jmachado | 103 | <property name="title" type="string"/> |
104 | <property name="description" type="text"/> |
||
208 | jmachado | 105 | <property name="repositoryStream" type="string" index="repositoryStreamIndex"/> |
205 | jmachado | 106 | <property name="status" type="boolean"/> |
203 | jmachado | 107 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
208 | jmachado | 108 | <set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc"> |
207 | jmachado | 109 | <key column="courseUnitAssignement"/> |
110 | <one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/> |
||
111 | </set> |
||
203 | jmachado | 112 | <subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/> |
113 | </class> |
||
114 | |||
296 | jmachado | 115 | <class name="pt.estgp.estgweb.domain.CourseUnitDeliverable" table="courseunitdeliverable" abstract="true"> |
203 | jmachado | 116 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
117 | <meta attribute="scope-class">public abstract</meta> |
||
118 | <id name="id" type="long"> |
||
119 | <generator class="native"/> |
||
120 | </id> |
||
121 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 122 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
203 | jmachado | 123 | <property name="saveDate" type="timestamp"/> |
208 | jmachado | 124 | <property name="deliverDate" type="timestamp"/> |
125 | <property name="grade" type="string"/> |
||
126 | <property name="obs" type="text"/> |
||
428 | jmachado | 127 | <property name="studentId" type="long"/> |
128 | <property name="studentUsername" type="string"/> |
||
129 | <property name="studentCode" type="string"/> |
||
130 | <property name="studentName" type="string"/> |
||
208 | jmachado | 131 | <property name="deliverableRepositoryStream" type="string" index="deliverableRepositoryStreamIndex"/> |
203 | jmachado | 132 | <many-to-one name="courseUnitAssignement" class="pt.estgp.estgweb.domain.CourseUnitAssignement" lazy="false" outer-join="true"/> |
133 | <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/> |
||
134 | <subclass name="pt.estgp.estgweb.domain.CourseUnitDeliverableImpl" discriminator-value="CourseUnitDeliverableImpl"/> |
||
135 | </class> |
||
136 | |||
296 | jmachado | 137 | <class name="pt.estgp.estgweb.domain.CourseUnitGrade" table="courseunitgrade" abstract="true"> |
219 | jmachado | 138 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
139 | <meta attribute="scope-class">public abstract</meta> |
||
140 | <id name="id" type="long"> |
||
141 | <generator class="native"/> |
||
142 | </id> |
||
143 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 144 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
219 | jmachado | 145 | <property name="saveDate" type="timestamp"/> |
146 | <property name="publishDate" type="timestamp"/> |
||
147 | <property name="grade" type="int" index="gradeIndex"/> |
||
228 | jmachado | 148 | <property name="normalizedCourseUnitName" type="string"/> |
219 | jmachado | 149 | <property name="statusEpoca" type="int" index="statusEpocaIndex"/> |
150 | <property name="importYear" type="string" index="importYearIndex"/> |
||
151 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
||
152 | <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/> |
||
153 | <subclass name="pt.estgp.estgweb.domain.CourseUnitGradeImpl" discriminator-value="CourseUnitGradeImpl"/> |
||
154 | </class> |
||
155 | |||
358 | jmachado | 156 | <class name="pt.estgp.estgweb.domain.CourseUnitSummary" table="courseunitsummary" abstract="true"> |
157 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
158 | <meta attribute="scope-class">public abstract</meta> |
||
159 | <id name="id" type="long"> |
||
160 | <generator class="native"/> |
||
161 | </id> |
||
162 | <discriminator column="discrimitator"/> |
||
690 | jmachado | 163 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
358 | jmachado | 164 | <property name="saveDate" type="timestamp"/> |
165 | <property name="dataAula" type="timestamp"/> |
||
166 | <property name="tipoAula" type="string"/> |
||
167 | <property name="codigoAula" type="string"/> |
||
168 | <property name="codigoSumario" type="string"/> |
||
169 | <property name="codigoSalaAula" type="string"/> |
||
170 | <property name="alunosPresentes" type="int"/> |
||
171 | <property name="numeroAula" type="int"/> |
||
172 | <property name="titulo" type="string" index="tituloIndex"/> |
||
173 | <property name="descricao" type="text"/> |
||
174 | <property name="cEstado" type="string"/> |
||
995 | jmachado | 175 | <property name="numeroHoras" type="string"/> |
358 | jmachado | 176 | <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/> |
177 | <subclass name="pt.estgp.estgweb.domain.CourseUnitSummaryImpl" discriminator-value="CourseUnitSummaryImpl"/> |
||
178 | </class> |
||
179 | |||
726 | jmachado | 180 | |
181 | |||
182 | <class name="pt.estgp.estgweb.domain.CourseUnitProgram" table="courseunitprogram" abstract="true"> |
||
183 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
184 | <meta attribute="scope-class">public abstract</meta> |
||
185 | <id name="id" type="long"> |
||
186 | <generator class="native"/> |
||
187 | </id> |
||
188 | <discriminator column="discrimitator"/> |
||
189 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
190 | <property name="saveDate" type="timestamp"/> |
||
191 | <property name="bibliografia" type="text"/> |
||
730 | jmachado | 192 | <property name="bibliografiaComplementar" type="text"/> |
726 | jmachado | 193 | <property name="adaptacaoObjectivosMetodologia" type="text"/> |
194 | <property name="demonstracaoCargaEcts" type="text"/> |
||
195 | <property name="garantiaAvaliacaoFuncaObjectivos" type="text"/> |
||
196 | <property name="metodologiasActividadeCientifica" type="text"/> |
||
197 | <property name="ects" type="string"/> |
||
198 | <property name="prerequisitos" type="text"/> |
||
199 | <property name="obrigatoria" type="string"/> |
||
200 | <property name="lingua1" type="string"/> |
||
201 | <property name="lingua2" type="string"/> |
||
749 | jmachado | 202 | |
203 | <property name="cargaHorariaTotal" type="string"/> |
||
204 | <property name="cargaHorariaT" type="string"/> |
||
205 | <property name="cargaHorariaTP" type="string"/> |
||
206 | <property name="cargaHorariaPL" type="string"/> |
||
207 | <property name="cargaHorariaS" type="string"/> |
||
208 | <property name="cargaHorariaTC" type="string"/> |
||
209 | <property name="cargaHorariaO" type="string"/> |
||
210 | <property name="cargaHorariaOT" type="string"/> |
||
211 | |||
747 | jmachado | 212 | <many-to-one name="courseUnitProgramPart2" class="pt.estgp.estgweb.domain.CourseUnitProgramPart2" lazy="false" outer-join="true"/> |
726 | jmachado | 213 | <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramImpl" discriminator-value="CourseUnitProgramImpl"/> |
214 | </class> |
||
215 | |||
747 | jmachado | 216 | <class name="pt.estgp.estgweb.domain.CourseUnitProgramPart2" table="courseunitprogrampart2" abstract="true"> |
217 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
218 | <meta attribute="scope-class">public abstract</meta> |
||
219 | <id name="id" type="long"> |
||
220 | <generator class="native"/> |
||
221 | </id> |
||
222 | <discriminator column="discrimitator"/> |
||
223 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
224 | <property name="saveDate" type="timestamp"/> |
||
225 | <property name="objectivos" type="text"/> |
||
226 | <property name="conteudos" type="text"/> |
||
227 | <property name="demonstracaoCoerenciaConteudos" type="text"/> |
||
228 | <property name="metodologiasEnsino" type="text"/> |
||
229 | <property name="avaliacaoOrdinariosFrequencia" type="text"/> |
||
230 | <property name="avaliacaoOrdinariosExame" type="text"/> |
||
231 | <property name="avaliacaoEspeciaisFrequencia" type="text"/> |
||
232 | <property name="avaliacaoEspeciaissExame" type="text"/> |
||
233 | <property name="demonstracaoObjectivosMetodologia" type="text"/> |
||
234 | <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramPart2Impl" discriminator-value="CourseUnitProgramPart2Impl"/> |
||
235 | </class> |
||
726 | jmachado | 236 | |
747 | jmachado | 237 | |
881 | jmachado | 238 | |
239 | <class name="pt.estgp.estgweb.domain.CourseUnitEvaluation" table="courseunitevaluation" abstract="true"> |
||
240 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta> |
||
241 | <meta attribute="scope-class">public abstract</meta> |
||
242 | <id name="id" type="long"> |
||
243 | <generator class="native"/> |
||
244 | </id> |
||
245 | <discriminator column="discrimitator"/> |
||
246 | <timestamp source="db" name="updateDate" unsaved-value="null"/> |
||
247 | <property name="saveDate" type="timestamp"/> |
||
887 | jmachado | 248 | <property name="closed" type="boolean"/> |
1017 | jmachado | 249 | <!-- todo update aos do ano anterior para meter todos os evaluations salvos com teacherComplete = true --> |
1024 | jmachado | 250 | <property name="teacherComplete" type="boolean" index="teacherCompleteIndex"> |
1017 | jmachado | 251 | <column name="teacherComplete" default="true"/> |
252 | </property> |
||
881 | jmachado | 253 | <property name="numAlunosInscritos" type="text"/> |
254 | <property name="numAlunosSemElementosAvaliacao" type="integer"/> |
||
255 | |||
256 | <property name="numAlunosAprovFrequencia" type="integer"/> |
||
257 | <property name="numAlunosAprovNormal" type="integer"/> |
||
258 | <property name="numAlunosAprovRecurso" type="integer"/> |
||
259 | <property name="numAlunosAprovEspecial" type="integer"/> |
||
260 | <property name="numAlunosAprovTotal" type="integer"/> |
||
261 | |||
262 | <property name="numAlunosAprov1013" type="integer"/> |
||
263 | <property name="numAlunosAprov1416" type="integer"/> |
||
264 | <property name="numAlunosAprov1720" type="integer"/> |
||
265 | |||
266 | <property name="numAlunosAprovados" type="integer"/> |
||
267 | <property name="numAlunosReprovados" type="integer"/> |
||
268 | |||
269 | <property name="qualApreciacaoQuantitivos" type="text"/> |
||
270 | <property name="qualApreciacaoUC" type="text"/> |
||
271 | <property name="qualApreciacaoCumprimentoPrograma" type="text"/> |
||
272 | <property name="qualConclusoes" type="text"/> |
||
273 | |||
953 | jmachado | 274 | |
881 | jmachado | 275 | <subclass name="pt.estgp.estgweb.domain.CourseUnitEvaluationImpl" discriminator-value="CourseUnitEvaluationImpl"/> |
276 | </class> |
||
277 | |||
278 | |||
296 | jmachado | 279 | <!--<class name="pt.estgp.estgweb.domain.CourseUnit" table="courseunitassignement" abstract="true">--> |
226 | jmachado | 280 | <!--<meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>--> |
281 | <!--<meta attribute="scope-class">public abstract</meta>--> |
||
282 | <!--<id name="id" type="long">--> |
||
283 | <!--<generator class="native"/>--> |
||
284 | <!--</id>--> |
||
285 | <!--<discriminator column="discrimitator"/>--> |
||
690 | jmachado | 286 | <!--<timestamp source="db" name="updateDate" unsaved-value="null"/>--> |
226 | jmachado | 287 | <!--<property name="saveDate" type="timestamp"/>--> |
288 | <!--<property name="deliverDate" type="timestamp"/>--> |
||
289 | <!--<property name="deliverType" type="string"/>--> |
||
290 | <!--<property name="lateDelivers" type="boolean"/>--> |
||
291 | <!--<property name="title" type="string"/>--> |
||
292 | <!--<property name="description" type="text"/>--> |
||
293 | <!--<property name="repositoryStream" type="string" index="repositoryStreamIndex"/>--> |
||
294 | <!--<property name="status" type="boolean"/>--> |
||
295 | <!--<many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>--> |
||
296 | <!--<set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc">--> |
||
297 | <!--<key column="courseUnitAssignement"/>--> |
||
298 | <!--<one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/>--> |
||
299 | <!--</set>--> |
||
300 | <!--<subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/>--> |
||
301 | <!--</class>--> |
||
225 | jmachado | 302 | |
110 | susana | 303 | </hibernate-mapping> |