Users


Description

User Information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
CompanyJobSlotsSubscriptions.creatorUserId CompanyJobSlotsSubscriptions_creatorUserId_fkey R
Orders.userId Orders_userId_fkey R
PointsJournalEntries.userId PointsJournalEntries_userId_fkey N
PointsTopUpOrders.userId PointsTopUpOrders_userId_fkey R
ProductPurchaseAssistanceRequests.userId ProductPurchaseAssistanceRequests_userId_fkey N
SubscriptionPlanAssistanceRequests.userId SubscriptionPlanAssistanceRequests_userId_fkey N
CompanyCreditInventoryLogs.userId CompanyCreditInventoryLogs_userId_fkey N
CompanyProductInventoryLogs.userId CompanyProductInventoryLogs_userId_fkey N
CompanyProductInventoryUsageFromBalanceLogs.userId CompanyProductInventoryUsageFromBalanceLogs_userId_fkey N
CreditProductPurchaseOrders.userId CreditProductPurchaseOrders_userId_fkey N
CreditPurchaseOrders.userId CreditPurchaseOrders_userId_fkey N
JobProductInventoryUsageFromBalanceLogs.userId JobProductInventoryUsageFromBalanceLogs_userId_fkey N
OfflineSalesTransactions.userId OfflineSalesTransactions_userId_fkey N
PurchaseOrders.userId PurchaseOrders_userId_fkey N
ExpertRatings.expertUserId ExpertRatings_expertUserId_fkey C
ExpertReviews.expertUserId ExpertReviews_expertUserId_fkey C
PreviousLearnerPromotionNotifications.matchingExpertUserId PreviousLearnerPromotionNotifications_matchingExpertUserId_fkey R
Attachments.UserId Attachments_UserId_fkey C
BlackListedContents.ReporterId BlackListedContents_ReporterId_fkey N
BlockedUsers.BlockedUserId BlockedUsers_BlockedUserId_fkey C
BlockedUsers.BlockerUserId BlockedUsers_BlockerUserId_fkey C
Bookmarks.UserId Bookmarks_UserId_fkey C
DeletedPosts.DeleteUserId DeletedPosts_DeleteUserId_fkey C
DeletedPosts.UserId DeletedPosts_UserId_fkey C
Groups.UserId Groups_UserId_fkey R
GroupUsers.UserId GroupUsers_UserId_fkey R
Posts.UserId Posts_UserId_fkey N
Publishers.CreatorId Publishers_CreatorId_fkey N
Publishers.UserId Publishers_UserId_fkey C
Reactions.UserId Reactions_UserId_fkey C
Replies.CMSCreatorId Replies_CMSCreatorId_fkey N
Replies.UserId Replies_UserId_fkey N
ReportedUsers.ReporterUserId ReportedUsers_ReporterUserId_fkey C
ReportedUsers.UserId ReportedUsers_UserId_fkey C
UnifiedTalentProfiles.userId UnifiedTalentProfiles_userId_fkey N
SeoNegativeKeywords.createdByUserId SeoNegativeKeywords_createdByUserId_fkey N
ApiClients.CreatorId ApiClients_CreatorId_fkey N
ApplicationCSVExportRequests.exporterId ApplicationCSVExportRequests_exporterId_fkey C
ApplicationDrafts.ApplicantId ApplicationDrafts_ApplicantId_fkey N
ApplicationRejectionMessagePreferences.UserId ApplicationRejectionMessagePreferences_UserId_fkey C
ApplicationRejectionMessages.UserId ApplicationRejectionMessages_UserId_fkey C
Applications.ApplicantId Applications_ApplicantId_fkey N
Applications.FirstReaderId Applications_FirstReaderId_fkey C
ApplicationStatusLogs.CreatorId ApplicationStatusLogs_CreatorId_fkey R
BannedLiveRoomUsers.UserId BannedLiveRoomUsers_UserId_fkey C
BlackListedWords.CreatorId BlackListedWords_CreatorId_fkey N
Bookmarks.CandidateId Bookmarks_CandidateId_fkey C
Bookmarks.UserId Bookmarks_UserId_fkey C
CandidateExperiences.UserId CandidateExperiences_UserId_fkey C
ChatAutoInvitations.candidateId ChatAutoInvitations_candidateId_fkey C
Comments.CandidateId Comments_CandidateId_fkey C
Comments.CommenterId Comments_CommenterId_fkey C
Companies.EmployerServiceRepId Companies_EmployerServiceRepId_fkey N
Companies.ReviewerId Companies_ReviewerId_fkey R
CompanyAddresses.creatorId CompanyAddresses_creatorId_fkey N
CompanyDeletionRequests.requesterId CompanyDeletionRequests_requesterId_fkey N
CompanyFeaturesMaximum.creatorId CompanyFeaturesMaximum_creatorId_fkey N
CompanyStatusLog.userId CompanyStatusLog_userId_fkey N
CompanyVerificationRequests.employerServiceRepId CompanyVerificationRequests_employerServiceRepId_fkey N
CompanyVerificationRequests.requesterId CompanyVerificationRequests_requesterId_fkey N
CompanyVerificationRequestStatusChangeLogs.userId CompanyVerificationRequestStatusChangeLogs_userId_fkey N
CoverLetters.UserId CoverLetters_UserId_fkey R
EmailLogs.RecipientId EmailLog_RecipientId_fkey C
EmployerCustomMessages.UserId EmployerCustomMessages_UserId_fkey C
EmployerVerifications.UserId EmployerVerifications_UserId_fkey C
EventRegistrations.UserId EventRegistrations_UserId_fkey R
Experiences.UserId Experiences_UserId_fkey N
ExpertApplications.userId ExpertApplications_userId_fkey N
ExpertClassApplicationCSVExportRequests.exporterId ExpertClassApplicationCSVExportRequests_exporterId_fkey C
ExpertClassCertificates.UserId ExpertClassCertificates_UserId_fkey R
ExpertClassCertificateTokens.usedBy ExpertClassCertificateTokens_usedBy_fkey R
ExpertClasses.CreatorId Events_CreatorId_fkey R
ExpertClassPromotionCodeActionLogs.UserId ExpertClassPromotionCodeActionLogs_UserId_fkey R
ExpertClassSpeakers.UserId ExpertClassSpeakers_UserId_fkey R
Experts.userId Experts_userId_fkey N
FailedModerationLogs.UserId FailedModerationLogs_UserId_fkey N
Following.FollowedUserId Following_FollowedUserId_fkey R
Following.FollowerUserId Following_FollowerUserId_fkey R
FraudCaseFileLogs.EditorId FraudCaseFileLogs_EditorId_fkey N
FraudUpdateForJobs.houstonUserId FraudUpdateForJobs_houstonUserId_fkey N
FraudVerificationLists.addedByUserId FraudVerificationLists_addedByUserId_fkey N
GroupMembers.AdminId GroupMembers_AdminId_fkey C
GroupMembers.CandidateId GroupMembers_CandidateId_fkey C
HoustonActionLogs.userId HoustonActionLogs_userId_fkey N
HoustonInboundUpsellCompanyActionLogs.employerServiceRepId HoustonInboundUpsellCompanyActionLogs_employerServiceRepId_fkey N
HoustonOutboundUpsellCompanyActionLogs.employerServiceRepId HoustonOutboundUpsellCompanyActionLog_employerServiceRepId_fkey N
HoustonRoleBindings.UserId HoustonRoleBindings_UserId_fkey R
HoustonSwallowUserActionLogs.swallowedUserId HoustonSwallowUserActionLogs_swallowedUserId_fkey C
HoustonTransferCompanyActionLogs.newEmployerServiceRepId HoustonTransferCompanyActionLogs_newEmployerServiceRepId_fkey C
HoustonTransferCompanyActionLogs.oldEmployerServiceRepId HoustonTransferCompanyActionLogs_oldEmployerServiceRepId_fkey C
HoustonTransferCompanyTaskLogs.houstonUserId HoustonTransferCompanyTaskLogs_houstonUserId_fkey N
HoustonTransferCompanyTaskLogs.newEmployerServiceRepId HoustonTransferCompanyTaskLogs_newEmployerServiceRepId_fkey N
HoustonTransferCompanyTaskLogs.oldEmployerServiceRepId HoustonTransferCompanyTaskLogs_oldEmployerServiceRepId_fkey N
Identities.UserId Identities_UserId_fkey C
InterceptedFraudMessages.ResolverId InterceptedFraudMessages_ResolverId_fkey N
InterceptedFraudMessages.senderId InterceptedFraudMessages_senderId_fkey N
InternalTalentProfileGlintsUsers.sourceProfileId InternalTalentProfileGlintsUsers_sourceProfileId_fkey C
JobBoostingTasks.UserId JobBoostingTasks_UserId_fkey C
JobDrafts.CreatorId JobDrafts_CreatorId_fkey N
JobDrafts.EmployerServiceRepId JobDrafts_EmployerServiceRepId_fkey N
JobExtensionLogs.actionUserId JobExtensionLogs_actionUserId_fkey N
JobFeaturesMaximum.creatorId JobFeaturesMaximum_creatorId_fkey N
JobLocationPreferences.UserId JobLocationPreferences_UserId_fkey C
JobRolePreferences.UserId JobRolePreferences_UserId_fkey C
Jobs.CreatorId Jobs_CreatorId_fkey N
Jobs.EmployerServiceRepId Jobs_EmployerServiceRepId_fkey N
JobStatusLogs.actionUserId JobStatusLogs_actionUserId_fkey N
LiveRoomHosts.UserId LiveRoomHosts_UserId_fkey C
LiveRoomReminders.UserId LiveRoomReminders_UserId_fkey C
MobileAppVersions.editorId MobileAppVersions_editorid_fkey R
NormalizedBenefits.updatedByUserId NormalizedBenefits_updatedByUserId_fkey N
Notifications.RecipientId Notifications_RecipientId_fkey R
OdysseyPointAllocations.UserId OdysseyPointAllocations_UserId_fkey R
OdysseyTargetPreferences.UserId OdysseyTargetPreferences_UserId_fkey C
OdysseyUserRewards.UserId OdysseyUserRewards_UserId_fkey C
Orders.CustomerId Orders_CustomerId_fkey N
Organizations.GeneratedByUserId Organizations_GeneratedByUserId_fkey R
PendingUserCompanies.UserId PendingUserCompanies_UserId_fkey C
PotentialLeads.leadAssigneeId PotentialLeads_leadAssigneeId_fkey R
PotentialLeadStatusChangeLogs.creatorId PotentialLeadStatusChangeLogs_creatorId_fkey C
Preferences.UserId Preferences_UserId_fkey C
ProfileCompletionScores.UserId Scores_UserId_fkey N
PushNotifications.UserId PushNotifications_UserId_fkey N
Recommendations.CandidateId Recommendations_CandidateId_fkey C
Recommendations.CreatorId Recommendations_CreatorId_fkey C
RecommendationStatusLogs.CreatorId RecommendationStatusLogs_CreatorId_fkey R
Referees.UserId Referees_UserId_fkey R
ReferralApplications.RecruiterId ReferralApplications_RecruiterId_fkey R
ReportedCandidates.reportedUserId ReportedCandidates_reportedUserId_fkey N
ReportedCandidates.reporterId ReportedCandidates_reporterId_fkey N
ReportedJobs.ResolverId ReportedJobs_ResolverId_fkey N
ReportedJobs.UserId ReportedJobs_UserId_fkey N
ScheduledPushNotificationRecipients.recipientUserId ScheduledPushNotificationRecipients_recipientUserId_fkey C
ScheduledPushNotifications.userId ScheduledPushNotifications_userId_fkey R
Shares.UserId Shares_UserId_fkey R
ShareSignUps.UserId ShareSignUps_UserId_fkey R
ShareVisitors.UserId ShareVisitors_UserId_fkey R
SpecialLocations.addedByUserId SpecialLocations_addedByUserId_fkey N
SystemPredictionResolutions.ResolverId SystemPredictionResolutions_ResolverId_fkey N
TalentBookmarks.TalentId TalentBookmarks_TalentId_fkey C
TalentBookmarks.UserId TalentBookmarks_UserId_fkey C
TalentHuntJobApplications.CandidateId TalentHuntJobApplications_CandidateId_fkey R
TalentHuntJobApplications.CreatorId TalentHuntJobApplications_CreatorId_fkey R
TalentHuntJobApplications.RecruiterId TalentHuntJobApplications_RecruiterId_fkey R
TalentHuntJobApplicationStatusLogs.CreatorId TalentHuntJobApplicationStatusLogs_CreatorId_fkey R
TalentHuntJobApplicationStatusLogs.ReferredRecruiterId TalentHuntJobApplicationStatusLogs_ReferredRecruiterId_fkey R
TalentReservations.RecruiterId TalentReservations_RecruiterId_fkey C
TalentReservations.TalentId TalentReservations_TalentId_fkey C
UnifiedCompanyGlintsLinks.CuratorId UnifiedCompanyGlintsLinks_CuratorId_fkey R
UnifiedCompanyHubspotLinks.CuratorId UnifiedCompanyHubspotLinks_CuratorId_fkey R
UnifiedCompanyNetsuiteLinks.CuratorId UnifiedCompanyNetsuiteLinks_CuratorId_fkey R
UnlockedTalents.talentId UnlockedTalents_talentId_fkey C
UnlockedTalents.unlockedByUserId UnlockedTalents_unlockedByUserId_fkey N
UserBannerTrackings.UserId UserBannerTrackings_UserId_fkey C
UserCandidateStatusLogs.CandidateId UserCandidateStatusLogs_CandidateId_fkey R
UserCandidateStatusLogs.CreatorId UserCandidateStatusLogs_CreatorId_fkey R
UserCompanies.UserId UserCompanies_UserId_fkey C
UserCompaniesOpsTeamDataBackup.UserId UserCompaniesOpsTeamDataBackup_UserId_fkey C
UserCompanyLogs.actionPerformerId UserCompanyLogs_actionPerformerId_fkey N
UserCompanyLogs.userId UserCompanyLogs_userId_fkey C
UserCompanyRoleLogs.actionUserId UserCompanyRoleLogs_actionUserId_fkey N
UserDeviceFingerprints.UserId UserDeviceFingerprints_UserId_fkey C
UserFeedbacks.UserId UserFeedbacks_UserId_fkey N
UserJobAlerts.userId UserJobAlerts_userId_fkey C
UserJobSearchConditions.UserId UserJobSearchConditions_UserId_fkey R
UserMessagingIntroMessages.userId UserMessagingIntroMessages_userId_fkey C
UserMessagingResponseStatistics.UserId UserMessagingResponseStatistics_UserId_fkey C
UserMessagingTemplateMessages.userId UserMessagingTemplateMessages_userId_fkey C
UserNotificationPreferences.UserId UserNotificationPreferences_UserId_fkey C
UserResumeParserUsageCounts.UserId UserResumeParserUsageCounts_UserId_fkey C
Users.BanningOperatorId Users_BanningOperatorId_fkey R
Users.EmployerServiceRepId Users_EmployerServiceRepId_fkey N
Users_cdc_test.BanningOperatorId Users_cdc_test_BanningOperatorId_fkey R
Users_cdc_test.EmployerServiceRepId Users_cdc_test_EmployerServiceRepId_fkey N
UserShares.UserId UserShares_UserId_fkey N
UserSignupTrackings.UserId UserSignupTrackings_UserId_fkey C
UserSkills.UserId UserSkills_UserId_fkey C
UserTokens.UserId UserTokens_UserId_fkey R
WhatsappLogs.recipientId WhatsappLogs_recipientId_fkey N
XenditCustomerInformation.userId XenditCustomerInformation_userId_fkey C
Answers.UserId Answers_UserId_fkey R
AnswerUpvotes.UserId AnswerUpvotes_UserId_fkey R
Comments.UserId Comments_UserId_fkey R
CommentUpvotes.UserId CommentUpvotes_UserId_fkey R
PollVotes.UserId PollVotes_UserId_fkey R
QuestionBookmarks.UserId QuestionBookmarks_UserId_fkey R
Questions.UserId Questions_UserId_fkey R
QuestionUpvotes.UserId QuestionUpvotes_UserId_fkey R
QuestionViews.UserId QuestionViews_UserId_fkey R
UserSearchTerms.UserId UserSearchTerms_UserId_fkey R
InternalMessagingPlatformUsers.userId InternalMessagingPlatformUsers_userId_fkey C
Recruiters.userId Recruiters_userId_fkey R
UserJobOrderSearchConditions.userId UserJobOrderSearchConditions_userId_fkey C

