File: /var/www/html/unitime/JavaSource/RefTableEntry.hbm.xml
<?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="RefTableEntry" abstract="true">
<cache usage="transactional"/>
<id
name="uniqueId"
column="uniqueid"
type="java.lang.Long">
<generator class="org.unitime.commons.hibernate.id.UniqueIdGenerator">
<param name="sequence">ref_table_seq</param>
</generator>
</id>
<property
name="reference"
column="reference"
type="string"
not-null="true"
length="20"
unique="true"/>
<property
name="label"
column="label"
type="string"
not-null="false"
length="60"
unique="true"/>
<union-subclass
name="DistributionType"
table="distribution_type"
abstract="false">
<property
name="sequencingRequired"
column="sequencing_required"
type="boolean"
not-null="true"/>
<property
name="requirementId"
column="req_id"
type="java.lang.Integer"
not-null="true"/>
<property
name="allowedPref"
column="allowed_pref"
type="java.lang.String"
length="10"/>
<property
name="descr"
column="description"
type="java.lang.String"
length="2048"/>
<property
name="abbreviation"
column="abbreviation"
type="java.lang.String"/>
<property
name="instructorPref"
column="instructor_pref"
type="java.lang.Boolean"
not-null="true"/>
<property
name="examPref"
column="exam_pref"
type="java.lang.Boolean"
not-null="true"/>
<property
name="visible"
column="visible"
type="java.lang.Boolean"
not-null="true"/>
<property
name="survey"
column="survey"
type="java.lang.Boolean"
not-null="false"/>
<set
name="departments"
table="dist_type_dept"
inverse="false">
<cache include="non-lazy" usage="transactional"/>
<key column="dist_type_id"/>
<many-to-many
class="Department"
column="dept_id"
foreign-key="fk_dist_type_dept_dept"/>
</set>
</union-subclass>
<union-subclass
name="DemandOfferingType"
table="demand_offr_type"
abstract="false"/>
<union-subclass
name="OfferingConsentType"
table="offr_consent_type"
abstract="false">
<property
name="abbv"
column="abbv"
type="java.lang.String"
not-null="true"
length="20"/>
</union-subclass>
<union-subclass
name="CourseCreditFormat"
table="crse_credit_format"
abstract="false">
<property
name="abbreviation"
column="abbreviation"
type="java.lang.String"
length="10"/>
</union-subclass>
<union-subclass
name="CourseCreditType"
table="course_credit_type"
abstract="false">
<property
name="legacyCourseMasterCode"
column="legacy_crse_master_code"
type="java.lang.String"
length="10"/>
<property
name="abbreviation"
column="abbreviation"
type="java.lang.String"
length="10"/>
</union-subclass>
<union-subclass
name="CourseCreditUnitType"
table="course_credit_unit_type"
abstract="false">
<property
name="abbreviation"
column="abbreviation"
type="java.lang.String"/>
</union-subclass>
<union-subclass
name="PositionType"
table="position_type"
abstract="false">
<property
name="sortOrder"
column="sort_order"
type="java.lang.Integer"
not-null="true"/>
</union-subclass>
<union-subclass
name="DepartmentStatusType"
table="dept_status_type"
abstract="false">
<property
name="status"
column="status"
type="java.lang.Integer"
not-null="true"/>
<property
name="apply"
column="apply"
type="java.lang.Integer"
not-null="true"/>
<property
name="ord"
column="ord"
type="java.lang.Integer"
not-null="true"/>
</union-subclass>
<union-subclass
name="RoomType"
table="room_type"
abstract="false">
<property
name="ord"
column="ord"
type="java.lang.Integer"
not-null="true"/>
<property
name="room"
column="is_room"
type="java.lang.Boolean"
not-null="true"/>
</union-subclass>
<union-subclass
name="StudentSectioningStatus"
table="sectioning_status"
abstract="false">
<property
name="status"
column="status"
type="java.lang.Integer"
not-null="true"/>
<property
name="message"
column="message"
type="java.lang.String"
not-null="false"
length="500"/>
<set
name="types"
table="sectioning_course_types"
lazy="true">
<cache include="non-lazy" usage="transactional"/>
<key column="sectioning_status_id" foreign-key="fk_sect_course_status"/>
<many-to-many
class="CourseType"
column="course_type_id"
foreign-key="fk_sect_course_type"/>
</set>
<many-to-one
name="fallBackStatus"
class="StudentSectioningStatus"
column="fallback_id"
not-null="false"
foreign-key="fk_sct_status_fallback"/>
<property
name="effectiveStartDate"
column="start_date"
type="java.sql.Timestamp"
not-null="false"/>
<property
name="effectiveStopDate"
column="stop_date"
type="java.sql.Timestamp"
not-null="false"/>
<property
name="effectiveStartPeriod"
column="start_slot"
type="java.lang.Integer"
not-null="false"/>
<property
name="effectiveStopPeriod"
column="stop_slot"
type="java.lang.Integer"
not-null="false"/>
<property
name="notifications"
column="notifications"
type="java.lang.Integer"
not-null="false"/>
<many-to-one
name="session"
class="Session"
column="session_id"
not-null="false"
foreign-key="fk_sct_status_session"
lazy="proxy"/>
</union-subclass>
<union-subclass name="ExamType"
table="exam_type"
abstract="false">
<property
name="type"
column="xtype"
type="java.lang.Integer"
not-null="true"/>
<property
name="highlightInEvents"
column="events"
type="java.lang.Boolean"
not-null="true"/>
</union-subclass>
<union-subclass name="RoomFeatureType"
table="feature_type"
abstract="false">
<property
name="showInEventManagement"
column="events"
type="java.lang.Boolean"
not-null="true"/>
<property
name="showInInstructorSurvey"
column="survey"
type="java.lang.Boolean"
not-null="true"/>
</union-subclass>
<union-subclass name="CourseType"
table="course_type"
abstract="false">
</union-subclass>
<union-subclass name="ClassDurationType" table="duration_type" abstract="false">
<property
name="abbreviation"
column="abbreviation"
type="string"
not-null="true"
length="20"/>
<property
name="implementation"
column="implementation"
type="string"
not-null="true"
length="255"/>
<property
name="parameter"
column="parameter"
type="string"
not-null="false"
length="200"/>
<property
name="visible"
column="visible"
type="boolean"/>
</union-subclass>
<union-subclass name="AttachmentType" table="attachment_type" abstract="false">
<property
name="abbreviation"
column="abbreviation"
type="string"
not-null="true"
length="20"/>
<property
name="visibility"
column="visibility"
type="java.lang.Integer"
not-null="true"/>
</union-subclass>
<union-subclass name="InstructionalMethod" table="instructional_method" abstract="false">
<property
name="visible"
column="visible"
type="boolean"/>
</union-subclass>
<union-subclass name="InstructorAttributeType"
table="attribute_type"
abstract="false">
<property
name="conjunctive"
column="conjunctive"
type="java.lang.Boolean"
not-null="true"/>
<property
name="required"
column="required"
type="java.lang.Boolean"
not-null="true"/>
</union-subclass>
<union-subclass name="TeachingResponsibility" table="teaching_responsibility" abstract="false">
<property
name="coordinator"
column="coordinator"
type="java.lang.Boolean"
not-null="true"/>
<property
name="instructor"
column="instructor"
type="java.lang.Boolean"
not-null="true"/>
<property
name="abbreviation"
column="abbreviation"
type="string"
not-null="false"
length="40"/>
<property
name="options"
column="options"
type="java.lang.Integer"
not-null="true"/>
</union-subclass>
<union-subclass name="StudentGroupType" table="std_group_type" abstract="false">
<property
name="keepTogether"
column="together"
type="java.lang.Boolean"
not-null="true"/>
<property
name="allowDisabled"
column="allow_disabled"
type="java.lang.Short"
not-null="true"/>
<property
name="advisorsCanSet"
column="advisor"
type="java.lang.Boolean"
not-null="true"/>
</union-subclass>
<union-subclass name="OverrideType" table="override_type" abstract="false"/>
<union-subclass name="ContactCategory" table="contact_category" abstract="false">
<property
name="message"
column="message"
type="string"
not-null="false"
length="2048"/>
<property
name="hasRole"
column="has_role"
type="java.lang.Boolean"
not-null="true"/>
<property
name="email"
column="email"
type="java.lang.String"
not-null="false"
length="1000"/>
</union-subclass>
<union-subclass name="LearningManagementSystemInfo" table="learn_mgmt_sys_info" abstract="false">
<property
name="externalUniqueId"
column="external_uid"
type="java.lang.String"
not-null="false"
length="40"/>
<property
name="defaultLms"
column="default_lms"
type="java.lang.Boolean"
not-null="true"/>
<many-to-one
name="session"
class="Session"
column="session_id"
not-null="true"/>
</union-subclass>
<union-subclass name="Degree" table="degree" abstract="false">
<property
name="externalUniqueId"
column="external_uid"
type="java.lang.String"
not-null="false"
length="40"/>
<many-to-one
name="session"
class="Session"
column="session_id"
not-null="true"
foreign-key="fk_degree_session"/>
</union-subclass>
<union-subclass name="Program" table="program" abstract="false">
<property
name="externalUniqueId"
column="external_uid"
type="java.lang.String"
not-null="false"
length="40"/>
<many-to-one
name="session"
class="Session"
column="session_id"
not-null="true"
foreign-key="fk_program_session"/>
</union-subclass>
<union-subclass name="Campus" table="campus" abstract="false">
<property
name="externalUniqueId"
column="external_uid"
type="java.lang.String"
not-null="false"
length="40"/>
<many-to-one
name="session"
class="Session"
column="session_id"
not-null="true"
foreign-key="fk_campus_session"/>
</union-subclass>
<union-subclass name="InstructorCourseRequirementType" table="instr_crsreq_note_type" abstract="false">
<property
name="length"
column="length"
type="java.lang.Integer"
not-null="true"/>
<property
name="sortOrder"
column="sort_order"
type="java.lang.Integer"
not-null="true"/>
</union-subclass>
</class>
</hibernate-mapping>