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