TermCourse

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"TermCourse_id_seq"'::regclass)
AssignmentDetails.termCourseId Implied Constraint R
BiddingResponse.termCourseId Implied Constraint R
CourseDoubtDiscussion.termCourseId Implied Constraint R
CourseGradingTemplate.termCourseId Implied Constraint R
CourseSession.termCourseId Implied Constraint R
CourseStats.termCourseId Implied Constraint R
Grades.termCourseId Implied Constraint R
SectionGroup.termCourseId Implied Constraint R
SessionDetail.termCourseId Implied Constraint R
SessionFaculty.termCourseId Implied Constraint R
TempRecord.termCourseId Implied Constraint R
UserCourse.termCourseId Implied Constraint R
uuid uuid 2147483647 null
courseMasterId int4 10 null
CourseMaster.id Implied Constraint R
description text 2147483647 √ null
hours int4 10 √ null
credits float8 17,17 √ null
courseTypeId int4 10 √ null
CourseType.id Implied Constraint R
courseTagId int4 10 √ null
CourseTag.id Implied Constraint R
courseModeId int4 10 √ null
CourseMode.id Implied Constraint R
courseClassId int4 10 √ null
CourseClass.id Implied Constraint R
isMandatory bool 1 √ true
isDraft bool 1 √ false
displayOrder int4 10 √ null
programTermId int4 10 null
startDate timestamptz 35,6 √ null
endDate timestamptz 35,6 √ null
sectionId int4 10 √ null
Section.id Implied Constraint R
sessionFormat text 2147483647 √ null
readingMaterial text 2147483647 √ null
courseOutcome text 2147483647 √ null
noOfSession varchar 255 √ null
isDeleted bool 1 √ false
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
evaluationCriteria jsonb 2147483647 √ null
topicsJson jsonb 2147483647 √ null
placementCourse bool 1 √ false
videoLink varchar 255 √ null
workexperienced text 2147483647 √ null
courseOverview jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
TermCourse_pkey Primary key Asc id
TermCourse_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation