Tables


SchemaSpy Analysis of glints.public

Generated on Sat Dec 27 20:04 GMT 2025

XML Representation
Insertion Order Deletion Order
TABLES 347
VIEWS 12
COLUMNS 2755
Constraints 554
Anomalies 5
Routines 1170

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
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 9 Table

Draft for JobSalary.
Experiences 2 4 18 Table

Work and Education experience of User.
OdysseyUserRewards 0 2 3 Table
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 4 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.
ExpertClassApplicationRejectionReasonOptions 1 0 5 Table
HierarchicalJobCategories 27 0 7 Table
PopularJobSearchesCache 0 0 3 Table
UserMessagingTemplateMessages 0 1 5 Table

Users’ custom messaging templates.
UserWhatsappLoginVerificationRecords 0 0 8 Table
ExpertClassCategories 5 0 5 Table
CompanyFeaturesMaximum 0 4 10 Table
Countries 37 0 9 Table

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

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

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

Merged talent profiles.
Preferences 0 2 17 Table

Job Preferences of User.
CompanyCollectionItems 0 2 6 Table
OdysseyMaxApplicationsNotifications 0 1 2 Table
SystemPredictionLogs 1 1 6 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 2 3 10 Table
UserShares 0 2 3 Table
XenditCustomerInformation 0 1 5 Table
SuggestedSalaries 0 3 7 Table
XenditInvoiceCallbackLogs 0 0 8 Table
Schools 3 1 10 Table

Schools
OdysseyBadgeNotifications 0 3 3 Table
DigitalFootprintBlacklistedKeywords 0 0 4 Table
ExpertIndonesianNPWPCardDetails 0 1 5 Table
HoustonRoleBindings 0 2 5 Table
VerificationWhitelistedEmailDomains 0 1 5 Table

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

Talent recommendations to TalentHunt jobs.
Messages 0 0 11 Table

Log of Emails Sent from Employers to Candidates.
Bookmarks 0 5 9 Table

Candidates’ bookmarks of jobs and companies, and Companies’ bookmarks of candidates.
OdysseyBadges 3 0 4 Table
Companies 68 7 48 Table

Company Information.
HoustonCreateCompanyActionLogs 0 2 2 Table
HoustonJobQualityIssueActionLogs 0 2 4 Table
FeatureLifetimeCount 0 0 7 Table
UserCompanyRoleLogs 0 2 7 Table
ExpertClassInAppPrices 0 1 6 Table

Saves ExpertClass in-app products prices and currency to be used in Google play and App Stores
LiveRoomShares 0 2 3 Table
Users_cdc_test 0 6 51 Table
OdysseyTargets 1 0 5 Table
LiveRoomHosts 0 2 3 Table
ApplicationQuestionAnswers 0 2 7 Table
ExpertClassTicketTypePriceOptions 0 0 6 Table

Stores the options for possible expert class ticket price. This table is not linked to ExpertClassTicketType but is used to validate the price before adding an entry in ExpertClassTicketType table.
JobNotificationReceiverDrafts 0 2 5 Table
ExpertFinancialDetails 1 1 5 Table
NormalizedSkillsMapping 0 2 5 Table
CompaniesPageConfigs 2 1 6 Table
SourcedCompanies 1 2 10 Table
JobFeaturesMaximum 0 6 12 Table
XenditPaymentWebhookLogs 0 1 5 Table
Jobs 42 10 50 Table

Job Posting.
ApplicationStatusNotifications 0 2 2 Table
PointOfInterests 1 1 10 Table
ApplicationStatusLogs 3 2 8 Table
ExpertClassApplicationClassCategories 0 2 4 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.
ApplicationRejectionReasons 0 1 4 Table
JobDrafts 7 10 42 Table

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

Jobs in groups.
Industries 5 0 5 Table

