CourseMaster

442 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CourseMaster_id_seq"'::regclass)
CategoryCourseMaster.courseMasterId Implied Constraint R
CourseMasterDomain.courseMasterId Implied Constraint R
CourseSession.courseMasterId Implied Constraint R
SessionDetail.courseMasterId Implied Constraint R
TermCourse.courseMasterId Implied Constraint R
uuid uuid 2147483647 null
name varchar 255 √ null
SequelizeMeta.name Implied Constraint R
description text 2147483647 √ null
courseCode varchar 255 √ null
slug varchar 255 √ null
isDeleted bool 1 √ false
courseTypeId int4 10 √ null
CourseType.id Implied Constraint R
courseTagId int4 10 √ null
CourseTag.id Implied Constraint R
courseClassId int4 10 √ null
CourseClass.id Implied Constraint R
courseModeId int4 10 √ null
CourseMode.id Implied Constraint R
hours varchar 255 √ null
credits varchar 255 √ null
numberOfSessions int4 10 √ null
courseFormat text 2147483647 √ null
gradingPolicies varchar 255 √ null
readingMaterial text 2147483647 √ null
courseOutcome text 2147483647 √ null
courseShortName varchar 255 √ null
isPublished bool 1 √ false
isDraft bool 1 √ false
organizationId int4 10 null
Organization.id Implied Constraint R
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
evaluationCriteria json 2147483647 √ null
topicsJson json 2147483647 √ null
courseOverview json 2147483647 √ null
placementCourse bool 1 √ false
workexperienced text 2147483647 √ null
videoLink varchar 255 √ null
moderatedDiscussion bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
CourseMaster_pkey Primary key Asc id
CourseMaster_courseCode_key Must be unique Asc courseCode
CourseMaster_id_idx Performance Asc id
CourseMaster_uuid_idx Performance Asc uuid
CourseMaster_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation