AUDIT_TRAIL
|
|
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
|
|
BIN$AeseGy8v52HgQMWUJihA0g==$0
|
|
CATEGORY_MARKS
|
|
CATEGORY_OPTIONS
|
|
CATEGORY_OPTION_CRITERIA
|
|
CATEGORY_OPTION_GROUPS
|
|
COHORT
|
|
COHORT_COORDINATORS
|
|
CONTACTS
|
|
EMAILMESSAGES
|
|
EMAILS
|
Name
|
SQL Type
|
Nullable
|
Unique
|
EMAIL
|
varchar2(100)
|
false
|
false
|
USERID
|
clob
|
true
|
false
|
|
FINAL_PROJECT
|
|
IDEAS2
|
|
MARKER_CAPACITY
|
|
MARKER_TYPE
|
|
MARKS
|
|
MARK_CATEGORIES
|
|
MARK_FORMS
|
|
MARK_FORM_CATEGORIES
|
|
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
|
|
PERSON_EMAIL
|
|
PERSON_ROLES
|
Name
|
SQL Type
|
Nullable
|
Unique
|
ROLE
|
number(19,0)
|
false
|
false
|
PERSON_ID
|
number(19,0)
|
false
|
false
|
|
PRIZE_CATEGORIES
|
|
PRIZE_NOMINATIONS
|
|
ROLES
|
|
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
|
|
TEL_NUMBER
|
|
UNIT
|
|
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
|
|