Subversion Repositories bacoAlunos

Rev

Rev 1830 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1314 jmachado 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>
7
    <class name="pt.estgp.estgweb.domain.Questionario" table="questionario" abstract="true">
8
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
9
        <meta attribute="scope-class">public abstract</meta>
1315 jmachado 10
        <id name="id" type="long" unsaved-value="0">
1314 jmachado 11
            <generator class="native"/>
12
        </id>
13
        <discriminator column="discriminator"/>
1549 jmachado 14
        <timestamp source="db"   name="updateDate" unsaved-value="null"/>
1314 jmachado 15
        <property name="saveDate" type="timestamp"/>
1325 jmachado 16
        <property name="description" type="string"/>
1333 jmachado 17
        <property name="logStates" type="text">
18
            <column name="logStates" sql-type="MEDIUMTEXT"/>
19
        </property>
1314 jmachado 20
        <property name="year" type="string"/>
21
        <property name="semestre" type="string"/>
1325 jmachado 22
        <property name="iAnswersProcessor" type="string"/>
1314 jmachado 23
        <property name="p1" type="string"/>
24
        <property name="p2" type="string"/>
25
        <property name="p3" type="string"/>
26
        <property name="p4" type="string"/>
27
        <property name="p5" type="string"/>
28
        <property name="p6" type="string"/>
29
        <property name="p7" type="string"/>
30
        <property name="p8" type="string"/>
31
        <property name="p9" type="string"/>
32
        <property name="p10" type="string"/>
33
        <property name="p11" type="string"/>
34
        <property name="p12" type="string"/>
35
        <property name="p13" type="string"/>
36
        <property name="p14" type="string"/>
37
        <property name="p15" type="string"/>
38
        <property name="p16" type="string"/>
39
        <property name="p17" type="string"/>
40
        <property name="p18" type="string"/>
41
        <property name="p19" type="string"/>
42
        <property name="p20" type="string"/>
43
        <property name="p21" type="string"/>
44
        <property name="p22" type="string"/>
45
        <property name="p23" type="string"/>
46
        <property name="p24" type="string"/>
47
        <property name="p25" type="string"/>
48
        <property name="p26" type="string"/>
49
        <property name="p27" type="string"/>
50
        <property name="p28" type="string"/>
51
        <property name="p29" type="string"/>
52
        <property name="p30" type="string"/>
1325 jmachado 53
        <property name="p31" type="string"/>
54
        <property name="p32" type="string"/>
55
        <property name="p33" type="string"/>
56
        <property name="p34" type="string"/>
57
        <property name="p35" type="string"/>
58
        <property name="p36" type="string"/>
59
        <property name="p37" type="string"/>
60
        <property name="p38" type="string"/>
61
        <property name="p39" type="string"/>
62
        <property name="p40" type="string"/>
1651 jmachado 63
 
1325 jmachado 64
        <property name="t1" type="string"/>
65
        <property name="t2" type="string"/>
66
        <property name="t3" type="string"/>
67
        <property name="t4" type="string"/>
68
        <property name="t5" type="string"/>
69
        <property name="t6" type="string"/>
70
        <property name="t7" type="string"/>
71
        <property name="t8" type="string"/>
72
        <property name="t9" type="string"/>
73
        <property name="t10" type="string"/>
1314 jmachado 74
 
1572 jmachado 75
        <property name="e1" type="string"/> <!--Perguntas de Esforço em Horas-->
76
        <property name="e2" type="string"/>
77
        <property name="e3" type="string"/>
78
        <property name="e4" type="string"/>
79
        <property name="e5" type="string"/>
80
        <property name="e6" type="string"/>
81
        <property name="e7" type="string"/>
82
        <property name="e8" type="string"/>
83
        <property name="e9" type="string"/>
84
        <property name="e10" type="string"/>
85
 
1651 jmachado 86
        <property name="p1Group" type="string">
87
            <column name="p1Group" sql-type="varchar(2)"/>
88
        </property>
89
        <property name="p2Group" type="string">
90
            <column name="p2Group" sql-type="varchar(2)"/>
91
        </property>
92
        <property name="p3Group" type="string">
93
            <column name="p3Group" sql-type="varchar(2)"/>
94
        </property>
95
        <property name="p4Group" type="string">
96
            <column name="p4Group" sql-type="varchar(2)"/>
97
        </property>
98
        <property name="p5Group" type="string">
99
            <column name="p5Group" sql-type="varchar(2)"/>
100
        </property>
101
        <property name="p6Group" type="string">
102
            <column name="p6Group" sql-type="varchar(2)"/>
103
        </property>
104
        <property name="p7Group" type="string">
105
            <column name="p7Group" sql-type="varchar(2)"/>
106
        </property>
107
        <property name="p8Group" type="string">
108
            <column name="p8Group" sql-type="varchar(2)"/>
109
        </property>
110
        <property name="p9Group" type="string">
111
            <column name="p9Group" sql-type="varchar(2)"/>
112
        </property>
113
        <property name="p10Group" type="string">
114
            <column name="p10Group" sql-type="varchar(2)"/>
115
        </property>
116
        <property name="p11Group" type="string">
117
            <column name="p11Group" sql-type="varchar(2)"/>
118
        </property>
119
        <property name="p12Group" type="string">
120
            <column name="p12Group" sql-type="varchar(2)"/>
121
        </property>
122
        <property name="p13Group" type="string">
123
            <column name="p13Group" sql-type="varchar(2)"/>
124
        </property>
125
        <property name="p14Group" type="string">
126
            <column name="p14Group" sql-type="varchar(2)"/>
127
        </property>
128
        <property name="p15Group" type="string">
129
            <column name="p15Group" sql-type="varchar(2)"/>
130
        </property>
131
        <property name="p16Group" type="string">
132
            <column name="p16Group" sql-type="varchar(2)"/>
133
        </property>
134
        <property name="p17Group" type="string">
135
            <column name="p17Group" sql-type="varchar(2)"/>
136
        </property>
137
        <property name="p18Group" type="string">
138
            <column name="p18Group" sql-type="varchar(2)"/>
139
        </property>
140
        <property name="p19Group" type="string">
141
            <column name="p19Group" sql-type="varchar(2)"/>
142
        </property>
143
        <property name="p20Group" type="string">
144
            <column name="p20Group" sql-type="varchar(2)"/>
145
        </property>
146
        <property name="p21Group" type="string">
147
            <column name="p21Group" sql-type="varchar(2)"/>
148
        </property>
149
        <property name="p22Group" type="string">
150
            <column name="p22Group" sql-type="varchar(2)"/>
151
        </property>
152
        <property name="p23Group" type="string">
153
            <column name="p23Group" sql-type="varchar(2)"/>
154
        </property>
155
        <property name="p24Group" type="string">
156
            <column name="p24Group" sql-type="varchar(2)"/>
157
        </property>
158
        <property name="p25Group" type="string">
159
            <column name="p25Group" sql-type="varchar(2)"/>
160
        </property>
161
        <property name="p26Group" type="string">
162
            <column name="p26Group" sql-type="varchar(2)"/>
163
        </property>
164
        <property name="p27Group" type="string">
165
            <column name="p27Group" sql-type="varchar(2)"/>
166
        </property>
167
        <property name="p28Group" type="string">
168
            <column name="p28Group" sql-type="varchar(2)"/>
169
        </property>
170
        <property name="p29Group" type="string">
171
            <column name="p29Group" sql-type="varchar(2)"/>
172
        </property>
173
        <property name="p30Group" type="string">
174
            <column name="p30Group" sql-type="varchar(2)"/>
175
        </property>
176
        <property name="p31Group" type="string">
177
            <column name="p31Group" sql-type="varchar(2)"/>
178
        </property>
179
        <property name="p32Group" type="string">
180
            <column name="p32Group" sql-type="varchar(2)"/>
181
        </property>
182
        <property name="p33Group" type="string">
183
            <column name="p33Group" sql-type="varchar(2)"/>
184
        </property>
185
        <property name="p34Group" type="string">
186
            <column name="p34Group" sql-type="varchar(2)"/>
187
        </property>
188
        <property name="p35Group" type="string">
189
            <column name="p35Group" sql-type="varchar(2)"/>
190
        </property>
