ProgramTerm

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"ProgramTerm_id_seq"'::regclass)
uuid uuid 2147483647 null
term varchar 255 √ null
description text 2147483647 √ null
startDate timestamptz 35,6 √ null
endDate timestamptz 35,6 √ null
biddingEnabled bool 1 √ false
programId int4 10 null
Program.id Implied Constraint R
minCredit int4 10 √ null
maxCredit int4 10 √ null
isDeleted bool 1 √ false
isDraft bool 1 √ false
theme varchar 255 √ null
isActiveTerm bool 1 √ false
customName varchar 255 √ null
minCourseCount int4 10 √ null
maxCourseCount 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)
ProgramTerm_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation