StudentAssignment

89879 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"StudentAssignment_id_seq"'::regclass)
Grades.studentAssignmentId Implied Constraint R
uuid uuid 2147483647 null
assignmentDetailId int4 10 √ null
isDeleted bool 1 √ false
userId int4 10 √ null
User.id Implied Constraint R
submittedDate timestamptz 35,6 √ null
quizId int4 10 √ null
Quiz.id Implied Constraint R
assignmentLink text 2147483647 √ null
fileName varchar 255 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
driveLink text 2147483647 √ null
assignmentDescription text 2147483647 √ null
driveFileName text 2147483647 √ null
filestack json 2147483647 √ null
fileKey varchar 255 √ null
groupAssignmentLogs jsonb 2147483647 √ '[]'::jsonb
resubmitAssignment bool 1 √ false
submittedAssignmentJson json 2147483647 √ '[]'::json
aiResponseLog json 2147483647 √ null
isQuizForedClose bool 1 √ false
quizStartTime timestamptz 35,6 √ null
quizEndTime timestamptz 35,6 √ null
quizTime varchar 255 √ null
rejectedReason text 2147483647 √ null
studentSubmissionReview varchar 255 √ 'accepted'::character varying
newDeadline timestamptz 35,6 √ null
statusUpdatedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
StudentAssignment_pkey Primary key Asc id
student_assignment_isAdmin_usrId_isDeleted Performance Asc/Asc/Asc/Asc isDeleted + userId + id + uuid
StudentAssignment_id_idx Performance Asc id
StudentAssignment_uuid_idx Performance Asc uuid
StudentAssignment_uuid_key Must be unique Asc uuid
unique_studentassignment Must be unique Asc/Asc userId + assignmentDetailId

Relationships

Close relationships within degrees of separation