User

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"User_id_seq"'::regclass)
BiddingResponse.userId Implied Constraint R
CourseDoubtDiscussion.userId Implied Constraint R
CourseDoubtDiscussionChat.userId Implied Constraint R
CourseStats.userId Implied Constraint R
Grades.userId Implied Constraint R
Notification.userId Implied Constraint R
Quiz.userId Implied Constraint R
SessionFaculty.userId Implied Constraint R
StudentAssignment.userId Implied Constraint R
TermStats.userId Implied Constraint R
UserBankDetail.userId Implied Constraint R
UserCourse.userId Implied Constraint R
UserEducation.userId Implied Constraint R
UserExperience.userId Implied Constraint R
UserGroup.userId Implied Constraint R
UserLevel.userId Implied Constraint R
UserProfile.userId Implied Constraint R
UserProgram.userId Implied Constraint R
UserRole.userId Implied Constraint R
UserSection.userId Implied Constraint R
UserVerification.userId Implied Constraint R
uuid uuid 2147483647 null
firstName varchar 20 null
lastName varchar 20 √ null
officialEmail varchar 255 null
password varchar 255 √ null
alternateEmail varchar 255 √ null
mobileNumber varchar 255 √ null
image varchar 255 √ null
token varchar 255 √ null
userStatus enum_User_userStatus 2147483647 √ 'Active'::"enum_User_userStatus"
lastActiveAt timestamptz 35,6 √ null
isDeleted bool 1 √ false
organizationId int4 10 null
Organization.id Implied Constraint R
bloodGroup varchar 255 √ null
motherName varchar 255 √ null
fatherName varchar 255 √ null
dateOfBirth timestamptz 35,6 √ null
userAddress json 2147483647 √ null
designation varchar 255 √ null
department varchar 255 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
resume varchar 255 √ null
resumeFileName varchar 255 √ null
onBoarding bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
User_pkey Primary key Asc id
User_officialEmail_key Must be unique Asc officialEmail
User_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation