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