Subversion Repositories bacoAlunos

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
       PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
       "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="pt.estgp.estgweb.domain.OlapHistoryDimension" table="olap_e_timeline">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="nome" type="string"/>
        <property name="descricao" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaGrupo" table="olap_e_quest_pgrp">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="nome" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioAnswered" table="olap_e_quest_answer">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="answered" type="boolean"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioAnswer" table="olap_e_quest_pgrp">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="answerStr" type="string" index="answerStrIndex"/>
        <property name="answerInt" type="integer" index="answerIntIndex"/>
    </class>
    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioAno" table="olap_e_quest_ano">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="ano" type="string"/>
    </class>
    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioPeriodo" table="olap_e_quest_periodo">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="semestre" type="string"/>
    </class>
    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioCursoDegree" table="olap_e_quest_curso_degree">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="degree" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" table="olap_e_quest_curso">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="long"/>
        <property name="nome" type="string"/>
    </class>
    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" table="olap_e_quest_unit">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="long"/>
        <property name="nome" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioInstituicao" table="olap_e_quest_inst">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="long"/>
        <property name="nome" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioTurma" table="olap_e_quest_turma">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioDocente" table="olap_e_quest_docente">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="string"/>
        <property name="nome" type="string"/>
        <property name="bi" type="string"/>
        <property name="username" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" table="olap_e_quest_tipologia">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="codigo" type="string"/>
        <property name="nome" type="string"/>
    </class>

    <class name="pt.estgp.estgweb.domain.OlapStarQuestionario" table="olap_star_quest">
        <id name="id" type="long" unsaved-value="0">
            <generator class="native"/>
        </id>
        <property name="pergunta" type="string"/>
        <property name="resposta" type="int"/>
        <many-to-one name="tipologia" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTipologia" outer-join="false" lazy="proxy"/>
        <many-to-one name="docente" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioDocente" outer-join="false" lazy="proxy"/>
        <many-to-one name="turma" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioTurma" outer-join="false" lazy="proxy"/>
        <many-to-one name="instituicao" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioInstituicao" outer-join="false" lazy="proxy"/>
        <many-to-one name="unidade" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioUnidade" outer-join="false" lazy="proxy"/>
        <many-to-one name="curso" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCurso" outer-join="false" lazy="proxy"/>
        <many-to-one name="cursoDegree" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioCursoDegree" outer-join="false" lazy="proxy"/>
        <many-to-one name="ano" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioAno" outer-join="false" lazy="proxy"/>
        <many-to-one name="periodo" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPeriodo" outer-join="false" lazy="proxy"/>
        <many-to-one name="perguntaGrupo" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioPerguntaGrupo" outer-join="false" lazy="proxy"/>
        <many-to-one name="perguntaAnswer" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioAnswer" outer-join="false" lazy="proxy"/>
        <!-- Um facto para o questionario respondido outro para o questionario nao respondido -->
        <many-to-one name="perguntaAnswered" class="pt.estgp.estgweb.domain.OlapEntityQuestionarioAnswered" outer-join="false" lazy="proxy"/>
        <!--Assim e possivel Filtrar por questionario uso a dimensao questionario-->
        <many-to-one name="questionario" class="pt.estgp.estgweb.domain.Questionario" outer-join="false" lazy="proxy"/>
        <!--Se quiser usar factos historicos preciso de uma dimensao onde estejam todas as respostas dos questionarios pedagogicos-->
        <many-to-one name="timeLine" class="pt.estgp.estgweb.domain.OlapHistoryDimension" outer-join="false" lazy="proxy"/>
    </class>

</hibernate-mapping>