Tables


SchemaSpy Analysis of glints.public

Generated on Sat Oct 17 20:04 GMT 2026

XML Representation
Insertion Order Deletion Order
TABLES 291
VIEWS 11
COLUMNS 2545
Constraints 491
Anomalies 18
Routines 1171

Database Properties

Database Type: PostgreSQL - 14.15 (Ubuntu 14.15-1.pgdg22.04+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
CustomNotifications 0 1 14 Table
JobRoleScoring 0 3 10 Table
Groups 2 0 11 Table

Abstraction group jobs and companies, primarily used for whitelabel sites.
JobJobTitles 0 2 5 Table

Jobs belonging to Job Titles.
TalentHuntJobInfoLogs 0 1 4 Table
JobSalaryDrafts 0 2 10 Table

Draft for JobSalary.
Experiences 0 4 18 Table

Work and Education experience of User.
WhatsappLogs 0 1 9 Table
TalentBookmarks 0 2 5 Table
UserMessagingIntroMessages 0 1 5 Table

Users’ intro message.
JobScreeningQuestionLanguages 0 2 2 Table
XenditSubscriptionWebhookLogs 0 0 9 Table
LocationAlternateNames 0 1 5 Table
PendingUserCompanies 0 2 6 Table

Relation to record Users’ Requests to Join Company.
TalentHuntJobInfo 2 1 4 Table
UserDeviceFingerprints 0 1 7 Table

Each row corresponds to an authorised device fingerprint (system, platform, and IP address) for a particular user.
HierarchicalJobCategories 28 0 7 Table
PopularJobSearchesCache 0 0 3 Table
UserMessagingTemplateMessages 0 1 5 Table

Users’ custom messaging templates.
UserWhatsappLoginVerificationRecords 0 0 8 Table
CompanyFeaturesMaximum 0 4 10 Table
Countries 42 0 9 Table

Country Information
CompanyCollections 2 0 4 Table
UserSkills 0 2 6 Table

Skills that users possess.
CompanyVerificationMethodBenefits 0 1 6 Table
UnlockedTalents 0 3 5 Table
LiveRooms 4 3 10 Table
PotentialLeadDigitalFootprints 0 2 9 Table
JobLocationPreferences 0 4 8 Table

Job Location Preference and Visa Information.
QuestionKeywordMapping 0 2 7 Table
MergedTalentProfiles 10 0 3 Table

Merged talent profiles.
AlternativePhoneNumbers 0 3 6 Table
Preferences 0 2 17 Table

Job Preferences of User.
CompanyCollectionItems 0 2 6 Table
SystemPredictionLogs 1 1 6 Table
IncentiveRulesForSharing 0 2 11 Table
TalentHuntCandidateApplicationStatusNotifications 0 2 3 Table
UserJobAlertNotifications 0 2 5 Table

Users’ in-app job alerts notification content table.
CustomHiringManagerQuestionsConfigs 7 0 8 Table
JobJobTitleDrafts 0 2 5 Table

Joined Table.
ReportedJobs 3 3 11 Table
CompanyDeal 2 0 7 Table
UserShares 0 2 3 Table
XenditCustomerInformation 0 1 5 Table
SuggestedSalaries 0 3 7 Table
XenditInvoiceCallbackLogs 0 0 9 Table
Schools 3 1 13 Table

Schools
DigitalFootprintBlacklistedKeywords 0 0 4 Table
HoustonRoleBindings 0 2 5 Table
VerificationWhitelistedEmailDomains 0 1 5 Table

Whitelisted email domains which can bypass company verification.
Recommendations 2 3 11 Table

Talent recommendations to TalentHunt jobs.
Bookmarks 0 5 9 Table

Candidates’ bookmarks of jobs and companies, and Companies’ bookmarks of candidates.
Companies 81 7 48 Table

Company Information.
CompanyTrafficControlList 0 0 10 Table
MatchQuestionsPool 2 0 14 Table
HoustonCreateCompanyActionLogs 0 2 2 Table
HoustonJobQualityIssueActionLogs 0 2 4 Table
FeatureLifetimeCount 0 0 7 Table
UserCompanyRoleLogs 0 2 7 Table
LiveRoomShares 0 2 3 Table
Users_cdc_test 0 6 51 Table
LiveRoomHosts 0 2 3 Table
ApplicationQuestionAnswers 0 2 7 Table
JobNotificationReceiverDrafts 0 2 5 Table
NormalizedSkillsMapping 0 2 5 Table
CompaniesPageConfigs 2 1 6 Table
SourcedCompanies 1 2 10 Table
JobFeaturesMaximum 0 6 12 Table
Jobs 44 10 49 Table

Job Posting.
ApplicationStatusNotifications 0 2 2 Table
PointOfInterests 1 2 10 Table
ApplicationStatusLogs 3 2 8 Table
TalentHuntEnquirers 2 0 8 Table

None of the keys in this table are unique since we want to allow duplicates, this being a public form. You do not want someone else to enter your email and then you are not allowed to enter a enquiry.
HoustonReportedJobActionLogs 0 2 6 Table
ApplicationRejectionReasons 0 1 4 Table
JobDrafts 8 10 43 Table

Job Posting Draft.
OrderPayments 0 1 8 Table
GroupJobs 0 2 7 Table

Jobs in groups.
Industries 5 0 7 Table

Industry Information
Applications_copy1 0 3 21 Table

Job Application.
AccountManagerHubspotDealBatches 0 1 9 Table
PotentialLeadDigitalFootprintVerificationCriteria 1 0 4 Table
DistributionActions 1 1 6 Table
ChatBlockingList 0 4 16 Table
JobRoleQuestionGroup 1 0 10 Table
MTSeatDeactivations 1 2 11 Table
UserPhoneNumberFlags 1 2 7 Table
CitySubDivisions 4 2 5 Table
FailedModerationLogs 0 1 6 Table
JobFraudAnalysisRecords 0 2 7 Table
SchoolEducationLevels 0 1 3 Table
JobPreferredKeywordDrafts 0 1 9 Table
LandingPageLeads 0 1 9 Table

Stores leads captured from landing pages before they complete signup
NormalizedSkills 4 0 4 Table
JobDraftScreeningQuestionCustomPlainTexts 0 1 6 Table
XenditPaymentRequestCallbackLogs 0 0 9 Table
ApplicationScreeningAnswerDocumentAndCertificates 0 2 3 Table
HoustonOutboundUpsellCompanyActionLogs 0 3 4 Table
HoustonRolePermissions 0 1 4 Table
Referrals 1 0 7 Table
RevenueCatWebhookLogs 0 1 11 Table
ChatAutoInvitations 2 2 8 Table
CompanyStatusLog 0 2 7 Table
Timezones 15 0 3 Table
CompanyFraudRuleExemptions 0 4 12 Table
TalentHuntCandidateApplications 1 1 5 Table
DistributionRules 0 3 9 Table
Referees 1 1 8 Table
Studies 1 0 6 Table

Names of Study.
JobSalaries 0 2 10 Table

Job Salary.
HoustonInboundUpsellCompanyActionLogs 0 3 4 Table
CompaniesPageCarouselItems 0 2 11 Table
JobBenefits 0 1 6 Table
JobExtensionLogs 0 2 8 Table
ApplicationDrafts 0 2 7 Table

Application Draft.
SourcedJobs 0 5 22 Table
NotificationPreferenceCategories 2 1 6 Table

Category for each type of notification preference.
Applications 6 3 21 Table

Job Application.
JobPreferredKeywords 0 1 9 Table
ReferralApplications 0 4 8 Table
ApplicationScreeningAnswerSkills 0 2 3 Table
JobCategorySkills 0 2 5 Table

Join Table between Job Categories and Skills,relating to skills needed for a job category.
CompanyVerificationRequestDetails 0 1 6 Table
NotificationPreferenceCategoryNotifications 0 1 5 Table

Notifications that belong to each notification preference category.
SeoFreeQueries 2 1 5 Table
HoustonActionLogs 9 1 5 Table
UserTokens 0 1 8 Table
HoustonSwallowUserActionLogs 0 2 2 Table
SpecialLocations 0 3 8 Table
MTSeatDeactivations_MTSeatDeactivationReasons 0 2 3 Table
BlackListedWords 1 1 6 Table
LocationWageGuidance 0 2 8 Table
PaymentToken2C2PWebhookLogs 0 0 10 Table
RecommendationStatusLogs 1 2 8 Table
marketplace_mobile_app 0 0 6 Table
CompanyVerificationRequests 2 4 15 Table
EmployerVerifications 0 2 12 Table
FollowingNewFollowerNotifications 0 2 2 Table
CompanySharingsMetrics 0 2 15 Table
JobShares 0 2 3 Table
CompanyApplicationCountAggregates 0 1 6 Table
MTBusinessUnits 1 0 6 Table
ApplicationScreeningAnswerIndustries 0 2 3 Table
UnifiedCompanyNetsuiteLinks 0 2 5 Table

Links to company entities on NetSuite.
ShareVisitors 0 2 6 Table
JobScreeningQuestionIndustries 0 2 2 Table
PotentialLeads 5 4 21 Table
LiveRoomTopics 1 1 4 Table
BlacklistedLegalRegistrationNumbers 0 0 6 Table
UserJobAlerts 1 1 10 Table
ApplicationRejectionMessagePreferences 0 1 4 Table
GroupMembers 2 4 10 Table

Users and Companies membership in groups.
HoustonTransferCompanyTaskLogs 0 4 13 Table
JobDraftScreeningQuestionIndustries 0 2 2 Table
AutomatedApplicationCSVExportLogs 0 1 8 Table
JobDraftScreeningQuestions 4 2 6 Table
ReportedCandidates 0 4 10 Table
HierarchicalJobCategory_MPTT 1 2 7 Table
JobTitleSkills 0 2 5 Table

Skills that is needed for a job title.
UserCompaniesOpsTeamDataBackup 0 2 6 Table
ExternalTalentProfileCakeResumeUsers 0 1 4 Table

Merged talent profiles join table with CakeResume Users.
CompanyDeletionRequests 0 2 8 Table
CompaniesPageCollections 0 2 6 Table
JobBoostingTasks 0 3 17 Table
JobDraftScreeningQuestionLanguages 0 2 2 Table
PotentialLeadStatusChangeLogs 0 2 8 Table
ScheduledPushNotificationTranslations 0 2 7 Table
MTSeatActivations 2 3 21 Table
BannedLiveRoomUsers 0 2 3 Table
Users 199 7 49 Table

User Information
HoustonFlagJobActionLogs 0 1 4 Table
ApplicationScreeningAnswerCustomPlainTexts 0 2 5 Table
ApplicationScreeningAnswerLanguages 0 2 3 Table
WorkbenchPresets 0 0 14 Table
JobTitleHierarchicalJobCategoryMappings 0 1 6 Table
NormalizedBenefits 1 3 8 Table
ApplicationScreeningAnswers 5 1 9 Table
JobRoleQuestionMapping 0 2 11 Table
PotentialContacts 0 1 12 Table
JobNotificationReceivers 0 2 5 Table
Comments 0 4 11 Table

Notes that employers can leave on any candidates, and can be shared with their fellow admins in the company.
CompanyVerificationRequestStatusChangeLogs 0 2 8 Table
OdysseyPointAllocations 1 1 5 Table

Odyssey points for users
EmployerCustomMessages 0 3 11 Table
LocationLegacyMappings 0 4 5 Table

contains mapping from new location to legacy location
ApplicationCSVExportRequests 0 1 4 Table
CoverLetters 0 1 5 Table
ApplicationFollowUpRequests 0 1 3 Table

Requests sent by candidates to employers to remind employers to follow-up with their applications.
DocumentAndCertificates 3 1 5 Table
Notifications 23 1 7 Table
GeneralConfigs 0 0 4 Table
SystemPredictionResolutions 0 3 7 Table
FraudCaseFileLogs 0 2 10 Table
JobScreeningQuestionDocumentAndCertificates 0 2 2 Table
JobSalarySuggestions 0 0 5 Table
UserPreferredKeywords 0 1 9 Table
JobCSVExportRequests 0 2 11 Table
MultiJobBoostingTasks 0 1 14 Table
ExternalTalentProfileWebScrapedUsers 0 1 4 Table
Languages 8 0 6 Table
LocationAdministrativeLevels 1 0 7 Table
PushNotifications 0 2 11 Table
SchoolCourses 0 2 5 Table

Degree that each School offer.
UserCompanies 5 2 6 Table

Join Table between Users and Companies.
UserResumeParserUsageCounts 0 1 6 Table
CurrencyConversionRates 0 2 5 Table
UnifiedCompanyGlintsLinks 0 2 5 Table

Links to company entities on Glints.
UserFeedbacks 0 3 19 Table
Locations 27 1 11 Table
UnifiedCompanies 3 0 3 Table

Stores unified company IDs.
UserSignupTrackings 0 1 2 Table
FraudVerificationLists 0 2 10 Table

Fraud verification blacklist and watchlist entries for company verification
SalaryEstimates 0 3 9 Table
JobRoleSkills 0 2 7 Table

Mapping table between job roles (hierarchical job categories) and skills
JobScreeningQuestions 4 2 6 Table
ScheduledPushNotifications 2 1 12 Table

This table contains push notifications that will be pushed out at a scheduled time
InternalTalentProfileGlintsUsers 0 2 4 Table

Glints User ID.
InterceptedFraudMessages 0 5 21 Table
MatchKeywordsPool 1 0 11 Table
Currencies 18 0 9 Table

Currency.
Organizations 0 6 19 Table
Orders 1 1 9 Table
JobSkills 1 2 6 Table

Join Table between Jobs and Skills, indicating Skills needed for a Job.
JobStatusLogs 0 2 9 Table
DailyMetricsForJobs 0 3 14 Table
ProfileCompletionScores 0 2 7 Table

Profile Completion Score of entity.
ExternalTalentProfileLinkedInUsers 0 1 4 Table

Merged talent profiles join table with LinkedIn Users.
CandidateExperiences 0 1 7 Table
FeatureDailyCount 0 0 7 Table
JobCategories 10 1 9 Table

Job Category.
HoustonTransferCompanyActionLogs 0 4 7 Table
UserMessagingResponseStatistics 0 1 6 Table
DistributionPipelines 1 1 5 Table
LegacyJobCategoryMappings 0 3 6 Table
LocationHierarchicalMappings 0 4 5 Table

contains mapping from legacy location to new location
Identities 2 1 9 Table

Identities of users from 3rd party identity providers (eg. Facebook, LinkedIn).
CompanyVerificationMethods 2 0 8 Table
Skills 12 0 9 Table

Skills.
UserDeletionRequests 1 0 11 Table
IndustriesV2 2 0 4 Table
EmailLogs 0 1 7 Table
ScheduledPushNotificationRecipients 0 2 5 Table
BlocklistedDomains 0 0 4 Table
PotentialLeadSignals 0 2 13 Table
ActionLogs 0 0 10 Table

Logs of all API requests.
HoustonJobImports 0 2 38 Table
UserJobSearchConditions 0 1 4 Table
RecommendationRejectionReasons 0 2 7 Table
UnifiedCompanyHubspotLinks 0 2 5 Table

Links to company entities on HubSpot.
UserBannerTrackings 0 1 4 Table
FraudUpdateForJobs 0 2 9 Table
JobSkillDrafts 0 2 6 Table

Joined Table.
Shares 10 1 7 Table
JobRolePreferences 0 4 8 Table

Jobs that Candidates Have Experience In and Is Looking For.
spatial_ref_sys 2 0 5 Table
ApplicationRejectionMessages 0 1 5 Table
JobQualityIssues 1 1 7 Table
Cities 20 1 5 Table

Cities Information
JobScreeningQuestionCustomPlainTexts 1 1 6 Table
Location_MPTT 1 2 7 Table
SuggestedJobValuesByCategory 0 2 8 Table

Suggested job values based on L3 HierarchicalJobCategory
Following 1 2 5 Table
Locales 2 0 3 Table

Canonical BCP 47 locale tags accepted by the platform. FK target for Users.preferredLanguage and ScheduledPushNotificationTranslations.locale. Distinct from Languages (which captures spoken-language proficiency).
ApplicationStatusChangePointSources 0 2 2 Table

Odyssey points for creating an application or getting shortlisted
CompanyAddresses 2 4 9 Table
MobileAppVersions 0 2 13 Table
ApplicationFormConfigByJobCategories 0 7 20 Table
JobTitles 8 2 7 Table

Job Titles - a level below Job Categories.
CompanyIdentities 0 1 6 Table
HoustonRoles 2 0 4 Table
PotentialLeadIgnoreReasons 0 1 4 Table
UserDeletionLogs 0 1 6 Table
UserNotificationPreferences 0 2 7 Table

Notification preference for each user for a notification preference category.
AppleLoginFields 0 2 4 Table

Apple Login returns some extra fields which are saved in this table.
JobDraftScreeningQuestionDocumentAndCertificates 0 2 2 Table
TalentReservations 0 2 6 Table
UserCandidateStatusLogs 0 2 8 Table
LiveRoomReminders 0 2 3 Table
ProfileCompletionPoints 0 0 5 Table
UserCompanyLogs 0 3 7 Table
MTSeatDeactivationReasons 1 0 7 Table
ShareSignUps 0 2 5 Table
SequelizeMeta 0 0 3 Table
TalentHuntEnquiries 0 3 14 Table

None of the keys in this table are unique since we want to allow duplicates, this being a public form. You do not want someone else to enter your email and then you are not allowed to enter a enquiry.
Degrees 2 0 4 Table

Name of Degrees
JobBenefitDrafts 0 1 6 Table
HoustonReactivateCompanyActionLogs 0 2 2 Table
ApiClients 0 1 9 Table

Clients that consume our API.
FraudCaseFiles 3 1 7 Table
NoRecentApplicationStatusNotifications 0 1 2 Table
LinkedInPartnershipFieldMaps 0 0 6 Table
geography_columns 0 2 7 View
FraudCaseFilesWithCountsView 0 1 10 View
Talents 0 1 35 View
CountryCities 0 0 16 View

Enables fast location search queries based on Countries and Cities
pg_stat_kcache 0 0 29 View
pg_stat_statements 0 0 33 View
geometry_columns 0 2 7 View
pg_stat_kcache_detail 0 0 32 View
ReportedJobsByJobStats 0 0 5 View
pg_stat_statements_info 0 0 2 View
RecommendedSkills 0 0 3 View

The view is used for recommending skills to users. The view excludes skills that a user already have. This view counts the number of time each skill is used by the jobs that each user prefers. A user prefers a job when there is a matching preference for the job category or JobJobTitles.