Entities Tables

In this article, all definied entities are documented, which are created as tables in the database by TypeORM.
Please notice, that attribute-name may vary from the column-names in the Postgres-Tables.
In this documentation, only the names from the attributes definied in the entities are used.
By default, all attributes are not nullable.

User

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
username	string	Unique
password	string
isTeacher	boolean	Default false
isAdministrator	boolean	Default false
course	Course	Foreign Key from Course, ManyToOne

UserDetail

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
userId	User	Foreign Key from User, OneToOne
fullname	string
address	string
matriculationNumber	string	Unique
mail	string	Unique

Grades

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
moduleId	Module	Foreign Key from Module, ManyToOne
studentId	User	Foreign Key from User, ManyToOne
grade	number
weight	number

Timetable

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
startTime	Date
endTime	Date
assignedModule	Module	Foreign Key from Module, ManyToOne
description	string	nullable
room	string

Course

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
name	string	Unique
students	User[]	Foreign Key from User, nullabble, OneToMany
assignedModules	Module[]	Foreign Key from Module, nullable, OneToMany

Module

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
name	string
description	string	nullable
assignedTeacher	User[]	Foreign Key from User, ManyToMany
assignedCourse	Course	Foreign Key from Course, nullable, ManyToOne
submodule	Moudle[]	Foreign Key from Module, nullable, OneToMany
seniormodule	Module	Foreign Key from Module, ManyToOne

ModuleItem

Attribute-Name	Datatype	Aditional attributes
id	number	Primary Key, Autogenerated
moduleId	Module	Foreign Key from Module, ManyToOne
content	string	nullable
webLink	string	nullable
hasDownloadableFile	boolean	Default false
hasFileUpload	boolean	Default false
attachedFiles	File[]	Foreign Key from File, nullable, OneToMany
isVisible	boolean	Default false
dueDate	Date	nullable

File

Attribute-Name	Datatype	Additional attributes
id	number	Primary Key, Autogenerated
owner	User	Foreign Key from User, ManyToOne
name	string
path	string
uploadDate	Date
attachedAt	ModuleItem	Foreign Key from ModuleItem, ManyToOne