Industry Information
PotentialLeadDigitalFootprintVerificationCriteria 1 0 4 Table
ExpertApplicationStatusNotifications 0 2 5 Table
MTSeatDeactivations 1 2 11 Table
CitySubDivisions 4 1 5 Table
FailedModerationLogs 0 1 6 Table
OdysseyTargetPreferences 0 2 4 Table
JobFraudAnalysisRecords 0 2 7 Table
SchoolEducationLevels 0 1 3 Table
ExpertApplicationWorkExperiences 0 2 7 Table
NormalizedSkills 4 0 4 Table
ExpertiseTopics 1 0 5 Table
JobDraftScreeningQuestionCustomPlainTexts 0 1 6 Table
XenditPaymentRequestCallbackLogs 0 0 9 Table
ApplicationScreeningAnswerDocumentAndCertificates 0 2 3 Table
HoustonOutboundUpsellCompanyActionLogs 0 3 4 Table
ExpertClassPromotionCodeEmails 0 1 4 Table
HoustonRolePermissions 0 1 4 Table
ExpertClassCategoryJobCategoryMappings 0 2 4 Table

This table is used to map the ExpertClass category to the job category
Referrals 1 0 7 Table
RevenueCatWebhookLogs 0 1 11 Table
ExpertClassPromotionCodePlatformRestrictions 0 1 5 Table
ChatAutoInvitations 2 2 8 Table
CompanyStatusLog 0 2 7 Table
ExpertClassApplicationKeyLearnings 0 1 5 Table
Timezones 1 0 3 Table
ExpertClassClassTypeExpertClassPromotionCodes 0 2 2 Table
TalentHuntCandidateApplications 1 1 5 Table
Referees 1 1 8 Table
ExpertClassTicketTypes 2 1 10 Table
Campaigns 0 1 12 Table
ExpertClassCategoryExpertClassPromotionCodes 0 2 2 Table
Studies 1 0 6 Table

Names of Study.
JobSalaries 0 2 9 Table

Job Salary.
OdysseyBadgeRewards 0 2 4 Table
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 0 6 Table

Category for each type of notification preference.
Applications 7 3 20 Table

Job Application.
ExpertClassOrderTicketWebinars 0 1 4 Table

Webinar data for the ExpertClassOrderTicket.
OdysseyRewards 4 1 2 Table
ReferralApplications 0 4 8 Table
ApplicationScreeningAnswerSkills 0 2 3 Table
ExpertClassCertificateGeneratedNotifications 0 2 2 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
ExpertClassTicketTypePriceRangeOptions 0 0 6 Table

Stores the options for possible expert class ticket price ranges. This table is just meant for showing the prices ranges on the expert class creation form
ExpertClassApplicationTargetAudiences 0 1 5 Table
HoustonActionLogs 8 1 4 Table
UserTokens 0 1 8 Table
HoustonSwallowUserActionLogs 0 2 2 Table
SpecialLocations 0 2 8 Table
ExpertClassGoogleVoidedPurchases 0 0 8 Table
MTSeatDeactivations_MTSeatDeactivationReasons 0 2 3 Table
BlackListedWords 1 1 6 Table
LocationWageGuidance 0 2 8 Table
RecommendationStatusLogs 1 2 8 Table
marketplace_mobile_app 0 0 6 Table
CompanyVerificationRequests 2 4 15 Table
StreakPointSources 0 1 3 Table

Odyssey points for application streaks
OdysseyProfileCompletionNotifications 0 2 2 Table
EmployerVerifications 0 2 12 Table
FollowingNewFollowerNotifications 0 2 2 Table
JobShares 0 2 3 Table
ExpertClassExpertClassWhatYouGetOptions 0 2 4 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.
TalentHuntJobApplicationStatusLogs 0 3 11 Table
ExpertClassBanners 0 0 15 Table

ExpertClass Banner images displayed on the frontend in the form of a carousel.
ShareVisitors 0 2 6 Table
JobScreeningQuestionIndustries 0 2 2 Table
PotentialLeads 4 4 21 Table
EmployerActivityExperimentJobs 0 1 5 Table
LiveRoomTopics 1 0 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
ExpertClassApplicationSelectedRejectionReasons 0 2 5 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.
ExpertApplicationRejectionReasons 1 0 5 Table
ExpertClassApplicationOtherRejectionReasons 0 1 5 Table
UserCompaniesOpsTeamDataBackup 0 2 6 Table
ExpertClassClassTypes 2 0 5 Table

Types of expert classes.
ExpertClassReminderNotifications 0 2 5 Table
ExternalTalentProfileCakeResumeUsers 0 1 4 Table

Merged talent profiles join table with CakeResume Users.
CompanyDeletionRequests 0 2 8 Table
ExpertTaxDetails 1 1 5 Table
CompaniesPageCollections 0 2 6 Table
JobBoostingTasks 0 3 17 Table
JobDraftScreeningQuestionLanguages 0 2 2 Table
PotentialLeadStatusChangeLogs 0 2 8 Table
ScheduledPushNotificationTranslations 0 1 7 Table
MTSeatActivations 2 3 21 Table
BannedLiveRoomUsers 0 2 3 Table
Users 193 6 51 Table

User Information.
ExpertApplications 3 2 9 Table

Records in this table are not meant to be deleted. A rule has been added to avoid records to be deleted
HoustonFlagJobActionLogs 0 1 4 Table
ApplicationScreeningAnswerCustomPlainTexts 0 2 5 Table
ApplicationScreeningAnswerLanguages 0 2 3 Table
JobTitleHierarchicalJobCategoryMappings 0 1 6 Table
NormalizedBenefits 1 2 8 Table
ApplicationScreeningAnswers 5 1 9 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 3 1 5 Table

Odyssey points for users
OdysseyWeeklyTargetNotifications 0 3 4 Table
ExpertClassWhatYouGetOptions 1 0 5 Table
EmployerCustomMessages 0 2 10 Table
LocationLegacyMappings 0 4 5 Table

contains mapping from new location to legacy location
SearchConditionEmails 0 0 7 Table
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.
GooglePlayPaymentWebhookLogs 0 0 8 Table
DocumentAndCertificates 3 0 4 Table
Notifications 31 1 7 Table
GeneralConfigs 0 0 4 Table
SystemPredictionResolutions 0 3 7 Table
ExpertClassPromotionPercentOffOptions 0 0 4 Table

Stores the possible discount percentage values for ExpertClass promotion codes. This table is used for validating the percentOff of the promo code before creating entries in ExpertClassPromotionCodes table.
FraudCaseFileLogs 0 2 10 Table
JobScreeningQuestionDocumentAndCertificates 0 2 2 Table
JobSalarySuggestions 0 0 5 Table
ExpertClassCertificateTokens 0 2 7 Table
ExpertApplicationAdditionalInformation 1 0 7 Table
ExternalTalentProfileWebScrapedUsers 0 1 4 Table
ExpertClassPromotionCodeActionLogs 0 2 5 Table

A log recording certain actions performed on an ExpertClassPromotionCode that are important for business users to keep track of.
Languages 8 0 6 Table
LocationAdministrativeLevels 1 0 7 Table
ExpertClassOrderTickets 1 2 5 Table
PushNotifications 0 2 10 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 26 1 11 Table
UnifiedCompanies 3 0 3 Table

Stores unified company IDs.
Events 1 0 5 Table
ExpertClassActionLogs 0 1 7 Table
ExpertClasses 13 3 22 Table

Career Building Events Offered to Candidates.
UserSignupTrackings 0 1 2 Table
ExpertIndonesianFinancialDetails 0 1 6 Table
FraudVerificationLists 0 2 10 Table

Fraud verification blacklist and watchlist entries for company verification
EventRegistrations 0 2 5 Table
ExpertClassApplicationPromotions 0 1 6 Table
ExpertClassPromotionCodes 8 0 15 Table

A customer-redeemable promotion code for an Expert Class.
SalaryEstimates 0 3 9 Table
ExpertClassShares 0 2 3 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
Currencies 13 0 9 Table

Currency.
Organizations 0 5 19 Table
Orders 4 2 9 Table
ExpertClassApplications 8 3 17 Table
JobSkills 1 2 6 Table

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

Profile Completion Score of entity.
ExpertClassCertificates 1 2 7 Table
ExternalTalentProfileLinkedInUsers 0 1 4 Table

Merged talent profiles join table with LinkedIn Users.
CandidateExperiences 0 1 7 Table
FeatureDailyCount 0 0 7 Table
ExpertClassZoomPlatforms 0 1 7 Table

Platform specific data that relates to an ExpertClassPlatform.
JobCategories 11 1 9 Table

Job Category.
HoustonTransferCompanyActionLogs 0 4 7 Table
UserMessagingResponseStatistics 0 1 6 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
ExpertClassClassCategories 0 2 4 Table
ExpertClassApplicationCSVExportRequests 0 1 9 Table
Skills 13 0 9 Table

Skills.
UserDeletionRequests 1 0 9 Table
ExpertClassExpertClassPromotionCodes 0 2 2 Table
Experts 4 1 5 Table

Records in this table are not meant to be deleted. A rule has been added to avoid records to be deleted
IndustriesV2 2 0 4 Table
EmailLogs 0 1 7 Table
ExpertClassPromotionMaxAmountDiscountOptions 0 0 5 Table

Stores the possible max amount discount values for ExpertClass promotion codes. This table is used for validating the maxAmountDiscount of the promo code before creating entries in ExpertClassPromotionCodes table.
ScheduledPushNotificationRecipients 0 2 5 Table
ExpertClassLanguages 2 0 6 Table
BlocklistedDomains 0 0 4 Table
TalentHuntJobApplications 1 6 11 Table
ActionLogs 0 0 10 Table

Logs of all API requests.
HoustonJobImports 0 1 38 Table
ExpertApplicationOtherRejectionReasons 0 1 5 Table
UserJobSearchConditions 0 1 4 Table
RecommendationRejectionReasons 0 2 7 Table
ExpertContacts 0 1 6 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.
ExpertClassPlatforms 1 1 4 Table

Join table for an ExpertClass and an ExpertClass platform.
Shares 11 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
ExpertClassSpeakers 0 2 3 Table
Location_MPTT 1 2 7 Table
SuggestedJobValuesByCategory 0 2 7 Table

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

Odyssey points for creating an application or getting shortlisted
CompanyAddresses 2 4 9 Table
ExpertClassInAppProducts 2 0 6 Table

Saves ExpertClass in-app products information to be used in Google play and App Stores
MobileAppVersions 0 2 13 Table
ApplicationFormConfigByJobCategories 0 7 20 Table
JobTitles 8 2 7 Table

Job Titles - a level below Job Categories.
ExpertClassApplicationExpertiseTopics 0 2 4 Table
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 10 Table
LiveRoomReminders 0 2 3 Table
ProfileCompletionPoints 0 0 5 Table
UserCompanyLogs 0 3 7 Table
MTSeatDeactivationReasons 1 0 7 Table
ExpertClassGoogleInAppPayments 0 3 9 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
AfterOrderPaidNotifications 0 2 4 Table
ExpertClassTicketPrices 0 1 6 Table
JobBenefitDrafts 0 1 6 Table
HoustonReactivateCompanyActionLogs 0 2 2 Table
ApiClients 0 1 9 Table

Clients that consume our API.
FraudCaseFiles 2 1 7 Table
NoRecentApplicationStatusNotifications 0 1 2 Table
LinkedInPartnershipFieldMaps 0 0 6 Table
geography_columns 0 1 7 View
FraudCaseFilesWithCountsView 0 0 10 View
OmnisearchJobApplications 0 1 13 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 1 7 View
pg_stat_kcache_detail 0 0 32 View
pg_stat_statements_info 0 0 2 View
TalentHuntActivityLogs 0 1 15 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.