ProgramMaster

102 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"ProgramMaster_id_seq"'::regclass)
uuid uuid 2147483647 null
name varchar 255 √ null
SequelizeMeta.name Implied Constraint R
description text 2147483647 √ null
categoryId int4 10 null
Category.id Implied Constraint R
organizationId int4 10 √ null
Organization.id Implied Constraint R
isDeleted bool 1 √ false
totalCohort int4 10 √ null
programMode enum_ProgramMaster_programMode 2147483647 √ 'Online'::"enum_ProgramMaster_programMode"
otherMode varchar 255 √ null
programSystem enum_ProgramMaster_programSystem 2147483647 √ 'Semester'::"enum_ProgramMaster_programSystem"
otherProSystem varchar 255 √ null
durationInMonths int4 10 √ null
durationInYears int4 10 √ null
durationOfTerm int4 10 √ null
isDraft bool 1 √ false
programFees int4 10 √ null
paymentTimeline varchar 255 √ null
policyFile varchar 255 √ null
gradingMechanism varchar 255 √ null
numberOfTerms int4 10 √ null
varchar 255 √ null
targetGroup varchar 255 √ null
admissionCriterion varchar 255 √ null
worksheet varchar 255 √ null
isActive bool 1 √ false
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
userMandatoryFields json 2147483647 √ null
programMangerJson jsonb 2147483647 √ null
timezone varchar 255 √ 'Asia/Kolkata'::character varying
shortName varchar 255 √ null
qrTimer int4 10 √ null
contributerJson jsonb 2147483647 √ '{}'::jsonb
sessionUpdateNotify bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
ProgramMaster_pkey Primary key Asc id
ProgramMaster_id_idx Performance Asc id
ProgramMaster_uuid_idx Performance Asc uuid
ProgramMaster_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation