Hibernate Mapping Documentation

List of Tables for Schema: OPMS

Tables
AUDIT_TRAIL
Name SQL Type Nullable Unique
AUDIT_ID number(19,0) false false
PERSON_MAKING_CHANGE_ID number(19,0) false false
PROJECT_BEING_CHANGED_ID number(19,0) false false
REASON clob true false
DATE_ALTERED date true false
ITEM_CHANGED varchar2(128) false false
OLD_VALUE_OF_ITEM clob true false
NEW_VALUE_OF_ITEM clob true false
TIME_ALTERED date true false
BIN$AeseGy8152HgQMWUJihA0g==$0
Name SQL Type Nullable Unique
UNIT_ID number(22,0) false false
UNIT_CODE varchar2(16) false false
UNIT_NAME varchar2(50) false false
BIN$AeseGy8i52HgQMWUJihA0g==$0
Name SQL Type Nullable Unique
STAFF_NO varchar2(16) false false
PERSON_ID number(22,0) true false
BIN$AeseGy8j52HgQMWUJihA0g==$0
Name SQL Type Nullable Unique
STATUS_CODE varchar2(3) true false
STATUS varchar2(100) true false
BIN$AeseGy8o52HgQMWUJihA0g==$0
Name SQL Type Nullable Unique
TELEPHONE_NUMBER_ID number(22,0) false false
PERSON_ID number(22,0) true false
TEL_NUMBER varchar2(20) false false
BIN$AeseGy8v52HgQMWUJihA0g==$0
Name SQL Type Nullable Unique
STUDENT_ID number(22,0) false false
HEMIS_NO varchar2(16) false false
PERSON_ID number(22,0) true false
DEGREE_STREAM varchar2(16) false false
FINAL_YEAR varchar2(16) false false
CATEGORY_MARKS
Name SQL Type Nullable Unique
CAT_MARK_ID number(19,0) false true
MARK_ID number(19,0) false false
CAT_ID number(19,0) false false
MARK number(19,0) false false
CAT_COMMENT clob true false
CATEGORY_OPTIONS
Name SQL Type Nullable Unique
OPT_ID number(19,0) false true
OPT_LABEL varchar2(30) false false
OPT_SELECTED_VALUE number(19,0) false false
OPT_GROUP number(19,0) false false
OPT_INDEX number(19,0) false false
CATEGORY_OPTION_CRITERIA
Name SQL Type Nullable Unique
OPT_CRITERIA_ID number(19,0) false true
MARK_CATEGORY number(19,0) false false
POSITIVE_CRITERIA clob true false
NEGATIVE_CRITERIA clob true false
CAT_OPTION number(19,0) false false
CATEGORY_OPTION_GROUPS
Name SQL Type Nullable Unique
OPT_GROUP_ID number(19,0) false true
OPT_GROUP_NAME varchar2(64) true false
COHORT
Name SQL Type Nullable Unique
COHORT_ID number(19,0) false true
COHORT_DESCRIPTION varchar2(128) false false
PROJECT_START_DATE date true false
PROJECT_END_DATE date true false
COHORT_CLOSED varchar2(1) true false
COHORT_COORDINATORS
Name SQL Type Nullable Unique
CO_CORD_ID number(19,0) false true
COHORT_ID number(19,0) false false
PERSON_ID number(19,0) false false
CONTACTS
Name SQL Type Nullable Unique
ORGADDR varchar2(100) true false
ORGCONTACT varchar2(50) true false
ORGDOES varchar2(50) true false
ORGEMAIL varchar2(50) true false
ORGID number(19,0) false true
ORGNAME varchar2(50) true false
ORGPOSTCODE varchar2(10) true false
ORGTEL varchar2(20) true false
EMAILMESSAGES
Name SQL Type Nullable Unique
MAILKEY varchar2(30) false false
MAILVALUE clob true false
MAILSTRING varchar2(4000) true false
EMAILS
Name SQL Type Nullable Unique
EMAIL varchar2(100) false false
USERID clob true false
FINAL_PROJECT
Name SQL Type Nullable Unique
PROJECT_ID number(19,0) false true
STUDENT_ID number(19,0) false false
COHORT_ID number(19,0) false false
UNIT_ID number(19,0) false false
PROJECT_TITLE varchar2(50) false false
PROJECT_SUBMITTED_DATE date true false
LATE_HAND_IN varchar2(1) true false
UNIT_EXAM_BOARD_DECISION date true false
PROJECT_STATUS varchar2(3) true false
PROJECT_MARK number(19,0) true false
PROJECT_COMMENTS clob true false
IDEAS2
Name SQL Type Nullable Unique
PROJAIMS clob true false
PROJAPPROVED varchar2(1) true false
PROJDATE date true false
PROJDELIVER clob true false
PROJID number(19,0) false true
PROJORG number(19,0) true false
PROJQUEST clob true false
PROJSTUDENT varchar2(100) true false
PROJTITLE varchar2(100) true false
MARKER_CAPACITY
Name SQL Type Nullable Unique
MARKER_CAPACITY_ID number(19,0) false true
PROJECT_ID number(19,0) false false
MARKER_TYPE_ID number(19,0) false false
PERSON_ID number(19,0) false false
ALLOCATED_DATE date true false
UNALLOCATED_DATE date true false
MARKER_TYPE
Name SQL Type Nullable Unique
MARKER_TYPE_ID number(19,0) false true
MARKER_DESCRIPTION varchar2(64) false false
MARKS
Name SQL Type Nullable Unique
MARK_ID number(19,0) false true
PROJECT_ID number(19,0) false false
MARKER_CAPACITY_ID number(19,0) false false
MARK number(19,0) false false
MARK_DATE date true false
GENERAL_COMMENTS clob true false
COMMENTS_FOR_EXAMINERS clob true false
GENERAL_COMMENTS_EXAMBOARD clob true false
PLAGIARISM_UNFAIR_ACT varchar2(1) true false
PLAGIARISM_COMMENTS clob true false
UNFAIR_ACT_NOTES clob true false
ADJUSTMENT_APPLIED number(19,0) true false
PLAGIARISM_SUSPECT varchar2(1) true false
MARK_CATEGORIES
Name SQL Type Nullable Unique
CATBEGIN date false false
CATDESCRIPTION clob true false
CATEND date true false
CATID number(19,0) false true
CATLONGNAME varchar2(100) false false
CATNAME varchar2(30) false false
COG_ID number(19,0) false false
OPTION_TYPE varchar2(1) false false
MARK_FORMS
Name SQL Type Nullable Unique
FORMBEGIN date true false
FORMEND date true false
FORMID number(19,0) false true
FORMNAME varchar2(255) false false
MARK_FORM_CATEGORIES
Name SQL Type Nullable Unique
CATID number(19,0) false false
CATINDEX number(19,0) true false
CATWEIGHT number(19,0) true false
FORMID number(19,0) false false
MFCBEGIN date true false
MFCEND date true false
MFCID number(19,0) false true
OPTIONAL varchar2(1) true false
OPTION_MARKS
Name SQL Type Nullable Unique
OPT_MARK_ID number(19,0) false true
MARK_ID number(19,0) false false
CAT_ID number(19,0) false false
CO_ID number(19,0) false false
PERSON
Name SQL Type Nullable Unique
PERSON_ID number(19,0) false true
USER_NAME varchar2(16) true false
PWD varchar2(16) true false
FIRST_NAME varchar2(64) false false
SURNAME varchar2(64) false false
INACTIVE varchar2(1) true false
PERSON_EMAIL
Name SQL Type Nullable Unique
E_MAIL_ID number(19,0) false true
PERSON_ID number(19,0) false false
E_MAIL_ADD varchar2(128) false false
E_MAIL_SUSPENDED varchar2(1) true false
PERSON_ROLES
Name SQL Type Nullable Unique
ROLE number(19,0) false false
PERSON_ID number(19,0) false false
PRIZE_CATEGORIES
Name SQL Type Nullable Unique
PRIZE_CAT_ID number(19,0) false true
PRIZE_CAT_NAME varchar2(16) false false
PRIZE_VALUE number(19,0) true false
PRIZE_CAT_CRITERIA clob true false
PRIZE_NOMINATIONS
Name SQL Type Nullable Unique
PRIZE_NOM_ID number(19,0) false true
PRIZE_CAT_ID number(19,0) false false
MARK_ID number(19,0) false false
SUPPORTING_COMMENTS clob true false
ROLES
Name SQL Type Nullable Unique
ROLE_ID number(19,0) false true
ROLE_DESCRIPTION varchar2(32) false false
STAFF
Name SQL Type Nullable Unique
STAFF_NO varchar2(16) false true
PERSON_ID number(19,0) false false
STATUSES
Name SQL Type Nullable Unique
STATUS_CODE varchar2(3) true false
STATUS varchar2(100) true false
STUDENT
Name SQL Type Nullable Unique
STUDENT_ID number(19,0) false true
HEMIS_NO number(19,0) false false
PERSON_ID number(19,0) false false
DEGREE_STREAM varchar2(16) false false
FINAL_YEAR varchar2(16) false false
TEL_NUMBER
Name SQL Type Nullable Unique
TELEPHONE_NUMBER_ID number(19,0) false true
PERSON_ID number(19,0) false false
TEL_NUMBER varchar2(20) false false
UNIT
Name SQL Type Nullable Unique
UNIT_ID number(19,0) false true
UNIT_CODE varchar2(16) false false
UNIT_NAME varchar2(50) false false
ACADEMIC_YR_FIRST_RUN date true false
ACADEMIC_YR_LAST_RUN date true false
UNIT_MARK_FORMS
Name SQL Type Nullable Unique
UMFID number(19,0) false true
UNIT_ID number(19,0) false false
FORM_ID number(19,0) false false
UMFBEGIN date false false
UMFEND date true false