CourseSession

2668 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CourseSession_id_seq"'::regclass)
uuid uuid 2147483647 null
sessionName varchar 255 √ null
courseMasterId int4 10 √ null
CourseMaster.id Implied Constraint R
sectionId int4 10 √ null
Section.id Implied Constraint R
termCourseId int4 10 √ null
TermCourse.id Implied Constraint R
description text 2147483647 √ null
preReadHeading text 2147483647 √ null
sessionCode varchar 255 √ null
isDraft bool 1 √ false
isCustom bool 1 √ false
isDeleted bool 1 √ false
uploadMaterial text 2147483647 √ null
sessionTopic varchar 255 √ null
totalStudents varchar 255 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
sessionSubTopic json 2147483647 √ null
inClassUploadMaterial text 2147483647 √ null
outClassUploadMaterial text 2147483647 √ null
inClassHeading text 2147483647 √ null
outClassHeading text 2147483647 √ null
theme varchar 255 √ null
inClassUploadMaterialMultiple json 2147483647 √ null
outClassUploadMaterialMultiple json 2147483647 √ null
preReadJson jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
CourseSession_pkey Primary key Asc id
course_session_id Performance Asc id
course_session_uuid Performance Asc uuid
CourseSession_id_idx Performance Asc id
CourseSession_uuid_idx Performance Asc uuid
CourseSession_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation