User

2625 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"User_id_seq"'::regclass)
Accomplishment.userId Accomplishment_userId_fkey R
AccomplishmentPortfolioStatus.userId AccomplishmentPortfolioStatus_userId_fkey R
AiSummary.userId Implied Constraint R
AllyChat.userId Implied Constraint R
Announcement.createdBy Announcement_createdBy_fkey R
AnnouncementView.userId Implied Constraint R
Applications.userId Implied Constraint R
BiddingLogs.userId Implied Constraint R
BiddingResponse.userId Implied Constraint R
BiometricAttendance.userId Implied Constraint R
Birthday.userId Implied Constraint R
Bookmark.userId Implied Constraint R
ClubMember.userId Implied Constraint R
CourseDoubtDiscussion.userId Implied Constraint R
CourseDoubtDiscussionChat.userId Implied Constraint R
CourseStats.userId Implied Constraint R
CustomNotification.userId Implied Constraint R
DoubtGroupUser.userId Implied Constraint R
DoubtMessageRead.userId Implied Constraint R
EmployeeStudentLoginLogs.userId Implied Constraint R
Grades.userId Implied Constraint R
loginLogs.userId Implied Constraint R
MaterialLog.userId MaterialLog_userId_fkey C
Notification.userId Implied Constraint R
PendingRequest.userId Implied Constraint R
Quiz.userId Implied Constraint R
QuizLogs.userId Implied Constraint R
ReactOutFeedBack.userId Implied Constraint R
SessionFaculty.userId Implied Constraint R
StudentAssignment.userId Implied Constraint R
TempTgpaCalculaton.userId Implied Constraint R
TermDomainStats.userId Implied Constraint R
TermStats.userId Implied Constraint R
teststTable.userId Implied Constraint R
UserBankDetail.userId Implied Constraint R
UserBiometricData.userId Implied Constraint R
UserCourse.userId Implied Constraint R
UserCourseDomain.userId Implied Constraint R
UserCustomPolicy.userId Implied Constraint R
UserDocSign.userId Implied Constraint R
UserDomainData.userId Implied Constraint R
UserDomainLogs.userId Implied Constraint R
UserEducation.userId Implied Constraint R
UserEligibility.jobId UserEligibility_jobId_fkey2 R
UserEligibility.userId UserEligibility_userId_fkey5 R
UserExperience.userId Implied Constraint R
UserGroup.userId Implied Constraint R
UserLevel.userId Implied Constraint R
UserLogs.userId Implied Constraint R
UserNewsFeed.userId Implied Constraint R
UserNotification.userId Implied Constraint R
UserNpsResponse.userId Implied Constraint R
UserPortfolio.userId Implied Constraint R
UserPortfolioStatus.userId Implied Constraint R
UserProfile.userId Implied Constraint R
UserProgram.userId Implied Constraint R
UserRole.userId Implied Constraint R
UserRound.userId UserRound_userId_fkey C
UserSection.userId Implied Constraint R
UserSessionFeedBack.userId Implied Constraint R
userSkills.userId Implied Constraint R
UserVerification.userId Implied Constraint R
wtsNextViewLog.userId Implied Constraint R
uuid uuid 2147483647 null
JobViews.userId fk_jobviews_userId C
firstName varchar 255 null
lastName varchar 255 √ 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
lastActiveAt timestamptz 35,6 √ null
isDeleted bool 1 √ false
organizationId int4 10 null
Organization.id User_organizationId_fkey C
bloodGroup varchar 255 √ null
motherName varchar 255 √ null
fatherName varchar 255 √ null
dateOfBirth timestamptz 35,6 √ null
userAddress json 2147483647 √ null
designation text 2147483647 √ null
department text 2147483647 √ 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
gender varchar 255 √ null
alternateMobileNumber varchar 255 √ null
linkedInUrl varchar 255 √ null
state varchar 255 √ null
district varchar 255 √ null
city varchar 255 √ null
workExpMonths varchar 255 √ null
workExpYears varchar 255 √ null
uidNumber varchar 255 √ null
professionalAccomplishments text 2147483647 √ null
aboutYourself text 2147483647 √ null
postMbaCityPreference1 text 2147483647 √ null
postMbaCityPreference2 text 2147483647 √ null
postMbaCityPreference3 text 2147483647 √ null
isLocationConstraint bool 1 √ false
primaryPreMbaDomain text 2147483647 √ null
primaryPostMbaDomain text 2147483647 √ null
secondaryPostMbaDomain text 2147483647 √ null
tertiaryPostMbaDomain text 2147483647 √ null
isOptedPlacementProcess bool 1 √ false
isInternationalPlacement bool 1 √ false
countryInterested varchar 255 √ null
isAnotherCountryVisa bool 1 √ false
isAnotherCountryWorkVisa bool 1 √ false
countryVisaName varchar 255 √ null
dreamCompany json 2147483647 √ null
portfolioLink text 2147483647 √ null
nationality varchar 255 √ null
category varchar 255 √ null
isBelowPovertyLine bool 1 √ false
documentsRequired jsonb 2147483647 √ '[]'::jsonb
familyIncome varchar 255 √ null
optIns json 2147483647 √ '{"generalNotification":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"sessionupdates":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"upcomingSession":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"feedbackReminder":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"newAssignment":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"feedbackUpdated":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"marksUpdated":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"newEventCreated":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}],"myEventsUpdates":[{"name":"email","status":true},{"name":"whatsapp","status":true},{"name":"sms","status":true},{"name":"push","status":true}]}'::json
parentsMobileNumber varchar 255 √ null
otp varchar 255 √ null
otpCreatedAt timestamptz 35,6 √ null
isFingerPrintSync bool 1 √ false
isFaceScannerSync bool 1 √ false
addToDevice bool 1 √ false
motherNameEmail varchar 255 √ null
motherNameNumber varchar 255 √ null
motherNameOccupation varchar 255 √ null
motherNameDesignation varchar 255 √ null
motherNameCompany varchar 255 √ null
fatherNameEmail varchar 255 √ null
fatherNameNumber varchar 255 √ null
fatherNameOccupation varchar 255 √ null
fatherNameDesignation varchar 255 √ null
fatherNameCompany varchar 255 √ null
userName varchar 255 √ null
calendlyLink varchar 255 √ null
initialAdditions varchar 255 √ null
parentsCountryCode varchar 255 √ null
studentCountryCode varchar 255 √ null
resumeDocLink text 2147483647 √ null
notificationToken json 2147483647 √ null
countryCode varchar 255 √ null
country varchar 255 √ null
timezone varchar 255 √ NULL::character varying
fatherCountryCode varchar 255 √ null
motherCountryCode varchar 255 √ null
userStatus varchar 255 √ 'Active'::character varying
isPasswordChange bool 1 √ false
disabilityApplicable varchar 255 √ null
loginLogs json 2147483647 √ null
parentsEmail varchar 255 √ null
studentLoginOtpCreatedAt timestamptz 35,6 √ null
studentLoginOtp varchar 255 √ null
isTranscriptAccesible bool 1 √ true
placementStatus enum_User_placementStatus 2147483647 'InPlacement'::"enum_User_placementStatus"
mobileDeviceToken jsonb 2147483647 √ '[]'::jsonb
educationStatus varchar 255 √ null
employmentStatus varchar 255 √ null
notificationSendTime json 2147483647 √ '{"Session":[{"name":"Upcoming Session","time":null},{"name":"Feedback Reminder","time":null}],"Course_Announcement":[{"name":"Course Announcement","time":null}],"Assignment":[{"name":"New Assignment","time":null},{"name":"Feedback Updated","time":null},{"name":"Marks Updated","time":null}],"Events":[{"name":"New Event Created","time":null}]}'::json
studentProfileTab jsonb 2147483647 √ null
isOnline bool 1 √ false
chatActivity jsonb 2147483647 √ '{}'::jsonb

Indexes

Constraint Name Type Sort Column(s)
User_pkey Primary key Asc id
User_id_idx Performance Asc id
User_officialEmail_key Must be unique Asc officialEmail
User_officialEmail_key1 Must be unique Asc officialEmail
User_officialEmail_key2 Must be unique Asc officialEmail
User_officialEmail_key3 Must be unique Asc officialEmail
User_officialEmail_key4 Must be unique Asc officialEmail
User_officialEmail_key5 Must be unique Asc officialEmail
User_officialEmail_key6 Must be unique Asc officialEmail
User_parentsEmail_key Must be unique Asc parentsEmail
User_parentsEmail_key1 Must be unique Asc parentsEmail
User_parentsEmail_key2 Must be unique Asc parentsEmail
User_parentsEmail_key3 Must be unique Asc parentsEmail
User_userName_key Must be unique Asc userName
User_uuid_idx Performance Asc uuid
User_uuid_key Must be unique Asc uuid
User_uuid_key1 Must be unique Asc uuid
User_uuid_key2 Must be unique Asc uuid
User_uuid_key3 Must be unique Asc uuid
User_uuid_key4 Must be unique Asc uuid
User_uuid_key5 Must be unique Asc uuid
User_uuid_key6 Must be unique Asc uuid

Relationships

Close relationships within degrees of separation