191
        <property name="p36Group" type="string">
192
            <column name="p36Group" sql-type="varchar(2)"/>
193
        </property>
194
        <property name="p37Group" type="string">
195
            <column name="p37Group" sql-type="varchar(2)"/>
196
        </property>
197
        <property name="p38Group" type="string">
198
            <column name="p38Group" sql-type="varchar(2)"/>
199
        </property>
200
        <property name="p39Group" type="string">
201
            <column name="p39Group" sql-type="varchar(2)"/>
202
        </property>
203
        <property name="p40Group" type="string">
204
            <column name="p40Group" sql-type="varchar(2)"/>
205
        </property>
1619 jmachado 206
 
1651 jmachado 207
        <property name="t1Group" type="string">
208
            <column name="t1Group" sql-type="varchar(2)"/>
209
        </property>
210
        <property name="t2Group" type="string">
211
            <column name="t2Group" sql-type="varchar(2)"/>
212
        </property>
213
        <property name="t3Group" type="string">
214
            <column name="t3Group" sql-type="varchar(2)"/>
215
        </property>
216
        <property name="t4Group" type="string">
217
            <column name="t4Group" sql-type="varchar(2)"/>
218
        </property>
219
        <property name="t5Group" type="string">
220
            <column name="t5Group" sql-type="varchar(2)"/>
221
        </property>
222
        <property name="t6Group" type="string">
223
            <column name="t6Group" sql-type="varchar(2)"/>
224
        </property>
225
        <property name="t7Group" type="string">
226
            <column name="t7Group" sql-type="varchar(2)"/>
227
        </property>
228
        <property name="t8Group" type="string">
229
            <column name="t8Group" sql-type="varchar(2)"/>
230
        </property>
231
        <property name="t9Group" type="string">
232
            <column name="t9Group" sql-type="varchar(2)"/>
233
        </property>
234
        <property name="t10Group" type="string">
235
            <column name="t10Group" sql-type="varchar(2)"/>
236
        </property>
1314 jmachado 237
 
1651 jmachado 238
        <property name="e1Group" type="string">
239
            <column name="e1Group" sql-type="varchar(2)"/>
240
        </property>
241
        <property name="e2Group" type="string">
242
            <column name="e2Group" sql-type="varchar(2)"/>
243
        </property>
244
        <property name="e3Group" type="string">
245
            <column name="e3Group" sql-type="varchar(2)"/>
246
        </property>
247
        <property name="e4Group" type="string">
248
            <column name="e4Group" sql-type="varchar(2)"/>
249
        </property>
250
        <property name="e5Group" type="string">
251
            <column name="e5Group" sql-type="varchar(2)"/>
252
        </property>
253
        <property name="e6Group" type="string">
254
            <column name="e6Group" sql-type="varchar(2)"/>
255
        </property>
256
        <property name="e7Group" type="string">
257
            <column name="e7Group" sql-type="varchar(2)"/>
258
        </property>
259
        <property name="e8Group" type="string">
260
            <column name="e8Group" sql-type="varchar(2)"/>
261
        </property>
262
        <property name="e9Group" type="string">
263
            <column name="e9Group" sql-type="varchar(2)"/>
264
        </property>
265
        <property name="e10Group" type="string">
266
            <column name="e10Group" sql-type="varchar(2)"/>
267
        </property>
1572 jmachado 268
 
1619 jmachado 269
 
270
 
271
        <property name="p1Section" type="string">
272
            <column name="p1Section" sql-type="TEXT"/>
273
        </property>
274
        <property name="p2Section" type="string">
275
            <column name="p2Section" sql-type="TEXT"/>
276
        </property>
277
        <property name="p3Section" type="string">
278
            <column name="p3Section" sql-type="TEXT"/>
279
        </property>
280
        <property name="p4Section" type="string">
281
            <column name="p4Section" sql-type="TEXT"/>
282
        </property>
283
        <property name="p5Section" type="string">
284
            <column name="p5Section" sql-type="TEXT"/>
285
        </property>
286
        <property name="p6Section" type="string">
287
            <column name="p6Section" sql-type="TEXT"/>
288
        </property>
289
        <property name="p7Section" type="string">
290
            <column name="p7Section" sql-type="TEXT"/>
291
        </property>
292
        <property name="p8Section" type="string">
293
            <column name="p8Section" sql-type="TEXT"/>
294
        </property>
295
        <property name="p9Section" type="string">
296
            <column name="p9Section" sql-type="TEXT"/>
297
        </property>
298
        <property name="p10Section" type="string">
299
            <column name="p10Section" sql-type="TEXT"/>
300
        </property>
301
        <property name="p11Section" type="string">
302
            <column name="p11Section" sql-type="TEXT"/>
303
        </property>
304
        <property name="p12Section" type="string">
305
            <column name="p12Section" sql-type="TEXT"/>
306
        </property>
307
        <property name="p13Section" type="string">
308
            <column name="p13Section" sql-type="TEXT"/>
309
        </property>
310
        <property name="p14Section" type="string">
311
            <column name="p14Section" sql-type="TEXT"/>
312
        </property>
313
        <property name="p15Section" type="string">
314
            <column name="p15Section" sql-type="TEXT"/>
315
        </property>
316
        <property name="p16Section" type="string">
317
            <column name="p16Section" sql-type="TEXT"/>
318
        </property>
319
        <property name="p17Section" type="string">
320
            <column name="p17Section" sql-type="TEXT"/>
321
        </property>
322
        <property name="p18Section" type="string">
323
            <column name="p18Section" sql-type="TEXT"/>
324
        </property>
325
        <property name="p19Section" type="string">
326
            <column name="p19Section" sql-type="TEXT"/>
327
        </property>
328
        <property name="p20Section" type="string">
329
            <column name="p20Section" sql-type="TEXT"/>
330
        </property>
331
        <property name="p21Section" type="string">
332
            <column name="p21Section" sql-type="TEXT"/>
333
        </property>
334
        <property name="p22Section" type="string">
335
            <column name="p22Section" sql-type="TEXT"/>
336
        </property>
337
        <property name="p23Section" type="string">
338
            <column name="p23Section" sql-type="TEXT"/>
339
        </property>
340
        <property name="p24Section" type="string">
341
            <column name="p24Section" sql-type="TEXT"/>
342
        </property>
343
        <property name="p25Section" type="string">
344
            <column name="p25Section" sql-type="TEXT"/>
345
        </property>
346
        <property name="p26Section" type="string">
347
            <column name="p26Section" sql-type="TEXT"/>
348
        </property>
349
        <property name="p27Section" type="string">
350
            <column name="p27Section" sql-type="TEXT"/>
351
        </property>
352
        <property name="p28Section" type="string">
353
            <column name="p28Section" sql-type="TEXT"/>
354
        </property>
355
        <property name="p29Section" type="string">
356
            <column name="p29Section" sql-type="TEXT"/>
357
        </property>
358
        <property name="p30Section" type="string">
359
            <column name="p30Section" sql-type="TEXT"/>
360
        </property>
361
        <property name="p31Section" type="string">
362
            <column name="p31Section" sql-type="TEXT"/>
363
        </property>
364
        <property name="p32Section" type="string">
365
            <column name="p32Section" sql-type="TEXT"/>
366
        </property>
367
        <property name="p33Section" type="string">
368
            <column name="p33Section" sql-type="TEXT"/>
369
        </property>
370
        <property name="p34Section" type="string">
371
            <column name="p34Section" sql-type="TEXT"/>
372
        </property>
373
        <property name="p35Section" type="string">
374
            <column name="p35Section" sql-type="TEXT"/>
375
        </property>
376
        <property name="p36Section" type="string">
377
            <column name="p36Section" sql-type="TEXT"/>
378
        </property>
379
        <property name="p37Section" type="string">
380
            <column name="p37Section" sql-type="TEXT"/>
381
        </property>
382
        <property name="p38Section" type="string">
383
            <column name="p38Section" sql-type="TEXT"/>
384
        </property>
385
        <property name="p39Section" type="string">
386
            <column name="p39Section" sql-type="TEXT"/>
387
        </property>
388
        <property name="p40Section" type="string">
389
            <column name="p40Section" sql-type="TEXT"/>
390
        </property>
391
 
392
 
393
        <property name="t1Section" type="string">
394
            <column name="t1Section" sql-type="TEXT"/>
395
        </property>
396
        <property name="t2Section" type="string">
397
            <column name="t2Section" sql-type="TEXT"/>
398
        </property>
399
        <property name="t3Section" type="string">
400
            <column name="t3Section" sql-type="TEXT"/>
401
        </property>
402
        <property name="t4Section" type="string">
403
            <column name="t4Section" sql-type="TEXT"/>
404
        </property>
405
        <property name="t5Section" type="string">
406
            <column name="t5Section" sql-type="TEXT"/>
407
        </property>
408
        <property name="t6Section" type="string">
409
            <column name="t6Section" sql-type="TEXT"/>
410
        </property>
411
        <property name="t7Section" type="string">
412
            <column name="t7Section" sql-type="TEXT"/>
413
        </property>
414
        <property name="t8Section" type="string">
415
            <column name="t8Section" sql-type="TEXT"/>
416
        </property>
417
        <property name="t9Section" type="string">
418
            <column name="t9Section" sql-type="TEXT"/>
419
        </property>
420
        <property name="t10Section" type="string">
421
            <column name="t10Section" sql-type="TEXT"/>
422
        </property>
423
 
424
        <property name="e1Section" type="string">
425
            <column name="e1Section" sql-type="TEXT"/>
426
        </property>
427
        <property name="e2Section" type="string">
428
            <column name="e2Section" sql-type="TEXT"/>
429
        </property>
430
        <property name="e3Section" type="string">
431
            <column name="e3Section" sql-type="TEXT"/>
432
        </property>
433
        <property name="e4Section" type="string">
434
            <column name="e4Section" sql-type="TEXT"/>
435
        </property>
436
        <property name="e5Section" type="string">
437
            <column name="e5Section" sql-type="TEXT"/>
438
        </property>
439
        <property name="e6Section" type="string">
440
            <column name="e6Section" sql-type="TEXT"/>
441
        </property>
442
        <property name="e7Section" type="string">
443
            <column name="e7Section" sql-type="TEXT"/>
444
        </property>
445
        <property name="e8Section" type="string">
446
            <column name="e8Section" sql-type="TEXT"/>
447
        </property>
448
        <property name="e9Section" type="string">
449
            <column name="e9Section" sql-type="TEXT"/>
450
        </property>
451
        <property name="e10Section" type="string">
452
            <column name="e10Section" sql-type="TEXT"/>
453
        </property>
454
 
455
 
456
 
1650 jmachado 457
        <property name="p1SubGroup" type="string">
1651 jmachado 458
            <column name="p1SubGroup" sql-type="varchar(2)"/>
1650 jmachado 459
        </property>
460
        <property name="p2SubGroup" type="string">
1651 jmachado 461
            <column name="p2SubGroup" sql-type="varchar(2)"/>
1650 jmachado 462
        </property>
463
        <property name="p3SubGroup" type="string">
1651 jmachado 464
            <column name="p3SubGroup" sql-type="varchar(2)"/>
1650 jmachado 465
        </property>
466
        <property name="p4SubGroup" type="string">
1651 jmachado 467
            <column name="p4SubGroup" sql-type="varchar(2)"/>
1650 jmachado 468
        </property>
469
        <property name="p5SubGroup" type="string">
1651 jmachado 470
            <column name="p5SubGroup" sql-type="varchar(2)"/>
1650 jmachado 471
        </property>
472
        <property name="p6SubGroup" type="string">
1651 jmachado 473
            <column name="p6SubGroup" sql-type="varchar(2)"/>
1650 jmachado 474
        </property>
475
        <property name="p7SubGroup" type="string">
1651 jmachado 476
            <column name="p7SubGroup" sql-type="varchar(2)"/>
1650 jmachado 477
        </property>
478
        <property name="p8SubGroup" type="string">
1651 jmachado 479
            <column name="p8SubGroup" sql-type="varchar(2)"/>
1650 jmachado 480
        </property>
481
        <property name="p9SubGroup" type="string">
1651 jmachado 482
            <column name="p9SubGroup" sql-type="varchar(2)"/>
1650 jmachado 483
        </property>
484
        <property name="p10SubGroup" type="string">
1651 jmachado 485
            <column name="p10SubGroup" sql-type="varchar(2)"/>
1650 jmachado 486
        </property>
487
        <property name="p11SubGroup" type="string">
1651 jmachado 488
            <column name="p11SubGroup" sql-type="varchar(2)"/>
1650 jmachado 489
        </property>
490
        <property name="p12SubGroup" type="string">
1651 jmachado 491
            <column name="p12SubGroup" sql-type="varchar(2)"/>
1650 jmachado 492
        </property>
493
        <property name="p13SubGroup" type="string">
1651 jmachado 494
            <column name="p13SubGroup" sql-type="varchar(2)"/>
1650 jmachado 495
        </property>
496
        <property name="p14SubGroup" type="string">
1651 jmachado 497
            <column name="p14SubGroup" sql-type="varchar(2)"/>
1650 jmachado 498
        </property>
499
        <property name="p15SubGroup" type="string">
1651 jmachado 500
            <column name="p15SubGroup" sql-type="varchar(2)"/>
1650 jmachado 501
        </property>
502
        <property name="p16SubGroup" type="string">
1651 jmachado 503
            <column name="p16SubGroup" sql-type="varchar(2)"/>
1650 jmachado 504
        </property>
505
        <property name="p17SubGroup" type="string">
1651 jmachado 506
            <column name="p17SubGroup" sql-type="varchar(2)"/>
1650 jmachado 507
        </property>
508
        <property name="p18SubGroup" type="string">
1651 jmachado 509
            <column name="p18SubGroup" sql-type="varchar(2)"/>
1650 jmachado 510
        </property>
511
        <property name="p19SubGroup" type="string">
1651 jmachado 512
            <column name="p19SubGroup" sql-type="varchar(2)"/>
1650 jmachado 513
        </property>
514
        <property name="p20SubGroup" type="string">
1651 jmachado 515
            <column name="p20SubGroup" sql-type="varchar(2)"/>
1650 jmachado 516
        </property>
517
        <property name="p21SubGroup" type="string">
1651 jmachado 518
            <column name="p21SubGroup" sql-type="varchar(2)"/>
1650 jmachado 519
        </property>
520
        <property name="p22SubGroup" type="string">
1651 jmachado 521
            <column name="p22SubGroup" sql-type="varchar(2)"/>
1650 jmachado 522
        </property>
523
        <property name="p23SubGroup" type="string">
1651 jmachado 524
            <column name="p23SubGroup" sql-type="varchar(2)"/>
1650 jmachado 525
        </property>
526
        <property name="p24SubGroup" type="string">
1651 jmachado 527
            <column name="p24SubGroup" sql-type="varchar(2)"/>
1650 jmachado 528
        </property>
529
        <property name="p25SubGroup" type="string">
1651 jmachado 530
            <column name="p25SubGroup" sql-type="varchar(2)"/>
1650 jmachado 531
        </property>
532
        <property name="p26SubGroup" type="string">
1651 jmachado 533
            <column name="p26SubGroup" sql-type="varchar(2)"/>
1650 jmachado 534
        </property>
535
        <property name="p27SubGroup" type="string">
1651 jmachado 536
            <column name="p27SubGroup" sql-type="varchar(2)"/>
1650 jmachado 537
        </property>
538
        <property name="p28SubGroup" type="string">
1651 jmachado 539
            <column name="p28SubGroup" sql-type="varchar(2)"/>
1650 jmachado 540
        </property>
541
        <property name="p29SubGroup" type="string">
1651 jmachado 542
            <column name="p29SubGroup" sql-type="varchar(2)"/>
1650 jmachado 543
        </property>
544
        <property name="p30SubGroup" type="string">
1651 jmachado 545
            <column name="p30SubGroup" sql-type="varchar(2)"/>
1650 jmachado 546
        </property>
547
        <property name="p31SubGroup" type="string">
1651 jmachado 548
            <column name="p31SubGroup" sql-type="varchar(2)"/>
1650 jmachado 549
        </property>
550
        <property name="p32SubGroup" type="string">
1651 jmachado 551
            <column name="p32SubGroup" sql-type="varchar(2)"/>
1650 jmachado 552
        </property>
553
        <property name="p33SubGroup" type="string">
1651 jmachado 554
            <column name="p33SubGroup" sql-type="varchar(2)"/>
1650 jmachado 555
        </property>
556
        <property name="p34SubGroup" type="string">
1651 jmachado 557
            <column name="p34SubGroup" sql-type="varchar(2)"/>
1650 jmachado 558
        </property>
559
        <property name="p35SubGroup" type="string">
1651 jmachado 560
            <column name="p35SubGroup" sql-type="varchar(2)"/>
1650 jmachado 561
        </property>
562
        <property name="p36SubGroup" type="string">
1651 jmachado 563
            <column name="p36SubGroup" sql-type="varchar(2)"/>
1650 jmachado 564
        </property>
565
        <property name="p37SubGroup" type="string">
1651 jmachado 566
            <column name="p37SubGroup" sql-type="varchar(2)"/>
1650 jmachado 567
        </property>
568
        <property name="p38SubGroup" type="string">
1651 jmachado 569
            <column name="p38SubGroup" sql-type="varchar(2)"/>
1650 jmachado 570
        </property>
571
        <property name="p39SubGroup" type="string">
1651 jmachado 572
            <column name="p39SubGroup" sql-type="varchar(2)"/>
1650 jmachado 573
        </property>
574
        <property name="p40SubGroup" type="string">
1651 jmachado 575
            <column name="p40SubGroup" sql-type="varchar(2)"/>
1650 jmachado 576
        </property>
577
        <property name="t1SubGroup" type="string">
1651 jmachado 578
            <column name="t1SubGroup" sql-type="varchar(2)"/>
1650 jmachado 579
        </property>
580
        <property name="t2SubGroup" type="string">
1651 jmachado 581
            <column name="t2SubGroup" sql-type="varchar(2)"/>
1650 jmachado 582
        </property>
583
        <property name="t3SubGroup" type="string">
1651 jmachado 584
            <column name="t3SubGroup" sql-type="varchar(2)"/>
1650 jmachado 585
        </property>
586
        <property name="t4SubGroup" type="string">
1651 jmachado 587
            <column name="t4SubGroup" sql-type="varchar(2)"/>
1650 jmachado 588
        </property>
589
        <property name="t5SubGroup" type="string">
1651 jmachado 590
            <column name="t5SubGroup" sql-type="varchar(2)"/>
1650 jmachado 591
        </property>
592
        <property name="t6SubGroup" type="string">
1651 jmachado 593
            <column name="t6SubGroup" sql-type="varchar(2)"/>
1650 jmachado 594
        </property>
595
        <property name="t7SubGroup" type="string">
1651 jmachado 596
            <column name="t7SubGroup" sql-type="varchar(2)"/>
1650 jmachado 597
        </property>
598
        <property name="t8SubGroup" type="string">
1651 jmachado 599
            <column name="t8SubGroup" sql-type="varchar(2)"/>
1650 jmachado 600
        </property>
601
        <property name="t9SubGroup" type="string">
1651 jmachado 602
            <column name="t9SubGroup" sql-type="varchar(2)"/>
1650 jmachado 603
        </property>
604
        <property name="t10SubGroup" type="string">
1651 jmachado 605
            <column name="t10SubGroup" sql-type="varchar(2)"/>
1650 jmachado 606
        </property>
607
        <property name="e1SubGroup" type="string">
1651 jmachado 608
            <column name="e1SubGroup" sql-type="varchar(2)"/>
1650 jmachado 609
        </property>
610
        <property name="e2SubGroup" type="string">
1651 jmachado 611
            <column name="e2SubGroup" sql-type="varchar(2)"/>
1650 jmachado 612
        </property>
613
        <property name="e3SubGroup" type="string">
1651 jmachado 614
            <column name="e3SubGroup" sql-type="varchar(2)"/>
1650 jmachado 615
        </property>
616
        <property name="e4SubGroup" type="string">
1651 jmachado 617
            <column name="e4SubGroup" sql-type="varchar(2)"/>
1650 jmachado 618
        </property>
619
        <property name="e5SubGroup" type="string">
1651 jmachado 620
            <column name="e5SubGroup" sql-type="varchar(2)"/>
1650 jmachado 621
        </property>
622
        <property name="e6SubGroup" type="string">
1651 jmachado 623
            <column name="e6SubGroup" sql-type="varchar(2)"/>
1650 jmachado 624
        </property>
625
        <property name="e7SubGroup" type="string">
1651 jmachado 626
            <column name="e7SubGroup" sql-type="varchar(2)"/>
1650 jmachado 627
        </property>
628
        <property name="e8SubGroup" type="string">
1651 jmachado 629
            <column name="e8SubGroup" sql-type="varchar(2)"/>
1650 jmachado 630
        </property>
631
        <property name="e9SubGroup" type="string">
1651 jmachado 632
            <column name="e9SubGroup" sql-type="varchar(2)"/>
1650 jmachado 633
        </property>
634
        <property name="e10SubGroup" type="string">
1651 jmachado 635
            <column name="e10SubGroup" sql-type="varchar(2)"/>
1650 jmachado 636
        </property>
1563 jmachado 637
 
1314 jmachado 638
        <property name="introHtml" type="string">
639
            <column name="introHtml" sql-type="text"/>
640
        </property>
641
 
642
        <property name="group1Title" type="string">
643
            <column name="group1Title" sql-type="text"/>
644
        </property>
645
        <property name="group2Title" type="string">
646
            <column name="group2Title" sql-type="text"/>
647
        </property>
648
        <property name="group3Title" type="string">
649
            <column name="group3Title" sql-type="text"/>
650
        </property>
651
        <property name="group4Title" type="string">
652
            <column name="group4Title" sql-type="text"/>
653
        </property>
654
        <property name="group5Title" type="string">
655
            <column name="group5Title" sql-type="text"/>
656
        </property>
1325 jmachado 657
        <property name="group6Title" type="string">
658
            <column name="group6Title" sql-type="text"/>
659
        </property>
660
        <property name="group7Title" type="string">
661
            <column name="group7Title" sql-type="text"/>
662
        </property>
663
        <property name="group8Title" type="string">
664
            <column name="group8Title" sql-type="text"/>
665
        </property>
666
        <property name="group9Title" type="string">
667
            <column name="group9Title" sql-type="text"/>
668
        </property>
669
        <property name="group10Title" type="string">
670
            <column name="group10Title" sql-type="text"/>
671
        </property>
1314 jmachado 672
 
673
 
1325 jmachado 674
        <property name="group1Code" type="string"/>
675
        <property name="group2Code" type="string"/>
676
        <property name="group3Code" type="string"/>
677
        <property name="group4Code" type="string"/>
678
        <property name="group5Code" type="string"/>
679
        <property name="group6Code" type="string"/>
680
        <property name="group7Code" type="string"/>
681
        <property name="group8Code" type="string"/>
682
        <property name="group9Code" type="string"/>
683
        <property name="group10Code" type="string"/>
1314 jmachado 684
 
685
 
1325 jmachado 686
 
687
 
688
 
1314 jmachado 689
        <!--State flow info-->
690
        <!--
691
            Possible states:
692
            CREATED   -> in prototype edition
693
            ASSIGNED -> All tipologies prototypes created and assigned to student answers
694
            PROCESSING -> Impossible to change or edit prototypes, possible to answer
695
            CLOSED -> Impossible to answer
696
            STATISTICS1
697
        -->
698
        <property name="state" type="string">
699
            <column name="state" default="'CREATED'"/>
700
        </property>
1327 jmachado 701
        <property name="substate" type="string"/>
1314 jmachado 702
 
1337 jmachado 703
        <property name="answerGenerationTaskId" type="long">
704
            <column name="answer_generation_task_id" default="0"/>
705
        </property>
706
 
1544 jmachado 707
        <property name="answerOlapGenerationTaskId" type="long">
708
            <column name="answer_olap_generation_task_id" default="0"/>
709
        </property>
710
 
1327 jmachado 711
        <!--Modulo de Pedagogico-->
712
        <property name="courseSelectionTaskId" type="long">
713
            <column name="course_selection_task_id" default="0"/>
714
        </property>
715
        <!--Modulo de Pedagogico-->
716
 
1325 jmachado 717
        <many-to-one name="questionarioHistoryDrive" class="pt.estgp.estgweb.domain.QuestionarioHistoryDrive" lazy="proxy" outer-join="false"/>
718
 
1314 jmachado 719
        <subclass name="pt.estgp.estgweb.domain.QuestionarioImpl" discriminator-value="QuestionarioImpl"/>
720
    </class>
721
 
1325 jmachado 722
    <class name="pt.estgp.estgweb.domain.QuestionarioHistoryDrive" table="questionario_history_drive" abstract="true">
723
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
724
        <meta attribute="scope-class">public abstract</meta>
725
        <id name="id" type="long" unsaved-value="0">
726
            <generator class="native"/>
727
        </id>
728
        <discriminator column="discriminator"/>
1549 jmachado 729
        <timestamp source="db"   name="updateDate" unsaved-value="null"/>
1325 jmachado 730
        <property name="saveDate" type="timestamp"/>
731
        <property name="codeName" type="string" unique="true"/>
732
        <property name="description" type="string"/>
733
        <subclass name="pt.estgp.estgweb.domain.QuestionarioHistoryDriveImpl" discriminator-value="QuestionarioHistoryDriveImpl"/>
734
    </class>
735
 
1330 jmachado 736
 
737
    <class name="pt.estgp.estgweb.domain.QuestionarioRespostaRequisitada" table="questionario_resposta_requisitada" abstract="true">
738
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
739
        <meta attribute="scope-class">public abstract</meta>
740
        <id name="id" type="long" unsaved-value="0">
741
            <generator class="native"/>
742
        </id>
743
        <discriminator column="discriminator"/>
744
        <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" lazy="proxy" outer-join="false"/>
745
        <many-to-one name="user" class="pt.estgp.estgweb.domain.User" lazy="proxy" outer-join="false"/>
746
        <many-to-one name="resposta" class="pt.estgp.estgweb.domain.QuestionarioResposta" lazy="false" outer-join="true"/>
747
        <subclass name="pt.estgp.estgweb.domain.QuestionarioRespostaRequisitadaImpl" discriminator-value="QuestionarioRespostaRequisitadaImpl"/>
748
    </class>
749
 
750
    <class name="pt.estgp.estgweb.domain.QuestionarioResposta" table="questionario_resposta" abstract="true">
751
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
752
        <meta attribute="scope-class">public abstract</meta>
753
        <id name="id" type="long" unsaved-value="0">
754
            <generator class="native"/>
755
        </id>
756
        <discriminator column="discriminator"/>
1331 jmachado 757
 
758
        <property name="saveDate" type="timestamp"/>
759
 
1411 jmachado 760
        <property name="timeStart" type="long"/>
761
        <property name="timeEnd" type="long"/>
1331 jmachado 762
        <property name="totalTime" type="long"/>
763
 
764
 
765
        <property name="r1" type="string"/>
766
        <property name="r2" type="string"/>
767
        <property name="r3" type="string"/>
768
        <property name="r4" type="string"/>
769
        <property name="r5" type="string"/>
770
        <property name="r6" type="string"/>
771
        <property name="r7" type="string"/>
772
        <property name="r8" type="string"/>
773
        <property name="r9" type="string"/>
774
        <property name="r10" type="string"/>
775
        <property name="r11" type="string"/>
776
        <property name="r12" type="string"/>
777
        <property name="r13" type="string"/>
778
        <property name="r14" type="string"/>
779
        <property name="r15" type="string"/>
780
        <property name="r16" type="string"/>
781
        <property name="r17" type="string"/>
782
        <property name="r18" type="string"/>
783
        <property name="r19" type="string"/>
784
        <property name="r20" type="string"/>
785
        <property name="r21" type="string"/>
786
        <property name="r22" type="string"/>
787
        <property name="r23" type="string"/>
788
        <property name="r24" type="string"/>
789
        <property name="r25" type="string"/>
790
        <property name="r26" type="string"/>
791
        <property name="r27" type="string"/>
792
        <property name="r28" type="string"/>
793
        <property name="r29" type="string"/>
794
        <property name="r30" type="string"/>
795
        <property name="r31" type="string"/>
796
        <property name="r32" type="string"/>
797
        <property name="r33" type="string"/>
798
        <property name="r34" type="string"/>
799
        <property name="r35" type="string"/>
800
        <property name="r36" type="string"/>
801
        <property name="r37" type="string"/>
802
        <property name="r38" type="string"/>
803
        <property name="r39" type="string"/>
804
        <property name="r40" type="string"/>
805
 
806
        <property name="rt1" type="string"/>
807
        <property name="rt2" type="string"/>
808
        <property name="rt3" type="string"/>
809
        <property name="rt4" type="string"/>
810
        <property name="rt5" type="string"/>
811
        <property name="rt6" type="string"/>
812
        <property name="rt7" type="string"/>
813
        <property name="rt8" type="string"/>
814
        <property name="rt9" type="string"/>
815
        <property name="rt10" type="string"/>
816
 
1572 jmachado 817
        <property name="re1" type="string"/>
818
        <property name="re2" type="string"/>
819
        <property name="re3" type="string"/>
820
        <property name="re4" type="string"/>
821
        <property name="re5" type="string"/>
822
        <property name="re6" type="string"/>
823
        <property name="re7" type="string"/>
824
        <property name="re8" type="string"/>
825
        <property name="re9" type="string"/>
826
        <property name="re10" type="string"/>
1331 jmachado 827
 
1572 jmachado 828
 
1331 jmachado 829
        <!--Tempo levado para responder-->
830
        <property name="timeTakenR1" type="long"/>
831
        <property name="timeTakenR2" type="long"/>
832
        <property name="timeTakenR3" type="long"/>
833
        <property name="timeTakenR4" type="long"/>
834
        <property name="timeTakenR5" type="long"/>
835
        <property name="timeTakenR6" type="long"/>
836
        <property name="timeTakenR7" type="long"/>
837
        <property name="timeTakenR8" type="long"/>
838
        <property name="timeTakenR9" type="long"/>
839
        <property name="timeTakenR10" type="long"/>
840
        <property name="timeTakenR11" type="long"/>
841
        <property name="timeTakenR12" type="long"/>
842
        <property name="timeTakenR13" type="long"/>
843
        <property name="timeTakenR14" type="long"/>
844
        <property name="timeTakenR15" type="long"/>
845
        <property name="timeTakenR16" type="long"/>
846
        <property name="timeTakenR17" type="long"/>
847
        <property name="timeTakenR18" type="long"/>
848
        <property name="timeTakenR19" type="long"/>
849
        <property name="timeTakenR20" type="long"/>
850
        <property name="timeTakenR21" type="long"/>
851
        <property name="timeTakenR22" type="long"/>
852
        <property name="timeTakenR23" type="long"/>
853
        <property name="timeTakenR24" type="long"/>
854
        <property name="timeTakenR25" type="long"/>
855
        <property name="timeTakenR26" type="long"/>
856
        <property name="timeTakenR27" type="long"/>
857
        <property name="timeTakenR28" type="long"/>
858
        <property name="timeTakenR29" type="long"/>
859
        <property name="timeTakenR30" type="long"/>
860
        <property name="timeTakenR31" type="long"/>
861
        <property name="timeTakenR32" type="long"/>
862
        <property name="timeTakenR33" type="long"/>
863
        <property name="timeTakenR34" type="long"/>
864
        <property name="timeTakenR35" type="long"/>
865
        <property name="timeTakenR36" type="long"/>
866
        <property name="timeTakenR37" type="long"/>
867
        <property name="timeTakenR38" type="long"/>
868
        <property name="timeTakenR39" type="long"/>
869
        <property name="timeTakenR40" type="long"/>
870
 
871
        <property name="timeTakenRt1" type="long"/>
872
        <property name="timeTakenRt2" type="long"/>
873
        <property name="timeTakenRt3" type="long"/>
874
        <property name="timeTakenRt4" type="long"/>
875
        <property name="timeTakenRt5" type="long"/>
876
        <property name="timeTakenRt6" type="long"/>
877
        <property name="timeTakenRt7" type="long"/>
878
        <property name="timeTakenRt8" type="long"/>
