.........................
home
units
doc
.........................
Database Service Data Model
Object Name Index
INDEX
!
#
2
3
>
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Related Pages
Overview
Cluster Index
Table Index
Field Index
Key Index
Link Index
Name Index
Code Index
DB Table Index
DB Column Index
DB Size Statistics
Data Model Home
Home
U
UG/PG Code
Field in the
3g ADMIS-Applicant-Programme-Feed
Table
UG/PG Code
Field in the
3g EUGEX-Institute-Role-Feed
Table
UG/PG Code
Field in the
3g EUGEX-School-Student-Feed
Table
UG/PG Code
Field in the
3g EUGEX-Student-Feed
Table
UG/PG Code
Field in the
MIS-Data
Table
UID
Field in the
3g Person
Table
UID
Field in the
3g Staff 2g
Table
UID
Field in the
GCOS-Action
Table
UID
Field in the
GCOS-Fix
Table
UID
Field in the
GCOS-Update
Table
UID
Field in the
IGO-Person
Table
UID
Field in the
Person
Table
UID
Field in the
Person-UID
Table
UID
Field in the
Public-Person
Table
UID
Field in the
UID-Fix
Table
UID-Action
Table
UID-Fix
Table
UID-Update
Table
UK Cost$
Field in the
3g Paper
Table
UK Cost$
Field in the
Paper
Table
UOCA
Field in the
3g Applicant
Table
UOCA
Field in the
PAVD iE
Table
UOCH
Field in the
3g Applicant
Table
UOCH
Field in the
PAVD iE
Table
URL
Field in the
3g Document
Table
URL
Field in the
3g Teaching Software
Table
URL
Field in the
Document
Table
URL
Field in the
Teaching Software
Table
URL Comment
Field in the
3g Document
Table
URL Comment
Field in the
Document
Table
URL Comment 2
Field in the
3g Document
Table
URL Comment 2
Field in the
Document
Table
URL2
Field in the
3g Document
Table
URL2
Field in the
Document
Table
USR#/UCAS#
Field in the
3g EUGEX-Institute-Role-Feed
Table
USR#/UCAS#
Field in the
3g EUGEX-School-Student-Feed
Table
USR#/UCAS#
Field in the
3g EUGEX-Student-Feed
Table
USR#/UCAS#
Field in the
MIS-Data
Table
UUID
Field in the
3g Prometheus User
Table
UUID
Field in the
DEV 3g Prometheus User
Table
UUN
Field in the
3g ADMIS-Applicant-Feed
Table
UUN
Field in the
3g ADMIS-Applicant-Programme-Feed
Table
UUN
Field in the
3g ADMIS-Contact-Feed
Table
UUN
Field in the
3g ADMIS-Institute-Role-Feed
Table
UUN
Field in the
3g ADMIS-PGR-Supplemental03-Feed
Table
UUN
Field in the
3g ADMIS-PGR-Supplemental04-Feed
Table
UUN
Field in the
3g ESSMU-Course-Mark-Feed
Table
UUN
Field in the
3g ESSMU-Course-Student-Feed
Table
UUN
Field in the
3g ESSMU-External-Supervisor-Feed
Table
UUN
Field in the
3g ESSMU-PGR-Supplemental01-Feed
Table
UUN
Field in the
3g ESSMU-PGR-Supplemental02-Feed
Table
UUN
Field in the
3g ESSMU-Student-Feed
Table
UUN
Field in the
3g ESSMU-Student-Supplemental03-Feed
Table
UUN
Field in the
3g ESSMU-Student-Supplemental04-Feed
Table
UUN
Field in the
3g ESSMU-Supervisor-Feed
Table
UUN
Field in the
3g EUGEX-Course-Student-Feed
Table
UUN
Field in the
3g EUGEX-Institute-Role-Feed
Table
UUN
Field in the
3g EUGEX-Programme-Student-Feed
Table
UUN
Field in the
3g EUGEX-School-Student-Feed
Table
UUN
Field in the
3g EUGEX-Student-DoS-Feed
Table
UUN
Field in the
3g EUGEX-Student-External-DoS-Feed
Table
UUN
Field in the
3g EUGEX-Student-Feed
Table
Unassigned#
Field in the
Module-Duty
Table
Uni/AppChoice1
Link
Uni/AppChoice2
Link
Uni/AppChoice3
Link
Uni/AppErasmus1
Link
Uni/AppErasmus2
Link
Unique BOXI-Student-Supplemental-03-Feed
Key in the
3g ESSMU-Student-Supplemental03-Feed
Table
Unique Course-Duty (Instance)
Key in the
3g Course-Duty
Table
Unique Course-Duty-Allocation
Key in the
3g Course-Duty-Allocation
Table
Unique Course-Exam-Combined
Key in the
3g Course-Exam-Combined
Table
Unique Course-Exam-Mark
Key in the
3g Course-Exam-Mark
Table
Unique Course-Exam-Question-Mark
Key in the
3g Course-Exam-Question-Mark
Table
Unique Course-Mark
Key in the
3g Course-Mark
Table
Unique Course-Project-Mark (Person)
Key in the
3g Course-Project-Mark
Table
Unique Course-Project-Mark-Facet
Key in the
3g Course-Project-Mark-Facet
Table
Unique Course-Student (Person)
Key in the
3g Course-Student
Table
Unique Course-Work-Combined
Key in the
3g Course-Work-Combined
Table
Unique Course-Work-Event
Key in the
3g Course-Work-Event
Table
Unique Course-Work-Mark
Key in the
3g Course-Work-Mark
Table
Unique Detail
Key in the
3g Detail
Table
Unique Duty (Session-Instance)
Key in the
3g Duty
Table
Unique Person (UUID)
Key in the
3g Person
Table
Unique Programme-Combined
Key in the
3g Programme-Combined
Table
Unique Programme-Mark
Key in the
3g Programme-Mark
Table
Unique Webmark-Bid-Feed
Key in the
3g WEBMARK-Bid-Feed
Table
Unit Event Queue
Table
Unit Exam Mark!
Field in the
Class-Join-Mark
Table
Unit Exam Mark!
Field in the
Class-Mark
Table
Unit Exam Mark!
Field in the
Module-Join-Mark
Table
Unit Exam Mark!
Field in the
Module-Mark
Table
Unit Mark
Field in the
3g Programme-Mark
Table
Unit Mark
Field in the
3g Year-Mark
Table
Unit Mark
Field in the
Year-Mark
Table
Unit Mark
Field in the
Year-Mark-Archive
Table
Unit Override
Field in the
3g Course-Mark
Table
Unit Override
Field in the
Class-Mark
Table
Unit Override
Field in the
Module-Mark
Table
Unit Work Mark!
Field in the
Class-Mark
Table
Unit Work Mark!
Field in the
Module-Mark
Table
University
Cluster
University
Table
University Foreign Key
Key in the
3g College
Table
University Primary Key
Key in the
3g University
Table
University/College
Link
University/Department
Link
University/Division
Link
University/Faculty
Link
University/Site
Link
University/Site
Link
University/U-Payscale
Link
University?
Field in the
3g Duty-Type
Table
University?
Field in the
3g Scope-Type
Table
University@
Field in the
3g College
Table
University@
Field in the
3g Site
Table
University@
Field in the
3g University
Table
University@
Field in the
3g University-Payscale
Table
University@
Field in the
Department
Table
University@
Field in the
Division
Table
University@
Field in the
Faculty
Table
University@
Field in the
Site
Table
University@
Field in the
University
Table
Until
Field in the
3g Course-Duty-Concession
Table
Until
Field in the
3g Student-Concession
Table
Upcoming Course@
Field in the
3g Course-Diet-Type
Table
Upcoming Course@
Field in the
3g Course-Duty
Table
Upcoming Course@
Field in the
3g Course-Duty-Type
Table
Upcoming Course@
Field in the
3g Course-Exam
Table
Upcoming Course@
Field in the
3g Course-Exam-Diet-Type
Table
Upcoming Course@
Field in the
3g Course-Exam-Question
Table
Upcoming Course@
Field in the
3g Course-Exam-Type
Table
Upcoming Course@
Field in the
3g Course-Group-Duty-Type
Table
Upcoming Course@
Field in the
3g Course-Group-Event-Type
Table
Upcoming Course@
Field in the
3g Course-Group-Type
Table
Upcoming Course@
Field in the
3g Course-Project
Table
Upcoming Course@
Field in the
3g Course-Project-Duty-Type
Table
Upcoming Course@
Field in the
3g Course-Project-Facet-Type
Table
Upcoming Course@
Field in the
3g Course-Project-Type
Table
Upcoming Course@
Field in the
3g Course-Software-Requirement
Table
Upcoming Course@
Field in the
3g Course-Work
Table
Upcoming Course@
Field in the
3g Course-Work-Event
Table
Upcoming Course@
Field in the
3g Course-Work-Event-Type
Table
Upcoming Course@
Field in the
3g Course-Work-Type
Table
Upcoming Course@
Field in the
3g Course-Work-Variant
Table
Upcoming Exam@
Field in the
3g Course-Exam
Table
Upcoming Exam@
Field in the
3g Course-Exam-Question
Table
Upcoming Instance
Field in the
3g Course-Duty
Table
Upcoming Instance
Field in the
3g Course-Work-Event
Table
Upcoming Instance
Field in the
3g Year-Duty
Table
Upcoming Project@
Field in the
3g Course-Project
Table
Upcoming Question@
Field in the
3g Course-Exam-Question
Table
Upcoming Work@
Field in the
3g Course-Work
Table
Upcoming Work@
Field in the
3g Course-Work-Event
Table
Upcoming Work@
Field in the
3g Course-Work-Variant
Table
Updated
Field in the
PAVD Course
Table
Updated
Field in the
PAVD Person
Table
Updated
Field in the
PGT Course
Table
Updated
Field in the
PGT Email
Table
Updated
Field in the
PGT Person
Table
Updated!
Field in the
Applicant
Table
Usage
Field in the
3g Space
Table
Usage
Field in the
Class-Slot
Table
Usage
Field in the
Space
Table
Use Mark?
Field in the
3g Course-Exam-Mark
Table
User
Field in the
3g Item@
Table
User
Field in the
Item@
Table
User ID
Field in the
AI Password
Table
User ID
Field in the
CG Password
Table
User ID
Field in the
CS Password
Table
User ID
Field in the
Check-GCOS
Table
User ID
Field in the
Check-UID
Table
User ID
Field in the
Password-Person
Table
User ID
Field in the
Pseudo-UID
Table
User!
Field in the
Applicant
Table
User!
Field in the
Class-Student
Table
User!
Field in the
Goal
Table
User!
Field in the
Module-Student
Table
Username
Field in the
3g Password Portal
Table
Username
Field in the
3g Person
Table
Username
Field in the
3g Prometheus User
Table
Username
Field in the
3g Staff 2g
Table
Username
Field in the
AI Password
Table
Username
Field in the
CG Password
Table
Username
Field in the
CS Password
Table
Username
Field in the
Check-GCOS
Table
Username
Field in the
DEV 3g Prometheus User
Table
Username
Field in the
DEV Prometheus User
Table
Username
Field in the
IGO-Person
Table
Username
Field in the
Password-Person
Table
Username
Field in the
Person
Table
Username
Field in the
Prometheus User
Table
Username
Field in the
Pseudo-UID
Table
Username
Field in the
Public-Person
Table
Username
Field in the
UID-Action
Table
Username
Field in the
UID-Fix
Table
Username
Field in the
UID-Update
Table
:
Doc
:
Database
:
Dm
Please
contact us
with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh