SectionGroup

2126 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"SectionGroup_id_seq"'::regclass)
uuid uuid 2147483647 null
name varchar 255 √ null
SequelizeMeta.name Implied Constraint R
isDeleted bool 1 √ false
sectionId int4 10 √ null
Section.id Implied Constraint R
termCourseId int4 10 √ null
TermCourse.id Implied Constraint R
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
groupSize int4 10 √ null
gamificationConfigId int4 10 √ null
GamificationConfig.id Implied Constraint R
customQuestions json 2147483647 √ null
metrics json 2147483647 √ null
leaderboard json 2147483647 √ null
rewards json 2147483647 √ null
resources json 2147483647 √ null
allowTeamFormation bool 1 √ false
teamFormationDeadline timestamptz 35,6 √ null
teamFormationConstraint json 2147483647 √ null
image json 2147483647 √ null
description text 2147483647 √ null
leaderboardType enum_SectionGroup_leaderboardType 2147483647 √ null
xByXRows json 2147483647 √ null
xByXColumns json 2147483647 √ null
scheduleStartDate timestamptz 35,6 √ null
scheduleEndDate timestamptz 35,6 √ null
triggerInterval enum_SectionGroup_triggerInterval 2147483647 √ null
weeksBetweenTriggers int4 10 √ null
triggerDay enum_SectionGroup_triggerDay 2147483647 √ null
allowSkipUntil enum_SectionGroup_allowSkipUntil 2147483647 √ null
isFinalized bool 1 √ false
isStudentCreated bool 1 √ false
status varchar 255 √ 'pending'::character varying
courseDomainId int4 10 √ null
CourseDomain.id Implied Constraint R
programTermId int4 10 √ null
rejectedReason text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
SectionGroup_pkey Primary key Asc id
SectionGroup_id_idx Performance Asc id
SectionGroup_uuid_idx Performance Asc uuid

Relationships

Close relationships within degrees of separation