Grades

83020 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Grades_id_seq"'::regclass)
uuid uuid 2147483647 null
studentAssignmentId int4 10 √ null
StudentAssignment.id Implied Constraint R
assignmentDetailId int4 10 √ null
userId int4 10 √ null
User.id Implied Constraint R
assignmentFeedback text 2147483647 √ null
marksObtained float8 17,17 √ null
feedbackRequested bool 1 √ false
grade varchar 255 √ null
createdBy int4 10 √ null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
isProcessed bool 1 √ false
termCourseId int4 10 √ null
TermCourse.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
Grades_pkey Primary key Asc id
Grades_id_idx Performance Asc id
Grades_userId_assignmentDetailId_studentAssignmentId Performance Asc/Asc/Asc userId + studentAssignmentId + assignmentDetailId
Grades_uuid_idx Performance Asc uuid
Grades_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation