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