persons
personId
givenName
surnamePrefix
surname
displayName
dateOfBirth
affiliations
mail
telephoneNumber
mobileNumber
photoSocial
photoOfficial
gender
title
office
Links	List of educational-departments
	List of educational-plans
	List of course-groups
	List of courses
	List of course-results
	List of test-results
	List of schedules

faculties
facultyId
type
name
description
Links	parentFaculty
	childFaculties
	educationalDepartments
	educationalPlans
	courseGroups
	courses

educational-departments
educationalDepartmentId
name
description
Links	educationalPlans
	courseGroups
	courses

educational-plans
educationalPlanId
name
description
termStartDate
termEndDate
ects
earnedEcts
mainLanguage
Links	courseGroups
	courses

course-groups
courseGroupId
name
studyYear
description
type
ects
earnedEcts
Links	courses

courses
courseId
name
abbreviation
ects
description
goals
requirements
level
format
mainLanguage
enrollment
literature
exams
schedule
link
Links	schedules
	lecturers
	courseResults
	testResults
	faculties
	educationalDepartments
	educationalPlans
	courseGroup

course-results
courseResultId
passed
grade
comment
resultDate
academicYear
Links	course
	student
	testResluts

test-results
testResultId
description
assessmentType
testDate
grade
comment
passed
weight
Links	course
	student
	lecturers

buildings
buildingId
abbreviation
name
description
address
postalCode
city
lat
lon
Links	rooms

rooms
roomId
abbreviation
name
type
description
totalSeats
totalWorkspaces
availableWorkspaces
Links	building

schedules
scheduleId
startDateTime
endDateTime
description
rooms	roomId
	abbreviation
	name
	Links	building
Links	courses
	lecturers

news-feeds
newsFeedId
title
description
Links	newsItems

news-items
newsItemId
title
authors
image
link
content
publishDateTime
lastModified
Links	newsFeeds