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