User

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

serial

√

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
FormResponse.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
QuizProctoring.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

2147483647

null

JobViews.userId	fk_jobviews_userId	C
OffCampus.userId	OffCampus_userId_fkey	C
StudentNotes.studentId	StudentNotes_studentId_fkey	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

√

false

organizationId

int4

null

Organization.id

User_organizationId_fkey

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

null

updatedBy

int4

√

null

createdAt

timestamptz

35,6

√

null

updatedAt

timestamptz

35,6

√

null

resume

varchar

255

√

null

resumeFileName

varchar

255

√

null

onBoarding

bool

√

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

√

false

primaryPreMbaDomain

text

2147483647

√

null

primaryPostMbaDomain

text

2147483647

√

null

secondaryPostMbaDomain

text

2147483647

√

null

tertiaryPostMbaDomain

text

2147483647

√

null

isOptedPlacementProcess

bool

√

false

isInternationalPlacement

bool

√

false

countryInterested

varchar

255

√

null

isAnotherCountryVisa

bool

√

false

isAnotherCountryWorkVisa

bool

√

false

countryVisaName

varchar

255

√

null

dreamCompany

json

2147483647

√

null

portfolioLink

text

2147483647

√

null

nationality

varchar

255

√

null

category

varchar

255

√

null

isBelowPovertyLine

bool

√

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":false},{"name":"sms","status":true},{"name":"push","status":true}],"courseAnnouncements":[{"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":false},{"name":"sms","status":true},{"name":"push","status":true}],"newAssignment":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"feedbackUpdated":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"marksUpdated":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"newEventCreated":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"myEventsUpdates":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"assignmentReminder":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"assignmentsubmission":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"assignmentFeedbackRequestSend":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"adminResponceFeedbackRequest":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"courseEnrollement":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"doubt":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"counsellerLog":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"flagLog":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"userStatus":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"TicketResolved":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"ticketClosed":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"ticketEsclated":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"ticketNewReply":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"ticketCreate":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"ticketUpdateStatus":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"sessionRecording":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"TicketCloseInactivity":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"preRead":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"inClass":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"outClass":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}],"feedbackConfirmation":[{"name":"email","status":true},{"name":"whatsapp","status":false},{"name":"sms","status":true},{"name":"push","status":true}]}'::json

parentsMobileNumber

varchar

255

√

null

otp

varchar

255

√

null

otpCreatedAt

timestamptz

35,6

√

null

isFingerPrintSync

bool

√

false

isFaceScannerSync

bool

√

false

addToDevice

bool

√

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

√

false

disabilityApplicable

varchar

255

√

null

loginLogs

json

2147483647

√

null

parentsEmail

varchar

255

√

null

studentLoginOtpCreatedAt

timestamptz

35,6

√

null

studentLoginOtp

varchar

255

√

null

isTranscriptAccesible

bool

√

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

√

false

chatActivity

jsonb

2147483647

√

'{}'::jsonb

notificationAdminSchedule

json

2147483647

√

'{"Ticket":[{"name":"New Ticket Assign","subName":"Notification sent when a new ticket is assigned to the admin","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Ticket Open Reminder","subName":"Notification sent when a ticket remains open for a predefined period without any action.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Ticket Escalated Reminder","subName":"Notification sent when a ticket is escalated.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Pending Reminder","subName":"Notification sent when a ticket remains pending for a predefined period without any action.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Tickets Summary","subName":"A periodic summary of all tickets handled by the admin, including their statuses","time":null,"action":true,"uniqueSlug":"New_ticket"}],"session":[{"name":"Session Location Not Updated","subName":"When a session is created or scheduled but the location (physical or virtual) has not been updated.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Upcoming Session Reminder","subName":"Reminder sent 24 hours or a configurable time before a session starts.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Attendance Marking Reminder","subName":"Sent if attendance for a session is not marked within a specified time after the session ends.","time":null,"action":true,"uniqueSlug":"New_ticket"}],"Assignment":[{"name":"Assignment Deadline Completed","subName":"When the deadline for an assignment has passed.","time":null,"action":true,"uniqueSlug":"New_ticket"},{"name":"Grading Reminders","subName":"When grading for an assessment is pending beyond a certain time after the submission deadline.","time":null,"action":true,"uniqueSlug":"New_ticket"}]}'::json

avatar

varchar

255

√

null

DebarRsn

json

2147483647

√

null

placementSummary

json

2147483647

√

null

deviceInfo

json

2147483647

√

null

aboutMe

text

2147483647

√

null

experienceHighlight

text

2147483647

√

null

userFeedbackAnonymousPreference

bool

√

false

isFeedbackAnonymous

bool

√

false

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_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

Columns

Indexes

Relationships

Close relationships within degrees of separation