879
        <property name="timeTakenRt9" type="long"/>
880
        <property name="timeTakenRt10" type="long"/>
881
 
1572 jmachado 882
        <property name="timeTakenRe1" type="long"/>
883
        <property name="timeTakenRe2" type="long"/>
884
        <property name="timeTakenRe3" type="long"/>
885
        <property name="timeTakenRe4" type="long"/>
886
        <property name="timeTakenRe5" type="long"/>
887
        <property name="timeTakenRe6" type="long"/>
888
        <property name="timeTakenRe7" type="long"/>
889
        <property name="timeTakenRe8" type="long"/>
890
        <property name="timeTakenRe9" type="long"/>
891
        <property name="timeTakenRe10" type="long"/>
892
 
1331 jmachado 893
        <!--Hora do Clique-->
1411 jmachado 894
        <property name="timeEventR1" type="long"/>
895
        <property name="timeEventR2" type="long"/>
896
        <property name="timeEventR3" type="long"/>
897
        <property name="timeEventR4" type="long"/>
898
        <property name="timeEventR5" type="long"/>
899
        <property name="timeEventR6" type="long"/>
900
        <property name="timeEventR7" type="long"/>
901
        <property name="timeEventR8" type="long"/>
902
        <property name="timeEventR9" type="long"/>
903
        <property name="timeEventR10" type="long"/>
904
        <property name="timeEventR11" type="long"/>
905
        <property name="timeEventR12" type="long"/>
906
        <property name="timeEventR13" type="long"/>
907
        <property name="timeEventR14" type="long"/>
908
        <property name="timeEventR15" type="long"/>
909
        <property name="timeEventR16" type="long"/>
910
        <property name="timeEventR17" type="long"/>
911
        <property name="timeEventR18" type="long"/>
912
        <property name="timeEventR19" type="long"/>
913
        <property name="timeEventR20" type="long"/>
914
        <property name="timeEventR21" type="long"/>
915
        <property name="timeEventR22" type="long"/>
916
        <property name="timeEventR23" type="long"/>
917
        <property name="timeEventR24" type="long"/>
918
        <property name="timeEventR25" type="long"/>
919
        <property name="timeEventR26" type="long"/>
920
        <property name="timeEventR27" type="long"/>
921
        <property name="timeEventR28" type="long"/>
922
        <property name="timeEventR29" type="long"/>
923
        <property name="timeEventR30" type="long"/>
924
        <property name="timeEventR31" type="long"/>
925
        <property name="timeEventR32" type="long"/>
926
        <property name="timeEventR33" type="long"/>
927
        <property name="timeEventR34" type="long"/>
928
        <property name="timeEventR35" type="long"/>
929
        <property name="timeEventR36" type="long"/>
930
        <property name="timeEventR37" type="long"/>
931
        <property name="timeEventR38" type="long"/>
932
        <property name="timeEventR39" type="long"/>
933
        <property name="timeEventR40" type="long"/>
1331 jmachado 934
 
935
        <property name="timeEventRt1" type="long"/>
936
        <property name="timeEventRt2" type="long"/>
937
        <property name="timeEventRt3" type="long"/>
938
        <property name="timeEventRt4" type="long"/>
939
        <property name="timeEventRt5" type="long"/>
940
        <property name="timeEventRt6" type="long"/>
941
        <property name="timeEventRt7" type="long"/>
942
        <property name="timeEventRt8" type="long"/>
943
        <property name="timeEventRt9" type="long"/>
944
        <property name="timeEventRt10" type="long"/>
945
 
1572 jmachado 946
        <property name="timeEventRe1" type="long"/>
947
        <property name="timeEventRe2" type="long"/>
948
        <property name="timeEventRe3" type="long"/>
949
        <property name="timeEventRe4" type="long"/>
950
        <property name="timeEventRe5" type="long"/>
951
        <property name="timeEventRe6" type="long"/>
952
        <property name="timeEventRe7" type="long"/>
953
        <property name="timeEventRe8" type="long"/>
954
        <property name="timeEventRe9" type="long"/>
955
        <property name="timeEventRe10" type="long"/>
956
 
1330 jmachado 957
        <many-to-one name="user" class="pt.estgp.estgweb.domain.User" lazy="proxy" outer-join="false"/>
1404 jmachado 958
        <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" lazy="proxy" outer-join="false"/>
1330 jmachado 959
        <subclass name="pt.estgp.estgweb.domain.QuestionarioRespostaImpl" discriminator-value="QuestionarioRespostaImpl"/>
960
    </class>
961
 
962
    <!--PEDAGOGICO QUESTIONARIO ATRIBUICOES-->
963
 
1336 jmachado 964
    <class name="pt.estgp.estgweb.domain.QuestionarioPedagogicoTipologiaRequisitada" table="questionario_peda_tipologia_requisitada" abstract="true">
1330 jmachado 965
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
966
        <meta attribute="scope-class">public abstract</meta>
967
        <id name="id" type="long" unsaved-value="0">
968
            <generator class="native"/>
969
        </id>
970
        <discriminator column="discriminator"/>
1549 jmachado 971
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1330 jmachado 972
        <property name="saveDate" type="timestamp"/>
1336 jmachado 973
        <property name="cdDocente" type="string"/>
974
        <property name="cdTurma" type="string"/>
975
        <property name="cdTipologia" type="string"/>
976
        <property name="nomeDocente" type="string" />
977
        <property name="dsTipologia" type="string"/>
1387 jmachado 978
        <many-to-one name="docenteAfeto" class="pt.estgp.estgweb.domain.Teacher" lazy="proxy" outer-join="false" column="professor_afeto"/>
979
        <many-to-one name="turmaAfeta" class="pt.estgp.estgweb.domain.CourseUnitTurma" lazy="proxy" outer-join="false" column="turma_afeta"/>
1336 jmachado 980
        <many-to-one name="unidadeAfeta" class="pt.estgp.estgweb.domain.QuestionarioPedagogicoUnidadeCurricularAfeta" lazy="proxy" outer-join="false" column="unidade_afeta"/>
981
        <set name="alunosRequisitados" lazy="true">
982
            <key column="tipologia_requisitada"/>
983
            <one-to-many class="pt.estgp.estgweb.domain.QuestionarioPedagogicoAlunoRequisitado" />
984
        </set>
985
        <subclass name="pt.estgp.estgweb.domain.QuestionarioPedagogicoTipologiaRequisitadaImpl" discriminator-value="QuestionarioPedagogicoTipologiaRequisitadaImpl"/>
986
    </class>
987
 
988
    <class name="pt.estgp.estgweb.domain.QuestionarioPedagogicoAlunoRequisitado" table="questionario_peda_aluno_requisitado" abstract="true">
989
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
990
        <meta attribute="scope-class">public abstract</meta>
991
        <id name="id" type="long" unsaved-value="0">
992
            <generator class="native"/>
993
        </id>
994
        <discriminator column="discriminator"/>
1549 jmachado 995
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1336 jmachado 996
        <property name="saveDate" type="timestamp"/>
1553 jmachado 997
 
998
        <property name="tipoAlunoFoiExtraido" type="boolean">
999
            <column name="tipoAlunoFoiExtraido" default="false"/>
1000
        </property>
1001
 
1002
        <property name="tipoAlunoTrabalhadorEstudante" type="boolean">
1003
            <column name="tipoAlunoTrabalhadorEstudante" default="false"/>
1004
        </property>
1005
        <property name="tipoAlunoErasmus" type="boolean" index="tipoAlunoErasmusIndex">
1006
            <column name="tipoAlunoErasmus" default="false"/>
1007
        </property>
1008
        <property name="tipoAlunoNormal" type="boolean" index="tipoAlunoNormalIndex">
1009
            <column name="tipoAlunoNormal" default="false"/>
1010
        </property>
1011
        <property name="tipoAlunoBolseiro" type="boolean" index="tipoAlunoBolseiroIndex">
1012
            <column name="tipoAlunoBolseiro" default="false"/>
1013
        </property>
1014
        <property name="tipoAlunoMilitar" type="boolean" index="tipoAlunoMilitarIndex">
1015
            <column name="tipoAlunoMilitar" default="false"/>
1016
        </property>
