Diagrams

Reading Entity-Relationship Diagrams is probably the easiest and fastest way of getting acquainted with the database structure. Here you will find all diagrams introduced throughout this documentation.

We use Crow's Foot Notation in our ERDs.

Courses and students

References: Academic Term, Class Group, Class Participant, Class Type, Course, Course Edition, Course Student, Course Unit, User.

Students vs. staff members

References: Employment, Faculty, Programme, Programme Student, User.

Student's faculties

References: User, Programme Student, Programme, Faculty Programme, Faculty.

Faculty's courses and programmes

References: Course, Faculty, Faculty Programme, Programme, Programme Stage, Stage Course Requirement.

Activities: "classgroup".

References: Academic Term, Activity (imaginary), "classgroup" Activity (imaginary), Class Group, Class Group Weekly Meeting, Class Type, Course, Course Edition, Course Unit, Weekly Meeting Option.

Activities: "classgroup2".

References: Activity (imaginary), "classgroup2" Activity (imaginary), Class Group, Class Group Weekly Meeting, Class Type, Course, Course Edition, Course Unit, Single Meeting.

Exams, registration for exams.

References: Faculty, Course Edition, Exam, Exam Attendee, Exam Group, Exam Report, Exam Report Set, Exam Slot (imaginary), Examiner, Registration for Exams, Room, User.

Theses, authors and supervisors.

References: Thesis, Thesis Author, Thesis Supervisor.

Per-faculty permissions.

References: Faculty Permission Class, User, Faculty, User Faculty Permission.

Housing module.

References: User, Dorm Application, Dorm Assignment, Allocation Period, Term, Residence, Resident Type, Dormitory Room (Dormroom), Dormroom Type, Dormitory.

USOS API ver. 7.1.1.0-1, f733442d, dirty (2024-11-25)