Rev 1572 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 1572 | Rev 1586 | ||
|---|---|---|---|
| Line 3... | Line 3... | ||
| 3 | PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" |
3 | PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" |
| 4 | "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> |
4 | "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> |
| 5 | 5 | ||
| 6 | <hibernate-mapping> |
6 | <hibernate-mapping> |
| 7 | 7 | ||
| 8 | <class name="pt.estgp.estgweb.domain.OlapHistoryDimension" table="olap_e_timeline"> |
8 | <class name="pt.estgp.estgweb.domain.OlapHistoryDimension" table="olap_e_timeline" abstract="true"> |
| 9 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
9 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 10 | <meta attribute="scope-class">public abstract</meta> |
|
| 10 | <id name="id" type="long" unsaved-value="0"> |
11 | <id name="id" type="long" unsaved-value="0"> |
| 11 | <generator class="native"/> |
12 | <generator class="native"/> |
| 12 | </id> |
13 | </id> |
| - | 14 | <discriminator column="discrimitator"/> |
|
| 13 | <property name="nome" type="string" index="nomeIndex"/> |
15 | <property name="nome" type="string" index="nomeIndex"/> |
| 14 | <property name="descricao" type="string"/> |
16 | <property name="descricao" type="string"/> |
| 15 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
17 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 18 | <subclass name="pt.estgp.estgweb.domain.OlapHistoryDimensionImpl" discriminator-value="OlapHistoryDimensionImpl"/> |
|
| 16 | </class> |
19 | </class> |
| 17 | 20 | ||
| 18 | 21 | ||
| 19 | 22 | ||
| 20 | 23 | ||
| 21 | 24 | ||
| 22 | <!--Questionario Dimensao--> |
25 | <!--Questionario Dimensao--> |
| 23 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionario" table="olap_e_quest"> |
26 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionario" table="olap_e_quest" abstract="true"> |
| 24 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
27 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 28 | <meta attribute="scope-class">public abstract</meta> |
|
| 25 | <id name="id" type="long" unsaved-value="0"> |
29 | <id name="id" type="long" unsaved-value="0"> |
| 26 | <generator class="native"/> |
30 | <generator class="native"/> |
| 27 | </id> |
31 | </id> |
| - | 32 | <discriminator column="discrimitator"/> |
|
| 28 | <property name="ano" type="string" index="anoIndex"/> |
33 | <property name="ano" type="string" index="anoIndex"/> |
| 29 | <property name="semestre" type="string" index="semestreIndex"/> |
34 | <property name="semestre" type="string" index="semestreIndex"/> |
| 30 | <property name="generatedTime" type="timestamp" index="associatedTimeIndex"/> |
35 | <property name="generatedTime" type="timestamp" index="associatedTimeIndex"/> |
| 31 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
36 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 37 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioImpl" discriminator-value="OlapEntityQuestionarioImpl"/> |
|
| 32 | </class> |
38 | </class> |
| 33 | 39 | ||
| 34 | 40 | ||
| 35 | 41 | ||
| 36 | 42 | ||
| 37 | <!--CURSO DIMENSAO--> |
43 | <!--CURSO DIMENSAO--> |
| 38 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" table="olap_e_quest_curso"> |
44 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" table="olap_e_quest_curso" abstract="true"> |
| 39 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
45 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 46 | <meta attribute="scope-class">public abstract</meta> |
|
| 40 | <id name="id" type="long" unsaved-value="0"> |
47 | <id name="id" type="long" unsaved-value="0"> |
| 41 | <generator class="native"/> |
48 | <generator class="native"/> |
| 42 | </id> |
49 | </id> |
| - | 50 | <discriminator column="discrimitator"/> |
|
| 43 | <property name="codigoCurso" type="string" index="codigoCursoIndex"/> |
51 | <property name="codigoCurso" type="string" index="codigoCursoIndex"/> |
| 44 | <property name="nomeCurso" type="string" index="nomeCursoIndex"/> |
52 | <property name="nomeCurso" type="string" index="nomeCursoIndex"/> |
| 45 | 53 | ||
| 46 | <property name="codigoInstituicao" type="string" index="codigoInstituicaoIndex"/> |
54 | <property name="codigoInstituicao" type="string" index="codigoInstituicaoIndex"/> |
| 47 | <property name="nomeInstituicao" type="string" index="nomeInstituicaoIndex"/> |
55 | <property name="nomeInstituicao" type="string" index="nomeInstituicaoIndex"/> |
| Line 50... | Line 58... | ||
| 50 | <property name="degree" type="string" index="degreeIndex"> |
58 | <property name="degree" type="string" index="degreeIndex"> |
| 51 | <column name="degree" index="degreeIndex" /> |
59 | <column name="degree" index="degreeIndex" /> |
| 52 | </property> |
60 | </property> |
| 53 | <property name="departament" type="string" index="departamentIndex"/> |
61 | <property name="departament" type="string" index="departamentIndex"/> |
| 54 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
62 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 63 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioCursoImpl" discriminator-value="OlapEntityQuestionarioCursoImpl"/> |
|
| 55 | </class> |
64 | </class> |
| 56 | 65 | ||
| 57 | 66 | ||
| 58 | 67 | ||
| 59 | 68 | ||
| 60 | 69 | ||
| 61 | 70 | ||
| 62 | <!--Unidade Dimensao--> |
71 | <!--Unidade Dimensao--> |
| 63 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" table="olap_e_quest_unit"> |
72 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" table="olap_e_quest_unit" abstract="true"> |
| 64 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
73 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 74 | <meta attribute="scope-class">public abstract</meta> |
|
| 65 | <id name="id" type="long" unsaved-value="0"> |
75 | <id name="id" type="long" unsaved-value="0"> |
| 66 | <generator class="native"/> |
76 | <generator class="native"/> |
| 67 | </id> |
77 | </id> |
| - | 78 | <discriminator column="discrimitator"/> |
|
| 68 | <property name="codigo" type="string" index="codigoIndex"/> |
79 | <property name="codigo" type="string" index="codigoIndex"/> |
| 69 | <property name="nome" type="string"/> |
80 | <property name="nome" type="string"/> |
| 70 | <!-- S1 S2 A T1 T2 T3 T4 --> |
81 | <!-- S1 S2 A T1 T2 T3 T4 --> |
| 71 | <property name="periodoSigesS1ouS2ouAouT1aT4" type="string" index="persigesIndex"/> |
82 | <property name="periodoSigesS1ouS2ouAouT1aT4" type="string" index="persigesIndex"/> |
| 72 | 83 | ||
| Line 83... | Line 94... | ||
| 83 | <!-- S1 = 1, S2 = 2, S3 = 1, S4 = 2 ... T1 e T2 = 1, T2 e T3 = 2, T4 e T5 = 1, T6 e T7 = 2--> |
94 | <!-- S1 = 1, S2 = 2, S3 = 1, S4 = 2 ... T1 e T2 = 1, T2 e T3 = 2, T4 e T5 = 1, T6 e T7 = 2--> |
| 84 | <property name="semestrePlanoAbsoluto1ou2" type="int" index="semplaabsIndex"/> |
95 | <property name="semestrePlanoAbsoluto1ou2" type="int" index="semplaabsIndex"/> |
| 85 | 96 | ||
| 86 | 97 | ||
| 87 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
98 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 99 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidadeImpl" discriminator-value="OlapEntityQuestionarioUnidadeImpl"/> |
|
| 88 | </class> |
100 | </class> |
| 89 | 101 | ||
| 90 | 102 | ||
| 91 | 103 | ||
| 92 | 104 | ||
| 93 | <!--Tipologia Dimensao--> |
105 | <!--Tipologia Dimensao--> |
| 94 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" table="olap_e_quest_tipologia"> |
106 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" table="olap_e_quest_tipologia" abstract="true"> |
| 95 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
107 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 108 | <meta attribute="scope-class">public abstract</meta> |
|
| 96 | <id name="id" type="long" unsaved-value="0"> |
109 | <id name="id" type="long" unsaved-value="0"> |
| 97 | <generator class="native"/> |
110 | <generator class="native"/> |
| 98 | </id> |
111 | </id> |
| - | 112 | <discriminator column="discrimitator"/> |
|
| 99 | <property name="codigoTipologia" type="string" index="codigoIndex"/> |
113 | <property name="codigoTipologia" type="string" index="codigoIndex"/> |
| 100 | <property name="descricao" type="string"/> |
114 | <property name="descricao" type="string"/> |
| 101 | <property name="codigoTurma" type="string" index="codigoIndex"/> |
115 | <property name="codigoTurma" type="string" index="codigoIndex"/> |
| 102 | 116 | ||
| 103 | <property name="codigoSiges" type="string" index="codigoIndex"/> |
117 | <property name="codigoSiges" type="string" index="codigoIndex"/> |
| 104 | <property name="nome" type="string"/> |
118 | <property name="nome" type="string"/> |
| 105 | <property name="bi" type="string"/> |
119 | <property name="bi" type="string"/> |
| 106 | <property name="username" type="string"/> |
120 | <property name="username" type="string"/> |
| 107 | <property name="email" type="string"/> |
121 | <property name="email" type="string"/> |
| 108 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
122 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 123 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologiaImpl" discriminator-value="OlapEntityQuestionarioTipologiaImpl"/> |
|
| 109 | </class> |
124 | </class> |
| 110 | 125 | ||
| 111 | 126 | ||
| 112 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPergunta" table="olap_e_quest_pgrp"> |
127 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPergunta" table="olap_e_quest_pgrp" abstract="true"> |
| 113 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
128 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 129 | <meta attribute="scope-class">public abstract</meta> |
|
| 114 | <id name="id" type="long" unsaved-value="0"> |
130 | <id name="id" type="long" unsaved-value="0"> |
| 115 | <generator class="native"/> |
131 | <generator class="native"/> |
| 116 | </id> |
132 | </id> |
| - | 133 | <discriminator column="discrimitator"/> |
|
| 117 | <property name="grupoCode" type="string" index="grupoCodeIndex"/> |
134 | <property name="grupoCode" type="string" index="grupoCodeIndex"/> |
| 118 | <property name="grupoTitle" type="string" index="grupoTitleIndex"/> |
135 | <property name="grupoTitle" type="string" index="grupoTitleIndex"/> |
| 119 | <property name="subGrupoCode" type="string" index="subGrupoCodeIndex"/> |
136 | <property name="subGrupoCode" type="string" index="subGrupoCodeIndex"/> |
| 120 | <property name="subGrupoTitle" type="string" index="subGrupoTitleIndex"/> |
137 | <property name="subGrupoTitle" type="string" index="subGrupoTitleIndex"/> |
| 121 | <property name="pergunta" type="string" index="perguntaIndex"/> |
138 | <property name="pergunta" type="string" index="perguntaIndex"/> |
| 122 | <property name="numero" type="string" index="numeroIndex"/> |
139 | <property name="numero" type="string" index="numeroIndex"/> |
| 123 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
140 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 141 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaImpl" discriminator-value="OlapEntityQuestionarioPerguntaImpl"/> |
|
| 124 | </class> |
142 | </class> |
| 125 | 143 | ||
| 126 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaEsforco" table="olap_e_quest_pgrp_esforco"> |
144 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaEsforco" table="olap_e_quest_pgrp_esforco" abstract="true"> |
| 127 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
145 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 146 | <meta attribute="scope-class">public abstract</meta> |
|
| 128 | <id name="id" type="long" unsaved-value="0"> |
147 | <id name="id" type="long" unsaved-value="0"> |
| 129 | <generator class="native"/> |
148 | <generator class="native"/> |
| 130 | </id> |
149 | </id> |
| - | 150 | <discriminator column="discrimitator"/> |
|
| 131 | <property name="grupoCode" type="string" index="grupoCodeIndex"/> |
151 | <property name="grupoCode" type="string" index="grupoCodeIndex"/> |
| 132 | <property name="grupoTitle" type="string" index="grupoTitleIndex"/> |
152 | <property name="grupoTitle" type="string" index="grupoTitleIndex"/> |
| 133 | <property name="subGrupoCode" type="string" index="subGrupoCodeIndex"/> |
153 | <property name="subGrupoCode" type="string" index="subGrupoCodeIndex"/> |
| 134 | <property name="subGrupoTitle" type="string" index="subGrupoTitleIndex"/> |
154 | <property name="subGrupoTitle" type="string" index="subGrupoTitleIndex"/> |
| 135 | <property name="pergunta" type="string" index="perguntaIndex"/> |
155 | <property name="pergunta" type="string" index="perguntaIndex"/> |
| 136 | <property name="numero" type="string" index="numeroIndex"/> |
156 | <property name="numero" type="string" index="numeroIndex"/> |
| 137 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
157 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 158 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaEsforcoImpl" discriminator-value="OlapEntityQuestionarioPerguntaEsforcoImpl"/> |
|
| 138 | </class> |
159 | </class> |
| 139 | 160 | ||
| - | 161 | ||
| - | 162 | ||
| 140 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" table="olap_e_quest_user"> |
163 | <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" table="olap_e_quest_user" abstract="true"> |
| 141 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
164 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapDimensionImpl</meta> |
| - | 165 | <meta attribute="scope-class">public abstract</meta> |
|
| 142 | <id name="id" type="long" unsaved-value="0"> |
166 | <id name="id" type="long" unsaved-value="0"> |
| 143 | <generator class="native"/> |
167 | <generator class="native"/> |
| 144 | </id> |
168 | </id> |
| - | 169 | <discriminator column="discrimitator"/> |
|
| 145 | <property name="sigesCode" type="string" index="sigesCodeIndex"/> |
170 | <property name="sigesCode" type="string" index="sigesCodeIndex"/> |
| 146 | <property name="distrito" type="string" index="distritoIndex"/> |
171 | <property name="distrito" type="string" index="distritoIndex"/> |
| 147 | <property name="concelho" type="string" index="concelhoIndex"/> |
172 | <property name="concelho" type="string" index="concelhoIndex"/> |
| 148 | <property name="zip" type="string" index="zipIndex"/> |
173 | <property name="zip" type="string" index="zipIndex"/> |
| 149 | <property name="zipInt" type="int" index="zipIntIndex"> |
174 | <property name="zipInt" type="int" index="zipIntIndex"> |
| Line 185... | Line 210... | ||
| 185 | </property> |
210 | </property> |
| 186 | 211 | ||
| 187 | <property name="academicDegree" type="string" index="academicDegreeIndex"/> |
212 | <property name="academicDegree" type="string" index="academicDegreeIndex"/> |
| 188 | <property name="scholarDegree" type="string" index="scholarDegreeIndex"/> |
213 | <property name="scholarDegree" type="string" index="scholarDegreeIndex"/> |
| 189 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
214 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| 190 | - | ||
| - | 215 | <subclass name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUserImpl" discriminator-value="OlapEntityQuestionarioUserImpl"/> |
|
| 191 | 216 | ||
| 192 | </class> |
217 | </class> |
| 193 | 218 | ||
| 194 | <!-- FACTOS EM ESTRELA --> |
219 | <!-- FACTOS EM ESTRELA --> |
| 195 | 220 | ||
| 196 | 221 | ||
| 197 | 222 | ||
| 198 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioCurso" table="olap_star_quest_curso"> |
223 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioCurso" table="olap_star_quest_curso" abstract="true"> |
| 199 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
224 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 225 | <meta attribute="scope-class">public abstract</meta> |
|
| 200 | <id name="id" type="long" unsaved-value="0"> |
226 | <id name="id" type="long" unsaved-value="0"> |
| 201 | <generator class="native"/> |
227 | <generator class="native"/> |
| 202 | </id> |
228 | </id> |
| - | 229 | <discriminator column="discrimitator"/> |
|
| 203 | 230 | ||
| 204 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
231 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
| 205 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
232 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
| 206 | na realidade ao numero de questionarios / docente --> |
233 | na realidade ao numero de questionarios / docente --> |
| 207 | <property name="unidades" type="integer" index="unidadesIndex"/> |
234 | <property name="unidades" type="integer" index="unidadesIndex"/> |
| Line 213... | Line 240... | ||
| 213 | <many-to-one name="olapQuestionario" class="pt.estgp.estgweb.domain.OlapEntityQuestionario" outer-join="false" lazy="proxy"/> |
240 | <many-to-one name="olapQuestionario" class="pt.estgp.estgweb.domain.OlapEntityQuestionario" outer-join="false" lazy="proxy"/> |
| 214 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
241 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
| 215 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
242 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
| 216 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
243 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
| 217 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
244 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 245 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioCursoImpl" discriminator-value="OlapStarFactQuestionarioCursoImpl"/> |
|
| 218 | </class> |
246 | </class> |
| - | 247 | ||
| - | 248 | ||
| 219 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioUnidade" table="olap_star_quest_unidade"> |
249 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioUnidade" table="olap_star_quest_unidade" abstract="true"> |
| 220 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
250 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 251 | <meta attribute="scope-class">public abstract</meta> |
|
| 221 | <id name="id" type="long" unsaved-value="0"> |
252 | <id name="id" type="long" unsaved-value="0"> |
| 222 | <generator class="native"/> |
253 | <generator class="native"/> |
| 223 | </id> |
254 | </id> |
| - | 255 | <discriminator column="discrimitator"/> |
|
| 224 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
256 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
| 225 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
257 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
| 226 | na realidade ao numero de questionarios / docente --> |
258 | na realidade ao numero de questionarios / docente --> |
| 227 | <property name="tipologias" type="integer" index="tipologiasIndex"/> |
259 | <property name="tipologias" type="integer" index="tipologiasIndex"/> |
| 228 | <property name="respostasCandidatas" type="integer" index="respostasCandidatasIndex"/> |
260 | <property name="respostasCandidatas" type="integer" index="respostasCandidatasIndex"/> |
| Line 232... | Line 264... | ||
| 232 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
264 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
| 233 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
265 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
| 234 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
266 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
| 235 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
267 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
| 236 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
268 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 269 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioUnidadeImpl" discriminator-value="OlapStarFactQuestionarioUnidadeImpl"/> |
|
| 237 | </class> |
270 | </class> |
| - | 271 | ||
| - | 272 | ||
| - | 273 | ||
| 238 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioTipologia" table="olap_star_quest_tipologia"> |
274 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioTipologia" table="olap_star_quest_tipologia" abstract="true"> |
| 239 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
275 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 276 | <meta attribute="scope-class">public abstract</meta> |
|
| 240 | <id name="id" type="long" unsaved-value="0"> |
277 | <id name="id" type="long" unsaved-value="0"> |
| 241 | <generator class="native"/> |
278 | <generator class="native"/> |
| 242 | </id> |
279 | </id> |
| - | 280 | <discriminator column="discrimitator"/> |
|
| 243 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
281 | <!-- Atencao estes valores sao apenas das entidades olap criadas, para proceder às contagens |
| 244 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
282 | deve usar a tabela de factos de respostas, as tipologias nao sao unicas, correspondem |
| 245 | na realidade ao numero de questionarios / docente --> |
283 | na realidade ao numero de questionarios / docente --> |
| 246 | <property name="respostasCandidatas" type="integer" index="respostasCandidatasIndex"/> |
284 | <property name="respostasCandidatas" type="integer" index="respostasCandidatasIndex"/> |
| 247 | <property name="respostasObtidas" type="integer" index="respostasObtidasIndex"/> |
285 | <property name="respostasObtidas" type="integer" index="respostasObtidasIndex"/> |
| Line 251... | Line 289... | ||
| 251 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
289 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
| 252 | <many-to-one name="olapTipologia" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" outer-join="false" lazy="proxy"/> |
290 | <many-to-one name="olapTipologia" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" outer-join="false" lazy="proxy"/> |
| 253 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
291 | <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos--> |
| 254 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
292 | <many-to-one name="olapTimeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/> |
| 255 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
293 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 294 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioTipologiaImpl" discriminator-value="OlapStarFactQuestionarioTipologiaImpl"/> |
|
| 256 | </class> |
295 | </class> |
| 257 | 296 | ||
| - | 297 | ||
| - | 298 | ||
| 258 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionario" table="olap_star_quest"> |
299 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionario" table="olap_star_quest" abstract="true"> |
| 259 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
300 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 301 | <meta attribute="scope-class">public abstract</meta> |
|
| 260 | <id name="id" type="long" unsaved-value="0"> |
302 | <id name="id" type="long" unsaved-value="0"> |
| 261 | <generator class="native"/> |
303 | <generator class="native"/> |
| 262 | </id> |
304 | </id> |
| - | 305 | <discriminator column="discrimitator"/> |
|
| 263 | <property name="respondido" type="boolean" index="respondidoIndex"/> |
306 | <property name="respondido" type="boolean" index="respondidoIndex"/> |
| 264 | <property name="dataInicio" type="timestamp"/> |
307 | <property name="dataInicio" type="timestamp"/> |
| 265 | <property name="tempoTotal" type="long"/> |
308 | <property name="tempoTotal" type="long"/> |
| 266 | <property name="dataFim" type="timestamp"/> |
309 | <property name="dataFim" type="timestamp"/> |
| 267 | 310 | ||
| 268 | - | ||
| 269 | <!--Associação directa às classes de resposta--> |
311 | <!--Associação directa às classes de resposta--> |
| 270 | <many-to-one name="olapTipologia" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" outer-join="false" lazy="proxy"/> |
312 | <many-to-one name="olapTipologia" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" outer-join="false" lazy="proxy"/> |
| 271 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
313 | <many-to-one name="olapUnidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/> |
| 272 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
314 | <many-to-one name="olapCurso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/> |
| 273 | <many-to-one name="olapQuestionario" class="pt.estgp.estgweb.domain.OlapEntityQuestionario" outer-join="false" lazy="proxy"/> |
315 | <many-to-one name="olapQuestionario" class="pt.estgp.estgweb.domain.OlapEntityQuestionario" outer-join="false" lazy="proxy"/> |
| Line 278... | Line 320... | ||
| 278 | <!--Desmultiplicadas das classes de resposta--> |
320 | <!--Desmultiplicadas das classes de resposta--> |
| 279 | 321 | ||
| 280 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
322 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
| 281 | 323 | ||
| 282 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
324 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 325 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioImpl" discriminator-value="OlapStarFactQuestionarioImpl"/> |
|
| 283 | 326 | ||
| 284 | 327 | ||
| 285 | </class> |
328 | </class> |
| 286 | 329 | ||
| 287 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswer" table="olap_star_quest_answer"> |
330 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswer" table="olap_star_quest_answer" abstract="true"> |
| 288 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
331 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 332 | <meta attribute="scope-class">public abstract</meta> |
|
| 289 | <id name="id" type="long" unsaved-value="0"> |
333 | <id name="id" type="long" unsaved-value="0"> |
| 290 | <generator class="native"/> |
334 | <generator class="native"/> |
| 291 | </id> |
335 | </id> |
| - | 336 | <discriminator column="discrimitator"/> |
|
| 292 | <property name="dataEvento" type="timestamp"/> |
337 | <property name="dataEvento" type="timestamp"/> |
| 293 | <property name="tempoLevado" type="long"/> |
338 | <property name="tempoLevado" type="long"/> |
| 294 | <property name="ordemResposta" type="int"/> |
339 | <property name="ordemResposta" type="int"/> |
| 295 | <property name="intResposta" type="int" index="intResponseIndex"/> |
340 | <property name="intResposta" type="int" index="intResponseIndex"/> |
| 296 | 341 | ||
| Line 306... | Line 351... | ||
| 306 | <!--Desmultiplicadas das classes de resposta--> |
351 | <!--Desmultiplicadas das classes de resposta--> |
| 307 | <many-to-one name="olapPergunta" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPergunta" outer-join="false" lazy="proxy"/> |
352 | <many-to-one name="olapPergunta" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPergunta" outer-join="false" lazy="proxy"/> |
| 308 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
353 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
| 309 | 354 | ||
| 310 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
355 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 356 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswerImpl" discriminator-value="OlapStarFactQuestionarioAnswerImpl"/> |
|
| 311 | 357 | ||
| 312 | 358 | ||
| 313 | </class> |
359 | </class> |
| 314 | 360 | ||
| 315 | 361 | ||
| 316 | 362 | ||
| 317 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswerEsforco" table="olap_star_quest_answer_esforco"> |
363 | <class name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswerEsforco" table="olap_star_quest_answer_esforco" abstract="true"> |
| 318 | <meta attribute="extends">pt.estgp.estgweb.domain.DomainObject</meta> |
364 | <meta attribute="extends">pt.estgp.estgweb.domain.OlapFactImpl</meta> |
| - | 365 | <meta attribute="scope-class">public abstract</meta> |
|
| 319 | <id name="id" type="long" unsaved-value="0"> |
366 | <id name="id" type="long" unsaved-value="0"> |
| 320 | <generator class="native"/> |
367 | <generator class="native"/> |
| 321 | </id> |
368 | </id> |
| - | 369 | <discriminator column="discrimitator"/> |
|
| 322 | <property name="dataEvento" type="timestamp"/> |
370 | <property name="dataEvento" type="timestamp"/> |
| 323 | <property name="tempoLevado" type="long"/> |
371 | <property name="tempoLevado" type="long"/> |
| 324 | <property name="ordemResposta" type="int"/> |
372 | <property name="ordemResposta" type="int"/> |
| 325 | <property name="intResposta" type="int" index="intResponseIndex"/> |
373 | <property name="intResposta" type="int" index="intResponseIndex"/> |
| 326 | 374 | ||
| Line 336... | Line 384... | ||
| 336 | <!--Desmultiplicadas das classes de resposta--> |
384 | <!--Desmultiplicadas das classes de resposta--> |
| 337 | <many-to-one name="olapPerguntaEsforco" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaEsforco" outer-join="false" lazy="proxy"/> |
385 | <many-to-one name="olapPerguntaEsforco" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaEsforco" outer-join="false" lazy="proxy"/> |
| 338 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
386 | <many-to-one name="olapPerfilUser" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUser" outer-join="false" lazy="proxy"/> |
| 339 | 387 | ||
| 340 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
388 | <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/> |
| - | 389 | <subclass name="pt.estgp.estgweb.domain.OlapStarFactQuestionarioAnswerEsforcoImpl" discriminator-value="OlapStarFactQuestionarioAnswerEsforcoImpl"/> |
|
| 341 | 390 | ||
| 342 | 391 | ||
| 343 | </class> |
392 | </class> |
| 344 | 393 | ||
| 345 | 394 | ||