Primary Key.
email varchar 255 null

User email. Must be Unique.
password varchar 255 null

User password.
passwordResetToken varchar 255 √ null

Token to verify users own the email. For resetting password.
passwordResetTokenExpiry timestamptz 35,6 √ null

Datetime indicating expiry of PasswordResetToken.
preferences jsonb 2147483647 √ null

Legacy column that acted as metadata field. NOT USER PREFERENCES. Hidden Field in Production.
firstName varchar 255 √ null

User First Name.
lastName varchar 255 √ null

User Last Name.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
CountryCode varchar 255 null
Countries.code Users_CountryCode_fkey N

Country Code of country that this user reside in. Foreign Key references Countries.
phone varchar 255 √ null

User Phone Number.
birthDate date 13 √ null

User Birthdate.
Nationality varchar 255 √ null
Countries.code Users_Nationality_fkey R

User Nationality. Foreign Key references Countries.
lastSeen timestamptz 35,6 √ null

Datetime of user’s last authenticated API request, as a proxy of last user activity on site.
emailVerificationToken varchar 255 √ null

Token to verify users own the email they are setting to.
emailVerificationTokenExpiry date 13 √ null

Datetime indicating expiry of emailVerificationToken.
preferredLanguage varchar 255 √ null

ISO 639-1 language code.
intro text 2147483647 √ null

