CourseFormat

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CourseFormat_id_seq"'::regclass)
uuid uuid 2147483647 null
isDeleted bool 1 √ false
minCourseCount int4 10 √ null
maxCourseCount int4 10 √ null
minCredit int4 10 √ null
maxCredit int4 10 √ null
programId int4 10 √ null
Program.id Implied Constraint R
courseTypeId int4 10 √ null
CourseType.id Implied Constraint R
courseModeId int4 10 √ null
CourseMode.id Implied Constraint R
courseTagId int4 10 √ null
CourseTag.id Implied Constraint R
courseClassId int4 10 √ null
CourseClass.id Implied Constraint R
termId int4 10 √ null
minElectiveCount int4 10 √ null
maxElectiveCount int4 10 √ null
maxTermCount int4 10 √ null
minTermCount int4 10 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
CourseFormat_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation