<?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="ExamStatus" table="exam_status">
        <cache include="non-lazy" usage="transactional"/>
        
        <composite-id>
            <key-many-to-one
                name="session"
            	class="Session"
            	column="session_id"
	            foreign-key="fk_xstatus_session"/>

            <key-many-to-one
                name="type"
            	class="ExamType"
            	column="type_id"
            	foreign-key="fk_xstatus_type"/>
        </composite-id>

        <many-to-one
            name="status"
            class="DepartmentStatusType"
            column="status_id"
            not-null="false"
            foreign-key="fk_xstatus_status"/>

        <set
            name="managers"
            table="exam_managers"
            inverse="false"
            lazy="true">

            <cache include="non-lazy" usage="transactional"/>
            <key foreign-key="fk_xmanagers_status">
            	<column name="session_id"/>
            	<column name="type_id"/>
            </key>
            <many-to-many class="TimetableManager" column="manager_id" foreign-key="fk_xmanagers_manager"/>
        </set>
	</class>
</hibernate-mapping>