Text for candidate to introduce themselves in their profiles.
resume varchar 255 √ null

File name linking to their resumes in s3 bucket glints-dashboard/resume.
profilePic varchar 255 √ null
portfolio jsonb 2147483647 √ null

Website url to their portfolio.
role enum_Users_role 2147483647 'CANDIDATE'::"enum_Users_role"

Enum type of their role on Glints website (eg. CANDIDATE, COMPANY). Affects their API access.
gender enum_Users_gender 2147483647 √ null

User Gender.
race enum_Users_race 2147483647 √ null

User Race.
isEmployed bool 1 √ null
isPublic bool 1 false
slug varchar 255 √ null

SEO-friendly, unique readable id for generating their public profile urls.
CityId int4 10 √ null
Cities.id Users_CityId_fkey N

Foreign Key to Cities Table.
metadata jsonb 2147483647 √ null

Additional information about the users added by the site, and for consumption by the site, or API.
resumeText text 2147483647 √ null

Parsed out text of their resume documents.
residentialStatus enum_Users_residentialStatus 2147483647 √ null

The status of their residence in their country indicated by CountryCode. Enum type.
candidateStatus enum_Users_candidateStatus 2147483647 'I_AM_LOOKING_FOR_JOB'::"enum_Users_candidateStatus"
candidateStatusExpiryMonth int4 10 √ null
candidateStatusExpiryYear int4 10 √ null
shadowBanned bool 1 false

