UserDomainData

2989 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserDomainData_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
domainJson jsonb 2147483647 √ '{}'::jsonb
gpaJson jsonb 2147483647 √ '{}'::jsonb
attandanceJson jsonb 2147483647 √ '{}'::jsonb
domainPRSJson jsonb 2147483647 √ '{}'::jsonb
userDomainPRS float8 17,17 √ '0'::double precision
isDeleted bool 1 √ false
createdBy int4 10 √ null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
programId int4 10 √ null
Program.id Implied Constraint R
userDomainRank int4 10 √ null
userDomainRankStatus varchar 255 √ null
percentile float8 17,17 √ null
UserCourseType jsonb 2147483647 √ '[]'::jsonb
UserCourseTag jsonb 2147483647 √ '[]'::jsonb
UserCourseClass jsonb 2147483647 √ '[]'::jsonb
UserCourseMode jsonb 2147483647 √ '[]'::jsonb
creditsJson jsonb 2147483647 √ '{}'::jsonb
domainCreditsCourseJson jsonb 2147483647 √ '{}'::jsonb
placementCourseJson jsonb 2147483647 √ '{}'::jsonb
isUserPlacement bool 1 √ false
domainPreference varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
UserDomainData_pkey Primary key Asc id
UserDomainData_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation