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, OneToOne
studentId	User	Foreign Key from User, OneToOne
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, OneToOne
description	string
room	string