CourseStats

23519 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CourseStats_id_seq"'::regclass)
uuid uuid 2147483647 null
userId int4 10 √ null
User.id Implied Constraint R
termCourseId int4 10 √ null
TermCourse.id Implied Constraint R
programTermId int4 10 √ null
gpa float8 17,17 √ null
grade varchar 255 √ null
attendanceData json 2147483647 √ null
isDeleted bool 1 √ false
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
isProcessed bool 1 √ false
isGradeProcessed bool 1 √ false
systemGpa float8 17,17 √ null
totalMarks float8 17,17 √ null
systemGrade varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
CourseStats_pkey Primary key Asc id
CourseStats_id_idx Performance Asc id
CourseStats_programTermId_userId_termCourseId Performance Asc/Asc/Asc programTermId + userId + termCourseId
CourseStats_uuid_idx Performance Asc uuid
CourseStats_uuid_key Must be unique Asc uuid
uniqueUserTermCourse Must be unique Asc/Asc userId + termCourseId

Relationships

Close relationships within degrees of separation