Table
acad_object_groups
academic_standing affiliations
books
buildings class_enrolment_waitlist class_enrolments class_teachers class_types
classes
countries
course_books course_enrolment_waitlist course_enrolments course_quotas course_staff
courses
degree_types degrees_awarded external_subjects facilities
orgunit_groups orgunit_types
orgunits
people
program_degrees program_enrolments
program_group_members programs
public_holidays room_facilities
Attributes
id, name, gtype, glogic, gdefby, negated, parent, definition
id, standing, notes
staff, orgunit, role, isprimary, starting, ending
id, isbn, title, authors, publisher, edition, pubyear
id, unswid, name, campus, gridref
student, class, applied
student, class
class, teacher
id, unswid, name, description
id, course, room, ctype, dayofwk, starttime, endtime, startdate, enddate, repeats
id, code, name
course, book, bktype
student, course, applied
student, course, mark, grade, stueval
course, sgroup, quota
course, staff, role
id, subject, semester, homepage
id, unswid, name, prefix, career, aqf_level
student, program, graduated
id, extsubj, institution, yearoffered, equivto
id, description
owner, member
id, name
id, utype, name, longname, unswid, phone, email, website, starting, ending
id, unswid, password, family, given, title, sortname, name, street, city, state, postcode, country, homephone, mobphone, email, homepage, gender, birthday, origin
program, degree, name, abbrev
id, student, semester, program, wam, standing, advisor, notes
program, ao_group
id, code, name, uoc, offeredby, career, duration, description, firstoffer, lastoffer
semester, description, day room, facility
room_types rooms
semesters
staff staff_role_classes staff_role_types
staff_roles
stream_enrolments
stream_group_members
streams
student_groups
students
subject_group_members
subjects
variations
id, description
id, unswid, rtype, name, longname, building, capacity
id, unswid, year, term, name, longname, starting, ending, startbrk, endbrk, endwd, endenrol, census
id, office, phone, employed, supervisor id, description
id, description
id, rtype, rclass, name, description
partof, stream
stream, ao_group
id, code, name, offeredby, stype, description, firstoffer, lastoffer
id, name, definition
id, stype
subject, ao_group
id, code, name, longname, uoc, offeredby, eftsload, career, syllabus, contacthpw, _excluded, excluded, _equivalent, equivalent, _prereq, prereq, replaces, firstoffer, lastoffer
student, program, subject, vtype, intequiv, extequiv, yearpassed, mark, approver, approved