1017
        <property name="tipoAlunoDirigenteAssociativo" type="boolean" index="tipoAlunoDirigenteAssociativoIndex">
1018
            <column name="tipoAlunoDirigenteAssociativo" default="false"/>
1019
        </property>
1020
        <property name="tipoAlunoDeficiente" type="boolean" index="tipoAlunoDeficienteIndex">
1021
            <column name="tipoAlunoDeficiente" default="false"/>
1022
        </property>
1023
        <property name="tipoAlunoBombeiro" type="boolean" index="tipoAlunoBombeiroIndex">
1024
            <column name="tipoAlunoBombeiro" default="false"/>
1025
        </property>
1026
        <property name="tipoAlunoVascodagama" type="boolean" index="tipoAlunoVascodagamaIndex">
1027
            <column name="tipoAlunoVascodagama" default="false"/>
1028
        </property>
1029
        <property name="propinasEmDia" type="boolean" index="propinasEmDiaIndex">
1030
            <column name="propinasEmDia" default="false"/>
1031
        </property>
1032
 
1336 jmachado 1033
        <many-to-one name="aluno" class="pt.estgp.estgweb.domain.Student" lazy="proxy" outer-join="false"/>
1034
        <many-to-one name="tipologiaRequisitada" class="pt.estgp.estgweb.domain.QuestionarioPedagogicoTipologiaRequisitada" lazy="proxy" outer-join="false" column="tipologia_requisitada"/>
1035
        <many-to-one name="respostaRequisitada" class="pt.estgp.estgweb.domain.QuestionarioRespostaRequisitada" lazy="proxy" outer-join="false"/>
1036
        <subclass name="pt.estgp.estgweb.domain.QuestionarioPedagogicoAlunoRequisitadoImpl" discriminator-value="QuestionarioPedagogicoAlunoRequisitadoImpl"/>
1037
    </class>
1038
 
1039
    <class name="pt.estgp.estgweb.domain.QuestionarioPedagogicoCursoAfeto" table="questionario_peda_curso_afeto" abstract="true">
1040
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
1041
        <meta attribute="scope-class">public abstract</meta>
1042
        <id name="id" type="long" unsaved-value="0">
1043
            <generator class="native"/>
1044
        </id>
1045
        <discriminator column="discriminator"/>
1549 jmachado 1046
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1336 jmachado 1047
        <property name="saveDate" type="timestamp"/>
1048
        <property name="codigoInstituicao" type="string"/>
1049
        <property name="nomeInstituicao" type="string"/>
1333 jmachado 1050
        <property name="codigoCurso" type="string" index="codigoCursoIndex"/>
1330 jmachado 1051
        <property name="ano" type="string"/>
1052
        <property name="semestre" type="string"/>
1053
        <property name="nome" type="string"/>
1332 jmachado 1054
        <property name="marcadas" type="int"/>
1055
        <property name="obs" type="string"/>
1337 jmachado 1056
        <property name="usarTipologias" type="boolean">
1057
            <column name="usarTipologias" default="false"/>
1058
        </property>
1394 jmachado 1059
 
1060
        <!--STATS-->
1061
        <property name="statTipologiasRequisitadas" type="int">
1062
            <column name="statTipologiasRequisitadas" default="0"/>
1063
        </property>
1064
        <property name="statRespostasRequisitadas" type="int">
1065
            <column name="statRespostasRequisitadas" default="0"/>
1066
        </property>
1067
 
1330 jmachado 1068
        <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" lazy="proxy" outer-join="false"/>
1069
        <many-to-one name="course" class="pt.estgp.estgweb.domain.Course" lazy="proxy" outer-join="false"/>
1338 jmachado 1070
        <set name="unidadesAfetas" lazy="true" order-by="nome asc">
1335 jmachado 1071
            <key column="curso_afeto"/>
1330 jmachado 1072
            <one-to-many class="pt.estgp.estgweb.domain.QuestionarioPedagogicoUnidadeCurricularAfeta" />
1073
        </set>
1074
        <subclass name="pt.estgp.estgweb.domain.QuestionarioPedagogicoCursoAfetoImpl" discriminator-value="QuestionarioPedagogicoCursoAfetoImpl"/>
1075
    </class>
1076
 
1336 jmachado 1077
    <class name="pt.estgp.estgweb.domain.QuestionarioPedagogicoUnidadeCurricularAfeta" table="questionario_peda_unidade_afeta" abstract="true">
1330 jmachado 1078
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
1079
        <meta attribute="scope-class">public abstract</meta>
1080
        <id name="id" type="long" unsaved-value="0">
1081
            <generator class="native"/>
1082
        </id>
1083
        <discriminator column="discriminator"/>
1549 jmachado 1084
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1330 jmachado 1085
        <property name="saveDate" type="timestamp"/>
1626 jmachado 1086
        <property name="lastTipologiasUpdateDate" type="timestamp"/>
1333 jmachado 1087
        <property name="codigoUnidade" type="string" index="codigoUnidadeIndex"/>
1336 jmachado 1088
        <property name="nome" type="string"/>
1333 jmachado 1089
 
1090
        <property name="addedTipologias" type="int"/>
1091
 
1330 jmachado 1092
        <property name="marked" type="boolean"/>
1626 jmachado 1093
        <property name="excludedTipologias" type="int">
1094
            <column name="excludedTipologias" default="0"/>
1095
        </property>
1330 jmachado 1096
        <property name="profs" type="int"/>
1333 jmachado 1097
        <property name="turmas" type="int"/>
1098
        <property name="students" type="int"/>
1330 jmachado 1099
        <property name="turmaWithoutProf" type="int"/>
1333 jmachado 1100
        <property name="profsWithoutTurma" type="int"/>
1101
        <property name="tipologias" type="int"/>
1102
 
1338 jmachado 1103
        <property name="vista" type="boolean">
1104
            <column name="vista" default="false"/>
1105
        </property>
1378 jmachado 1106
        <property name="vistaProfs" type="boolean">
1107
            <column name="vista_profs" default="false"/>
1108
        </property>
1338 jmachado 1109
        <property name="usar" type="boolean">
1110
            <column name="usar" default="true"/>
1111
        </property>
1112
 
1545 jmachado 1113
        <property name="usarOlap" type="boolean">
1114
            <column name="usarOlap" default="true"/>
1115
        </property>
1116
 
1333 jmachado 1117
        <property name="obs" type="text">
1118
            <column name="obs" sql-type="TEXT"/>
1119
        </property>
1626 jmachado 1120
        <!--
1330 jmachado 1121
        <property name="tipologiasJson" type="text">
1122
            <column name="tipologias_json" sql-type="MEDIUMTEXT"/>
1123
        </property>
1626 jmachado 1124
        -->
1394 jmachado 1125
        <!--STATS-->
1126
 
1395 jmachado 1127
        <property name="statTipologiasRequisitadas" type="int">
1394 jmachado 1128
            <column name="statTipologiasRequisitadas" default="0"/>
1129
        </property>
1395 jmachado 1130
        <property name="statRespostasRequisitadas" type="int">
1394 jmachado 1131
            <column name="statRespostasRequisitadas" default="0"/>
1132
        </property>
1133
 
1335 jmachado 1134
        <many-to-one name="cursoAfeto" class="pt.estgp.estgweb.domain.QuestionarioPedagogicoCursoAfeto" lazy="proxy" outer-join="false" column="curso_afeto"/>
1330 jmachado 1135
        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="proxy" outer-join="false"/>
1336 jmachado 1136
        <set name="tipologiasRequisitadas" lazy="true">
1137
            <key column="unidade_afeta"/>
1138
            <one-to-many class="pt.estgp.estgweb.domain.QuestionarioPedagogicoTipologiaRequisitada" />
1139
        </set>
1330 jmachado 1140
        <subclass name="pt.estgp.estgweb.domain.QuestionarioPedagogicoUnidadeCurricularAfetaImpl" discriminator-value="QuestionarioPedagogicoUnidadeCurricularAfetaImpl"/>
1141
    </class>
1142
 
1143
 
1547 jmachado 1144
    <!--REPORTS-->
1330 jmachado 1145
 
1547 jmachado 1146
    <class name="pt.estgp.estgweb.domain.QuestionarioReportFileGroup" table="questionario_report_file_grp" abstract="true">
