<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<!-- 
 * Licensed to The Apereo Foundation under one or more contributor license
 * agreements. See the NOTICE file distributed with this work for
 * additional information regarding copyright ownership.
 *
 * The Apereo Foundation licenses this file to you under the Apache License,
 * Version 2.0 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at:
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * 
 -->
<hibernate-mapping package="org.unitime.timetable.model">
    <class name="StudentAreaClassificationMajor" table="student_area_clasf_major">
        <cache include="non-lazy" usage="transactional"/>
        <id
            name="uniqueId"
            column="uniqueid"
            type="java.lang.Long">
            <generator class="org.unitime.commons.hibernate.id.UniqueIdGenerator">
                <param name="sequence">pref_group_seq</param>
            </generator>
        </id>

        <many-to-one
            name="student"
            class="Student"
            column="student_id"
            not-null="true"
            foreign-key="fk_student_acmaj_student"/>

        <many-to-one
            name="academicArea"
            class="AcademicArea"
            column="acad_area_id"
            not-null="true"
            foreign-key="fk_student_acmaj_area"/>
            
        <many-to-one
            name="academicClassification"
            class="AcademicClassification"
            column="acad_clasf_id"
            not-null="true"
            foreign-key="fk_student_acmaj_clasf"/>

        <many-to-one
            name="major"
            class="PosMajor"
            column="major_id"
            not-null="true"
            foreign-key="fk_student_acmaj_major"/>
            
        <many-to-one
            name="concentration"
            class="PosMajorConcentration"
            column="concentration_id"
            not-null="false"
            foreign-key="fk_student_acmaj_conc"/>

        <many-to-one
            name="degree"
            class="Degree"
            column="degree_id"
            not-null="false"
            foreign-key="fk_student_acmaj_deg"/>
            
        <many-to-one
            name="program"
            class="Program"
            column="program_id"
            not-null="false"
            foreign-key="fk_student_acmaj_prog"/>

        <many-to-one
            name="campus"
            class="Campus"
            column="campus_id"
            not-null="false"
            foreign-key="fk_student_acmaj_campus"/>

        <property
            name="weight"
            column="weight"
            type="java.lang.Double"
            not-null="false"/>
    </class>
    <class name="StudentAreaClassificationMinor" table="student_area_clasf_minor">
        <cache include="non-lazy" usage="transactional"/>
        <id
            name="uniqueId"
            column="uniqueid"
            type="java.lang.Long">
            <generator class="org.unitime.commons.hibernate.id.UniqueIdGenerator">
                <param name="sequence">pref_group_seq</param>
            </generator>
        </id>

        <many-to-one
            name="student"
            class="Student"
            column="student_id"
            not-null="true"
            foreign-key="fk_student_acmin_student"/>

        <many-to-one
            name="academicArea"
            class="AcademicArea"
            column="acad_area_id"
            not-null="true"
            foreign-key="fk_student_acmin_area"/>
            
        <many-to-one
            name="academicClassification"
            class="AcademicClassification"
            column="acad_clasf_id"
            not-null="true"
            foreign-key="fk_student_acmin_clasf"/>

        <many-to-one
            name="minor"
            class="PosMinor"
            column="minor_id"
            not-null="true"
            foreign-key="fk_student_acmin_minor"/>
    </class>    
</hibernate-mapping>