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.CourseUnit" table="courseunit" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="lastImportDate" type="timestamp"/>

        <property name="semestre" type="string" index="semestreIndex"/>

        <property name="name" type="string" index="nameIndex"/>

        <property name="code" type="string" index="codeIndex"/>

        <property name="courseCode" type="string" index="courseCodeIndex"/>

        <property name="courseName" type="string" index="courseNameIndex"/>

        <property name="courseYear" type="string" index="courseYearIndex"/>

        <property name="importYear" type="string" index="importYearIndex"/>

        <property name="sumariesSemestre" type="string"/><!--Campo para normalizar sumarios de unidades que foram sumariadas no semestre diferente no SIGES-->

        <property name="pathIntranet" type="string" />

        <property name="normalizedName" type="string" />

        <property name="objectives" type="text"/>

        <property name="programStreamId" type="string" index="programStreamIdIndex" />

        <property name="validProgram" type="boolean" index="validProgramIndex"/>

        <property name="status" type="boolean" index="statusIndex" />

        <property name="contentsGrants" type="string"/>

        <!--Tipologias-->

        <!--Pares Turma-Docente-Tipologia usa a classe Tipologias com serializacao-->

        <property name="tipologias" type="string">

            <column name="tipologias" sql-type="text"/>

        </property>

        <!--Tipologias-->

        <property name="evaluationStreamId" type="string" index="evaluationStreamIdIndex" />

        <property name="evaluationOpenByAdmin" type="boolean" index="evaluationOpenByAdminIndex">

            <column name="evaluationOpenByAdmin" default="false"/>

        </property>

        <property name="summariesJson" type="text">

            <column name="summariesJson" sql-type="MEDIUMTEXT"/>

        </property>

        <property name="filesJson" type="text">

            <column name="filesJson" sql-type="LONGTEXT" default="null"/>

        </property>

        <!-- CourseUnit Statistics -->

        <property name="statteachersCount" type="int">

            <column name="statteachersCount" default="0"/>

        </property>

        <property name="statstudentsCount" type="int">

            <column name="statstudentsCount" default="0"/>

        </property>

        <property name="statcontentsFiles" type="int">

            <column name="statcontentsFiles" default="0"/>

        </property>

        <property name="statcontentsFolders" type="int">

            <column name="statcontentsFolders" default="0"/>

        </property>

        <property name="statcontentsSize" type="long">

            <column name="statcontentsSize" default="0"/>

        </property>

        <property name="statcontentsLastUpdate" type="timestamp"/>

        <property name="statworks" type="int">

            <column name="statworks" default="0"/>

        </property>

        <property name="statanuncios" type="int">

            <column name="statanuncios" default="0"/>

        </property>

        <property name="statblogPosts" type="int">

            <column name="statblogPosts" default="0"/>

        </property>

        <property name="statdtpSumaries" type="int">

            <column name="statdtpSumaries" default="0"/>

        </property>

        <property name="statdtpSumariesMissing" type="int">

            <column name="statdtpSumariesMissing" default="0"/>

        </property>

        <property name="statdtpSumariesPrelancados" type="int">

            <column name="statdtpSumariesPrelancados" default="0"/>

        </property>

        <property name="statdtpPlaneamentoFiles" type="int">

            <column name="statdtpPlaneamentoFiles" default="0"/>

        </property>

        <property name="statdtpPlaneamentoLastUpdate" type="timestamp"/>

        <property name="statdtpFichaCurricularValid" type="boolean">

            <column name="statdtpFichaCurricularValid" default="false"/>

        </property> <!--refere para o campo ficha válida coloca-se apenas o GET no IMPL-->

        <property name="statdtpFichaCurricularLastUpdate" type="timestamp"/>

        <property name="statdtpEvaluationReportState" type="string"/> <!-- VALIDO,ENTREGUE,INICIADO,INEXISTENTE refere para o campo relatorio de avaliação válido coloca-se apenas o GET no IMPL-->

        <property name="statdtpEvaluationReportLastUpdate" type="timestamp"/>

        <property name="statdtpInqueritoPedagogicoFiles" type="int">

            <column name="statdtpInqueritoPedagogicoFiles" default="0"/>

        </property>

        <property name="statdtpInqueritoPedagogicoFilesLastUpdate" type="timestamp"/>

        <property name="statdtpAvaliacaoEnunciadosFiles" type="int">

            <column name="statdtpAvaliacaoEnunciadosFiles" default="0"/>

        </property>

        <property name="statdtpAvaliacaoEnunciadosLastUpdate" type="timestamp"/>

        <property name="statdtpAvaliacaoPautasFiles" type="int">

            <column name="statdtpAvaliacaoPautasFiles" default="0"/>

        </property>

        <property name="statdtpAvaliacaoPautasLastUpdate" type="timestamp"/>

        <!--

            Este código de turma apenas é usado nos casos em que o curso é de turmas separadas

            Nesse caso uma cadeira só pode ter uma turma e então a turma é aqui colocada

            As restantes politicas de preenchimento da CourseUnitTurma mantém-se

        -->

        <property name="cdTurma" type="string" index="cdTurmaIndex" />

        <!--Not In Use-->

        <many-to-one name="unitContents" class="pt.estgp.estgweb.domain.PageSection" lazy="proxy" outer-join="false">

            <column name="unitContents"/>

        </many-to-one>

        <many-to-one name="validatorUser" class="pt.estgp.estgweb.domain.User" lazy="false" outer-join="true" />

        <many-to-one name="course" class="pt.estgp.estgweb.domain.Course" lazy="false" outer-join="true"/>

        <many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="proxy" />

        <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="proxy" />

        <!--<many-to-one name="courseUnitProgram" class="pt.estgp.estgweb.domain.CourseUnitProgram" lazy="false" outer-join="true"/>

        <many-to-one name="courseUnitEvaluation" class="pt.estgp.estgweb.domain.CourseUnitEvaluation" lazy="false" outer-join="true"/>-->

        <many-to-one name="responsableTeacher" class="pt.estgp.estgweb.domain.Teacher" lazy="false" outer-join="true" not-null="false"/>

        <set name="blogs" cascade="delete" lazy="true" order-by="saveDate asc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitBlog" />

        </set>

        <set name="teachers" lazy="true" table="teachedunits">

            <key column="courseUnitId"/>

            <many-to-many class="pt.estgp.estgweb.domain.TeacherImpl" column="teacherId"/>

        </set>

        <set name="students" lazy="true" table="subscribedunits">

            <key column="courseUnitId"/>

            <many-to-many class="pt.estgp.estgweb.domain.StudentImpl" column="studentId"/>

        </set>

        <set name="announcements" cascade="delete" lazy="true" order-by="saveDate desc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAnnouncement" />

        </set>

        <set name="questions" cascade="delete" lazy="true" order-by="saveDate desc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitQuestion" />

        </set>

        <set name="assignements" cascade="delete" lazy="true" order-by="deliverDate desc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitAssignement"/>

        </set>

        <set name="summaries" cascade="delete" lazy="true" order-by="dataAula desc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitSummary"/>

        </set>

        <set name="turmas" cascade="delete" lazy="true" order-by="saveDate desc">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitTurma" />

        </set>

        <set name="courseUnitGrades" order-by="publishDate asc" lazy="true">

            <key column="courseUnit"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitGrade"/>

        </set>

        <!--<set name="questionarioReportsDocentes" lazy="true" order-by="id asc" table="questionario_report_file_docente_units">

            <key column="courseunit"/>

            <many-to-many class="pt.estgp.estgweb.domain.QuestionarioReportDocenteFile" column="reportdocentefile" />

        </set>-->

        <subclass name="pt.estgp.estgweb.domain.CourseUnitImpl" discriminator-value="CourseUnitImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitQuestion" table="courseunitquestion" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.OwnedDomainObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="question" type="text"/>

        <property name="answer" type="text"/>

        <property name="answred" type="boolean" index="answredIndex"/>

        <many-to-one name="owner" class="pt.estgp.estgweb.domain.GenericUser" lazy="false" outer-join="true"/>

        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitQuestionImpl" discriminator-value="CourseUnitQuestionImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitAssignement" table="courseunitassignement" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="deliverDate" type="timestamp"/>

        <property name="deliverType" type="string"/>

        <property name="lateDelivers" type="boolean"/>

        <property name="title" type="string"/>

        <property name="description" type="text"/>

        <property name="repositoryStream" type="string" index="repositoryStreamIndex"/>

        <property name="status" type="boolean"/>

        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>

        <set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc">

            <key column="courseUnitAssignement"/>

            <one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/>

        </set>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitDeliverable" table="courseunitdeliverable" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="deliverDate" type="timestamp"/>

        <property name="grade" type="string"/>

        <property name="obs" type="text"/>

        <property name="studentId" type="long"/>

        <property name="studentUsername" type="string"/>

        <property name="studentCode" type="string"/>

        <property name="studentName" type="string"/>

        <property name="deliverableRepositoryStream" type="string" index="deliverableRepositoryStreamIndex"/>

        <many-to-one name="courseUnitAssignement" class="pt.estgp.estgweb.domain.CourseUnitAssignement" lazy="false" outer-join="true"/>

        <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitDeliverableImpl" discriminator-value="CourseUnitDeliverableImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitGrade" table="courseunitgrade" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="publishDate" type="timestamp"/>

        <property name="grade" type="int" index="gradeIndex"/>

        <property name="normalizedCourseUnitName" type="string"/>

        <property name="statusEpoca" type="int" index="statusEpocaIndex"/>

        <property name="descStatusEpoca" type="string"/>

        <property name="descEpoca" type="string" />

        <property name="codigoMomento" type="string" />

        <property name="codigoEpoca" type="string" />

        <property name="importYear" type="string" index="importYearIndex"/>

        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>

        <many-to-one name="student" class="pt.estgp.estgweb.domain.Student" lazy="false" outer-join="true"/>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitGradeImpl" discriminator-value="CourseUnitGradeImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitSummary" table="courseunitsummary" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="dataAula" type="timestamp"/>

        <property name="cdTipoOcupacao" type="int"/>

        <property name="tipoAula" type="string"/>

        <property name="codigoAula" type="string"/>

        <property name="codigoSumario" type="string"/>

        <property name="codigoSalaAula" type="string"/>

        <property name="codigoDocente" type="string"/>

        <property name="alunosPresentes" type="int"/>

        <property name="numeroAula" type="int"/>

        <property name="nrAula" type="int"/>

        <property name="titulo" type="string" index="tituloIndex"/>

        <property name="descricao" type="text"/>

        <property name="cEstado" type="string"/>

        <property name="numeroHoras" type="string"/>

        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitSummaryImpl" discriminator-value="CourseUnitSummaryImpl"/>

    </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitProgram" table="courseunitprogram" abstract="true">

           <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

           <meta attribute="scope-class">public abstract</meta>

           <id name="id" type="long">

               <generator class="native"/>

           </id>

           <discriminator column="discrimitator"/>

           <timestamp   name="updateDate" unsaved-value="null"/>

           <property name="saveDate" type="timestamp"/>

           <property name="bibliografia" type="text"/>

           <property name="bibliografiaComplementar" type="text"/>

           <property name="adaptacaoObjectivosMetodologia" type="text"/>

           <property name="demonstracaoCargaEcts" type="text"/>

           <property name="garantiaAvaliacaoFuncaObjectivos" type="text"/>

           <property name="metodologiasActividadeCientifica" type="text"/>

           <property name="ects" type="string"/>

           <property name="prerequisitos" type="text"/>

           <property name="obrigatoria" type="string"/>

           <property name="lingua1" type="string"/>

           <property name="lingua2" type="string"/>

           <property name="cargaHorariaTotal" type="string"/>

           <property name="cargaHorariaT" type="string"/>

           <property name="cargaHorariaTP" type="string"/>

           <property name="cargaHorariaPL" type="string"/>

           <property name="cargaHorariaS" type="string"/>

           <property name="cargaHorariaTC" type="string"/>

           <property name="cargaHorariaO" type="string"/>

           <property name="cargaHorariaOT" type="string"/>

           <many-to-one name="courseUnitProgramPart2" class="pt.estgp.estgweb.domain.CourseUnitProgramPart2" lazy="false" outer-join="true"/>

           <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramImpl" discriminator-value="CourseUnitProgramImpl"/>

       </class>

       <class name="pt.estgp.estgweb.domain.CourseUnitProgramPart2" table="courseunitprogrampart2" abstract="true">

           <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

           <meta attribute="scope-class">public abstract</meta>

           <id name="id" type="long">

               <generator class="native"/>

           </id>

           <discriminator column="discrimitator"/>

           <timestamp name="updateDate" unsaved-value="null"/>

           <property name="saveDate" type="timestamp"/>

           <property name="objectivos" type="text"/>

           <property name="conteudos" type="text"/>

           <property name="demonstracaoCoerenciaConteudos" type="text"/>

           <property name="metodologiasEnsino" type="text"/>

           <property name="avaliacaoOrdinariosFrequencia" type="text"/>

           <property name="avaliacaoOrdinariosExame" type="text"/>

           <property name="avaliacaoEspeciaisFrequencia" type="text"/>

           <property name="avaliacaoEspeciaissExame" type="text"/>

           <property name="demonstracaoObjectivosMetodologia" type="text"/>

           <subclass name="pt.estgp.estgweb.domain.CourseUnitProgramPart2Impl" discriminator-value="CourseUnitProgramPart2Impl"/>

       </class>

    <class name="pt.estgp.estgweb.domain.CourseUnitEvaluation" table="courseunitevaluation" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="autoGeneratedCourseReport" type="boolean">

            <!-- Autogenerated Evaluations should be writable in CourseReport Evaluation -->

            <column name="autoGeneratedCourseReport" default="false"/>

        </property>

        <property name="closed" type="boolean"/>

        <!-- todo update aos do ano anterior para meter todos os evaluations salvos com teacherComplete = true -->

        <property name="teacherComplete" type="boolean" index="teacherCompleteIndex">

            <column name="teacherComplete" default="true"/>

        </property>

        <property name="numAlunosInscritos" type="int"/>

        <property name="numAlunosSemElementosAvaliacao" type="int"/>

        <property name="numAlunosAprovFrequencia" type="int" />

        <property name="numAlunosAprovNormal" type="int"/>

        <property name="numAlunosAprovRecurso" type="int"/>

        <property name="numAlunosAprovEspecial" type="int"/>

        <property name="numAlunosAprovTotal" type="int"/>

        <property name="numAlunosAprov1013" type="int"/>

        <property name="numAlunosAprov1416" type="int"/>

        <property name="numAlunosAprov1720" type="int"/>

        <property name="numAlunosAprov1013Percent" type="float"/>

        <property name="numAlunosAprov1416Percent" type="float"/>

        <property name="numAlunosAprov1720Percent" type="float"/>

        <property name="numAlunosReprovados" type="int"/>

        <property name="qualApreciacaoQuantitivos" type="text"/>

        <property name="qualApreciacaoUC" type="text"/>

        <property name="cumprimentoProgramaPercent" type="int">

            <column name="cumprimentoProgramaPercent" default="100"/>

        </property>

        <property name="qualApreciacaoCumprimentoPrograma" type="text"/>

        <property name="qualConclusoes" type="text"/>

        <subclass name="pt.estgp.estgweb.domain.CourseUnitEvaluationImpl" discriminator-value="CourseUnitEvaluationImpl"/>

    </class>

    <!-- todo Verificar o serviço de apagar cadeira

        Parece-me que vai sempre haver aqui turmas a menos que se removam

        as turmas quando nao há mais alunos, pelo menos tem de se vir removendo

        daqui as associações aos estudantes e profs quando saiem da lista primária

    -->

    <class name="pt.estgp.estgweb.domain.CourseUnitTurma" table="courseunitturma" abstract="true">

        <meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>

        <meta attribute="scope-class">public abstract</meta>

        <id name="id" type="long">

            <generator class="native"/>

        </id>

        <discriminator column="discrimitator"/>

        <timestamp   name="updateDate" unsaved-value="null"/>

        <property name="saveDate" type="timestamp"/>

        <property name="turma" type="string"/>

        <many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="proxy" outer-join="true">

            <column name="courseUnit"/>

        </many-to-one>

        <set name="students" lazy="true" table="subscribedturmaunits">

            <key column="courseUnitTurmaId"/>

            <many-to-many class="pt.estgp.estgweb.domain.StudentImpl" column="studentId"/>

        </set>

        <!--

        <set name="teachers" lazy="true" table="teachedturmaunits">

            <key column="courseUnitTurmaId"/>

            <many-to-many class="pt.estgp.estgweb.domain.Teacher" column="teacherId"/>

        </set>

        -->

        <subclass name="pt.estgp.estgweb.domain.CourseUnitTurmaImpl" discriminator-value="CourseUnitTurmaImpl"/>

    </class>

    <!--<class name="pt.estgp.estgweb.domain.CourseUnit" table="courseunitassignement" abstract="true">-->

        <!--<meta attribute="extends">pt.estgp.estgweb.domain.DomainSerializableObject</meta>-->

        <!--<meta attribute="scope-class">public abstract</meta>-->

        <!--<id name="id" type="long">-->

            <!--<generator class="native"/>-->

        <!--</id>-->

        <!--<discriminator column="discrimitator"/>-->

        <!--<timestamp   name="updateDate" unsaved-value="null"/>-->

        <!--<property name="saveDate" type="timestamp"/>-->

        <!--<property name="deliverDate" type="timestamp"/>-->

        <!--<property name="deliverType" type="string"/>-->

        <!--<property name="lateDelivers" type="boolean"/>-->

        <!--<property name="title" type="string"/>-->

        <!--<property name="description" type="text"/>-->

        <!--<property name="repositoryStream" type="string" index="repositoryStreamIndex"/>-->

        <!--<property name="status" type="boolean"/>-->

        <!--<many-to-one name="courseUnit" class="pt.estgp.estgweb.domain.CourseUnit" lazy="false" outer-join="true"/>-->

        <!--<set name="deliverables" cascade="delete" lazy="true" order-by="deliverDate asc">-->

            <!--<key column="courseUnitAssignement"/>-->

            <!--<one-to-many class="pt.estgp.estgweb.domain.CourseUnitDeliverable"/>-->

        <!--</set>-->

        <!--<subclass name="pt.estgp.estgweb.domain.CourseUnitAssignementImpl" discriminator-value="CourseUnitAssignementImpl"/>-->

    <!--</class>-->

</hibernate-mapping>