1147
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
1148
        <meta attribute="scope-class">public abstract</meta>
1149
        <id name="id" type="long" unsaved-value="0">
1150
            <generator class="native"/>
1151
        </id>
1152
        <discriminator column="discriminator"/>
1549 jmachado 1153
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1547 jmachado 1154
        <property name="saveDate" type="timestamp"/>
1573 jmachado 1155
        <property name="title" type="string"/>
1586 jmachado 1156
        <property name="active" type="boolean"/>
1573 jmachado 1157
        <property name="reportProcessorClass" type="string"/>
1158
        <property name="repositoryStreamZipFile" type="string" index="repositoryIndexZipFile"/>
1159
        <property name="repositoryStreamCsvFile" type="string" index="repositoryIndexCsvFile"/>
1579 jmachado 1160
        <property name="reportGenerationTaskId" type="long">
1161
            <column name="report_generation_task_id" default="0"/>
1162
        </property>
1586 jmachado 1163
        <set name="reportFiles" lazy="true" order-by="entityName asc">
1584 jmachado 1164
            <key column="questionario_report_file_group"/>
1165
            <one-to-many class="pt.estgp.estgweb.domain.QuestionarioReportFile" />
1166
        </set>
1547 jmachado 1167
        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupImpl">
1168
            <meta attribute="scope-class">public abstract</meta>
1169
            <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupAno">
1170
                <meta attribute="scope-class">public abstract</meta>
1586 jmachado 1171
                <property name="importYear" type="string" index="importYearIndex"/>
1573 jmachado 1172
                <property name="periodos" type="string"/>
1173
                <property name="degrees" type="string"/>
1585 jmachado 1174
                <property name="entidadesEncontradas" type="int">
1175
                    <column name="entidadesEncontradas" default="0"/>
1176
                </property>
1177
                <property name="entidadesProcessadas" type="int">
1178
                    <column name="entidadesProcessadas" default="0"/>
1179
                </property>
1180
                <property name="entidadesFalhadas" type="int">
1181
                    <column name="entidadesFalhadas" default="0"/>
1182
                </property>
1183
                <property name="entidadesComRespostas" type="int">
1184
                    <column name="entidadesComRespostas" default="0"/>
1185
                </property>
1186
                <property name="entidadesSemRespostas" type="int">
1187
                    <column name="entidadesSemRespostas" default="0"/>
1188
                </property>
1189
                <property name="entidadesSemUnidadesAfetas" type="int">
1190
                    <column name="entidadesSemUnidadesAfetas" default="0"/>
1191
                </property>
1586 jmachado 1192
                <property name="citiesJson" type="string">
1193
                    <column name="citiesJson" sql-type="TEXT"/>
1194
                </property>
1547 jmachado 1195
                <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupAnoImpl">
1196
                    <meta attribute="scope-class">public abstract</meta>
1197
                    <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupCursosAno">
1198
                        <meta attribute="scope-class">public abstract</meta>
1199
                        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupCursosAnoImpl" discriminator-value="QuestionarioReportFileGroupCursosAnoImpl"/>
1200
                    </subclass>
1201
                    <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupDocentesAno">
1202
                        <meta attribute="scope-class">public abstract</meta>
1203
                        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileGroupDocentesAnoImpl" discriminator-value="QuestionarioReportFileGroupDocentesAnoImpl"/>
1204
                    </subclass>
1205
                </subclass>
1206
            </subclass>
1207
        </subclass>
1208
    </class>
1209
 
1210
    <class name="pt.estgp.estgweb.domain.QuestionarioReportFile" table="questionario_report_file" abstract="true">
1211
        <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta>
1212
        <meta attribute="scope-class">public abstract</meta>
1213
        <id name="id" type="long" unsaved-value="0">
1214
            <generator class="native"/>
1215
        </id>
1216
        <discriminator column="discriminator"/>
1549 jmachado 1217
        <timestamp source="db" name="updateDate" unsaved-value="null"/>
1547 jmachado 1218
        <property name="saveDate" type="timestamp"/>
1586 jmachado 1219
        <property name="active" type="boolean"/>
1584 jmachado 1220
        <property name="entityName" type="string"/><!--opcional use-->
1221
        <property name="entityCode" type="string"/><!--opcional use-->
1547 jmachado 1222
        <property name="repositoryStream" type="string" index="repositoryIndex"/>
1584 jmachado 1223
        <many-to-one name="reportGroup" class="pt.estgp.estgweb.domain.QuestionarioReportFileGroup" lazy="proxy" outer-join="false" column="questionario_report_file_group"/>
1547 jmachado 1224
        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileImpl">
1225
            <meta attribute="scope-class">public abstract</meta>
1585 jmachado 1226
            <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileAno">
1547 jmachado 1227
                <meta attribute="scope-class">public abstract</meta>
1585 jmachado 1228
                <property name="inquiridos" type="int">
1229
                    <column name="inquiridos" default="0" />
1230
                </property>
1231
                <property name="inquiridosComResposta" type="int">
1232
                    <column name="inquiridosComResposta" default="0"/>
1233
                </property>
1234
                <property name="respostasRequisitadas" type="int">
1235
                    <column name="respostasRequisitadas" default="0"/>
1236
                </property>
1237
                <property name="respostas" type="int">
1238
                    <column name="respostas" default="0"/>
1239
                </property>
1240
                <property name="unidades" type="int">
1241
                    <column name="unidades" default="0"/>
1242
                </property>
1586 jmachado 1243
                <property name="percentagemRespostas" type="int">
1244
                    <column name="percentagemRespostas" default="0"/>
1245
                </property>
1246
                <property name="percentagemInquiridos" type="int">
1247
                    <column name="percentagemInquiridos" default="0"/>
1248
                </property>
1249
                <property name="citiesJson" type="string">
1250
                    <column name="citiesJson" sql-type="TEXT"/>
1251
                </property>
1830 jmachado 1252
 
1585 jmachado 1253
                <subclass name="pt.estgp.estgweb.domain.QuestionarioReportFileAnoImpl">
1254
                    <meta attribute="scope-class">public abstract</meta>
1255
                    <subclass name="pt.estgp.estgweb.domain.QuestionarioReportCursoFile">
1256
                        <meta attribute="scope-class">public abstract</meta>
1586 jmachado 1257
                        <property name="tipoCurso" type="string"/>
1258
                        <property name="escola" type="string"/>
1259
                        <property name="codigoEscola" type="string"/>
1830 jmachado 1260
                        <property name="courseReportQuestionsXml" type="string">
1831 jmachado 1261
                            <column name="courseReportQuestionsXml" sql-type="MEDIUMTEXT"/>
1830 jmachado 1262
                        </property>
1263
                        <property name="courseReportQuestionsJson" type="string">
1831 jmachado 1264
                            <column name="courseReportQuestionsJson" sql-type="MEDIUMTEXT"/>
1830 jmachado 1265
                        </property>
1585 jmachado 1266
                        <!--<many-to-one name="course" class="pt.estgp.estgweb.domain.Course" lazy="proxy" outer-join="false"/>-->
1267
                        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportCursoFileImpl" discriminator-value="QuestionarioReportCursoFileImpl"/>
1268
                    </subclass>
1269
                    <subclass name="pt.estgp.estgweb.domain.QuestionarioReportDocenteFile">
1270
                        <meta attribute="scope-class">public abstract</meta>
1271
 
1272
                        <!--
1273
                        <many-to-one name="teacher" class="pt.estgp.estgweb.domain.Teacher" lazy="proxy" outer-join="false"/>
1274
                        <set name="courseUnits" lazy="true" table="questionario_report_file_docente_units">
1275
                            <key column="reportdocentefile"/>
1276
                            <many-to-many class="pt.estgp.estgweb.domain.CourseUnit" column="courseunit" />
1277
                        </set>-->
1278
                        <subclass name="pt.estgp.estgweb.domain.QuestionarioReportDocenteFileImpl" discriminator-value="QuestionarioReportDocenteFileImpl"/>
1279
                    </subclass>
1280
                </subclass>
1547 jmachado 1281
            </subclass>
1282
        </subclass>
1283
    </class>
1284
 
1285
 
1286
 
1314 jmachado 1287
</hibernate-mapping>