Shadow ban status
BanningOperatorId uuid 2147483647 √ null
Users.id Users_BanningOperatorId_fkey R

The operator who implemented the ban
banNote text 2147483647 √ null

A note to indicate reasons for the ban
bannedAt timestamptz 35,6 √ null

Time of banning
phoneNumberVerificationToken text 2147483647 √ null
phoneNumberVerificationTokenExpiry timestamptz 35,6 √ now()
companyRole text 2147483647 √ null
LocationId uuid 2147483647 √ null
Locations.id Users_LocationId_fkey N

Foreign Key to Locations Table
highestEducationLevel enum_EducationLevel_type 2147483647 √ null

Highest education level of the user
whatsappVerificationToken text 2147483647 √ null

Token to verify users own whatsapp number.
whatsappVerificationTokenExpiry timestamptz 35,6 √ now()

Datetime indicating expiry of whatsappVerificationToken.
whatsappNumber varchar 30 √ NULL::character varying

This column is not used to store whatsapp number for employers. Employers still use the phone column instead.
careerStartDate date 13 √ null
EmployerServiceRepId uuid 2147483647 √ null
Users.id Users_EmployerServiceRepId_fkey N

This represents who this user was created by.
whatsappLoginNumber varchar 30 √ NULL::character varying

Whatsapp number for user login functionality
preferredLocations jsonb 2147483647 √ null

List of user’s preferred locations via map interface

Indexes

Constraint Name Type Sort Column(s)
Users_pkey Primary key Asc id
Users_createdAt_idx Performance Asc createdAt
Users_email_gin_idx Performance Asc email
Users_email_idx Performance Asc email
Users_email_key Must be unique Asc email
Users_EmployerServiceRepId_idx Performance Asc EmployerServiceRepId
Users_lastSeen_idx Performance Desc lastSeen
Users_role_idx Performance Asc role
Users_slug_key Must be unique Asc slug
Users_whatsappLoginNumber_key Must be unique Asc whatsappLoginNumber

Check Constraints

Constraint Name Constraint
company_role_in_company_only_check (((("companyRole" IS NOT NULL) AND (role = 'COMPANY'::"enum_Users_role")) OR ("companyRole" IS NULL)))
shadowBanned_BanningOperatorId_bannedAt_consistencyCheck (((("shadowBanned" IS FALSE) AND ("BanningOperatorId" IS NULL) AND ("banNote" IS NULL) AND ("bannedAt" IS NULL)) OR (("shadowBanned" IS TRUE) AND ("BanningOperatorId" IS NOT NULL) AND ("bannedAt" IS NOT NULL))))

Relationships

Close relationships within degrees of separation