EDIT (27/05/2023, 19:14)
Roleid: TINYINT(4)name: CHAR(10)label: CHAR(20)Institutionid: INT(11)cNodePoolId: SMALLINT(4) «FK»name: VARCHAR(100)acronym: VARCHAR(16)country: CHAR(2)state: VARCHAR(100)city: VARCHAR(100)timezone: VARCHAR(40)timeConvention: CHAR(3)languageCode: CHAR(6)URL: VARCHAR(100)createdAt: DATETIME(6)updatedAt: DATETIME(6)Userid: INT(11)institutionId: INT(11) «FK»roleId: TINYINT(4) «FK»enrollmentNumber: VARCHAR(100)fullName: VARCHAR(200)email: VARCHAR(255)password: CHAR(72)avatarFilePath: VARCHAR(255)preferences: VARCHAR(1000)authKey: CHAR(36)deactivatedAt: DATETIME(6)createdAt: DATETIME(6)updatedAt: DATETIME(6)ClassUsersid: INT(11)classId: INT(11) «FK»userId: INT(11) «FK»roleId: TINYINT(4) «FK»Courseid: INT(11)institutionId: INT(11) «FK»code: VARCHAR(50)name: VARCHAR(100)workload: INT(11)createdAt: DATETIME(6)updatedAt: DATETIME(6)Classid: INT(11)courseId: INT(11) «FK»institutionOwner: INT(11)code: VARCHAR(50)start: DATEend: DATEenrollDeadline: DATEmonday: VARCHAR(10)tuesday: VARCHAR(10)wednesday: VARCHAR(10)thursday: VARCHAR(10)friday: VARCHAR(10)saturday: VARCHAR(10)createdAt: DATETIME(6)updatedAt: DATETIME(6)Invitationid: INT(11)institutionId: INT(11) «FK»invitedById: INT(11) «FK»roleId: TINYINT(4) «FK»email: VARCHAR(255)authKey: CHAR(36)createdAt: DATETIME(6)updatedAt: DATETIME(6)ProgrammingLanguageid: INT(11)name: VARCHAR(40)isAvailable: TINYINT(1)plainName: VARCHAR(40)version: VARCHAR(20)compileCommand: VARCHAR(1000)runCommand: VARCHAR(1000)fileExtension: VARCHAR(20)symbols: TEXTinputMode: ENUM(FILE, FILE_AS_PARAMETER, CODE, STDIN)binaryExtension: VARCHAR(20)entrySourceFile: VARCHAR(100)createdAt: DATETIME(6)updatedAt: DATETIME(6)Assessmentid: INT(11)programmingLanguageId: INT(11) «FK»classId: INT(11) «FK»clonedFromId: INT(11) «FK»isVisible: TINYINT(1)accessibleToStudentsIds: JSONinstitutionOwner: INT(11)title: VARCHAR(200)markdownDescription: TEXTtype: ENUM(ASSIGNMENT, EXAM)weight: TINYINT(2)programmingLanguageVersion: VARCHAR(20)start: DATETIME(6)end: DATETIME(6)createdAt: DATETIME(6)updatedAt: DATETIME(6)AssessmentGradeassessmentId: INT(11)userId: INT(11)grade: FLOATsumOfExercisesCorrectness: FLOATtotalCorrectExercises: TINYINTtotalPartiallyCorrectExercises: TINYINTtotalIncorrectExercises: TINYINTAssessmentUsersassessmentId: INT(11)userId: INT(11)ProgrammingExerciseTicketid: INT(11)programmingExerciseId: INT(11) «FK»createdById: INT(11) «FK»message: VARCHAR(1000)createdAt: DATETIME(6)updatedAt: DATETIME(6)AssessmentExercisesassessmentId: INT(11)programmingExerciseId: INT(11)block: INT(11)ProgrammingExerciseid: INT(11)copiedFromId: INT(11) «FK»difficultyLevelId: TINYINT «FK»fontId: INT(11) «FK»authorId: INT(11) «FK»institutionOwner: INT(11)languageCode: CHAR(6)isShared: TINYINT(1)markdownDescription: TEXTplainDescription: TEXTmarkdownTips: TEXTdataFileURI: VARCHAR(255)startCode: TEXTsampleSolution: TEXTcorrectionMode: ENUM(BINARY, PROPORTIONAL)createdAt: DATETIME(6)updatedAt: DATETIME(6)RaffledExercisesassessmentId: INT(11)programmingExerciseId: INT(11)userId: INT(11)lastSubmissionThatChangedCorrectnessId: INT(11)RaffledExerciseReviewassessmentId: INT(11)programmingExerciseId: INT(11)userId: INT(11)createdAt: INT(11)reviewerId: INT(11)message: VARCHAR(1000)reviewedProgrammingExerciseCorrectness: FLOATFontid: INT(11)label: VARCHAR(1024)DifficultyLevelid: TINYINT(4)label: VARCHAR(100)weight: TINYINT(4)Topicid: INT(11)label: VARCHAR(100)createdAt: DATETIME(6)updatedAt: DATETIME(6)TranslationsTopicid: INT(11)topicId: INT(11) «FK»label: VARCHAR(100)languageCode: CHAR(6)createdAt: DATETIME(6)updatedAt: DATETIME(6)ProgrammingExerciseTopicsprogrammingExerciseId: INT(11)topicId: INT(11)TestCaseid: INT(11)programmingExerciseId: INT(11) «FK»input: VARCHAR(4000)output: VARCHAR(4000)isSample: TINYINT(1)createdAt: DATETIME(6)updatedAt: DATETIME(6)Postid: INT(11)classId: INT(11) «FK»authorId: INT(11) «FK»updatedById: INT(11) «FK»message: VARCHAR(1000)targetStudentsIds: JSONisPinned: TINYINTcreatedAt: DATETIME(6)updatedAt: DATETIME(6)Commentid: INT(11)authorId: INT(11) «FK»postId: INT(11) «FK»message: VARCHAR(1000)createdAt: DATETIME(6)updatedAt: DATETIME(6)Attachmentid: INT(11)category: ENUM(DOCUMENT, IMAGE, SOURCE_CODE, VIDEO, VIRTUAL_GROUP, WEBSITE, OTHER)title: VARCHAR(100)URI: VARCHAR(255)fileExtension: VARCHAR(20)thumbnailUrl: VARCHAR(255)createdAt: DATETIME(6)updatedAt: DATETIME(6)PostAttachmentspostId: INT(11)attachmentId: INT(11)attachmentTitle: VARCHAR(100)CourseAttachmentscourseId: INT(11)attachmentId: INT(11)Submissionid: INT(11)userId: INT(11) «FK»programmingExerciseId: INT(11) «FK»assessmentId: INT(11) «FK»type: ENUM(RUN,SUBMISSION)executionTime: FLOATevaluationStatus: ENUM(COMPILATION_ERROR,RUNTIME_ERROR,OUTPUT_LIMIT_EXCEEDED,MEMORY_LIMIT_EXCEEDED,TIMEOUT)compilationStdout: TEXTcompilationStderr: TEXTruntimeStdout: TEXTruntimeStderr: TEXTcorrectness: FLOATtestCases: JSONcommitHash: CHAR(40)createdAt: DATETIME(6)updatedAt: DATETIME(6)CNodeid: INT(11)cNodePoolId: SMALLINT(4) «FK»hostIp: VARCHAR(15)startingPort: SMALLINT(4)totalAvailablePorts: SMALLINT(4)region: VARCHAR(30)protocol: ENUM(HTTP,HTTPS)CNodePoolid: SMALLINT(4)name: VARCHAR(100)