Database Properties
Database Type: PostgreSQL - 14.15 (Ubuntu 14.15-1.pgdg22.04+1)
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| CandidacyUnsuiteds | 1 | 2 | 6 | Table | |
| HubspotJobOrders | 1 | 1 | 28 | Table | |
| Candidacies | 9 | 4 | 7 | Table | |
| HubspotCompanyDeals | 0 | 2 | 4 | Table | |
| RecruiterSavedTalentCollectionTalents | 0 | 2 | 4 | Table | |
| JobOrderBenefits | 0 | 1 | 6 | Table | |
| JobOrderChangeLogs | 0 | 2 | 6 | Table | This table contains changelog of their respective jobOrder tables. |
| CandidacyHireds | 0 | 2 | 6 | Table | |
| SupersourceRejecteds | 1 | 3 | 7 | Table | |
| ReportingGroups | 1 | 1 | 5 | Table | This table consists of Groups. The groups are formed for other teams to report to a certain person. |
| InboundMarketplaceApplications | 0 | 1 | 4 | Table | This table contains details of inbound marketplace applications. |
| RecruiterSavedTalentStatusLogs | 1 | 2 | 6 | Table | |
| SupersourceSaveds | 0 | 3 | 7 | Table | |
| UserJobOrderSearchConditions | 0 | 1 | 4 | Table | Saves the user job search condition which has keyword and filters |
| HubspotTickets | 2 | 0 | 5 | Table | |
| JobOrderContacts | 0 | 1 | 7 | Table | |
| JobOrderCloseds | 1 | 2 | 5 | Table | This table stores the details of which a job is closed |
| InternalMessagingPlatformUsers | 0 | 1 | 5 | Table | Store internal user messaging platform data such as Slack IDs for Slack |
| CandidacyRecommendeds | 0 | 2 | 6 | Table | |
| BusinessUnitRecruiters | 1 | 1 | 6 | Table | Table that contains recruiters of a BusinessUnit |
| CandidacySelectionHappeneds | 0 | 2 | 7 | Table | |
| JobOrderCities | 0 | 3 | 6 | Table | |
| Recruiters | 56 | 3 | 14 | Table | |
| JobOrderAssignmentTags | 0 | 2 | 4 | Table | |
| JobOrderFiles | 0 | 3 | 9 | Table | |
| CandidacyHandovereds | 0 | 2 | 6 | Table | |
| JobOrderForecastReview | 1 | 3 | 8 | Table | |
| JobOrderClosedReasons | 0 | 1 | 6 | Table | |
| JobOrderSkills | 0 | 2 | 5 | Table | |
| JobOrders | 26 | 12 | 55 | Table | |
| SupersourceRejectedReasons | 0 | 1 | 6 | Table | |
| HubspotJobOrderEventLogs | 0 | 0 | 16 | Table | |
| HubspotDeals | 4 | 1 | 6 | Table | |
| Teams | 3 | 1 | 5 | Table | |
| TeamReportingGroups | 0 | 2 | 4 | Table | Join table of Teams and ReportingGroups |
| JobOrderMarketplaceListings | 0 | 1 | 6 | Table | This table contains jobs that have to be published to marketplace along with configs. |
| TeamRecruiters | 1 | 1 | 6 | Table | This table store the team information of a recruiter. |
| HubspotCompanies | 1 | 0 | 5 | Table | This table is synchronized with companies of HubSpot CRM using HubspotCompanyTask |
| HubspotDealStages | 1 | 0 | 4 | Table | |
| JobOrderLanguages | 0 | 2 | 4 | Table | |
| JobOrderPrioritizedReasons | 0 | 1 | 6 | Table | |
| RecruiterSavedTalents | 2 | 3 | 6 | Table | |
| CandidacySelectionScheduleds | 2 | 2 | 8 | Table | |
| CandidacySelectionScheduledFinals | 0 | 2 | 5 | Table | |
| CandidacyUnsuitedReasons | 0 | 1 | 5 | Table | |
| BusinessUnits | 2 | 0 | 5 | Table | |
| HubspotTicketDeals | 0 | 2 | 4 | Table | |
| JobOrderJobTitles | 0 | 3 | 6 | Table | |
| CandidacySourceds | 0 | 2 | 8 | Table | |
| InboundApplications | 2 | 2 | 6 | Table | This table contains talent profile ids that apply to a job. |
| RecruiterSavedTalentCollections | 1 | 1 | 6 | Table | |
| JobOrderReopeneds | 0 | 2 | 6 | Table | |
| JobOrderDeprioritizeds | 1 | 2 | 5 | Table | This table stores the details of which a job is deprioritized |
| JobOrderIndustryPreferences | 0 | 2 | 5 | Table | |
| JobOrderPrioritizeds | 1 | 2 | 5 | Table | This table stores the details of which a job is prioritized |
| CandidacyOffereds | 0 | 2 | 6 | Table | |
| CandidacyComments | 0 | 2 | 6 | Table | |
| JobOrderDeprioritizedReasons | 0 | 1 | 6 | Table | |
| JobOrderForecast | 0 | 3 | 9 | Table |