TermDomainStats

7572 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"TermDomainStats_id_seq"'::regclass)
uuid uuid 2147483647 null
courseDomainId int4 10 null
CourseDomain.id Implied Constraint R
userId int4 10 null
User.id Implied Constraint R
programTermId int4 10 null
programId int4 10 null
Program.id Implied Constraint R
systemDomainData jsonb 2147483647 √ '{}'::jsonb
customDomainData jsonb 2147483647 √ '{}'::jsonb
domainGpa float8 17,17 √ null
domainSystemGpa float8 17,17 √ null
domainGrade varchar 255 √ null
systemDomainGrade varchar 255 √ null
domainCredit float8 17,17 √ null
totalCredit float8 17,17 √ null
isDeleted bool 1 √ false
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)
TermDomainStats_pkey Primary key Asc id
TermDomainStats_uuid_key Must be unique Asc uuid
unique_course_user_term_program Must be unique Asc/Asc/Asc/Asc courseDomainId + userId + programTermId + programId

Relationships

Close relationships within degrees of separation