JobOrders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
CandidateNoteJobOrders.jobOrderId CandidateNoteJobOrders_jobOrderId_fkey C
JobOrderCandidates.jobOrderId JobOrderCandidates_jobOrderId_fkey C
TalentConsultantNotifications.jobOrderId TalentConsultantNotifications_jobOrderId_fkey C
Candidacies.jobOrderId Candidacies_jobOrderId_fkey C
InboundApplications.jobOrderId InboundApplications_jobOrderId_fkey C
JobOrderAssignmentTags.jobOrderId JobOrderAssignments_jobOrderId_fkey C
JobOrderBenefits.jobOrderId JobOrderBenefits_jobOrderId_fkey C
JobOrderChangeLogs.jobOrderId JobOrderChangeLogs_jobOrderId_fkey C
JobOrderCities.jobOrderId JobOrderCities_jobOrderId_fkey C
JobOrderCloseds.jobOrderId JobOrderCloseds_jobOrderId_fkey C
JobOrderContacts.jobOrderId JobOrderContacts_jobOrderId_fkey C
JobOrderDeprioritizeds.jobOrderId JobOrderDeprioritizeds_jobOrderId_fkey C
JobOrderFiles.jobOrderId JobOrderFiles_jobOrderId_fkey C
JobOrderForecast.jobOrderId JobOrderForecast_jobOrderId_fkey C
JobOrderForecastReview.jobOrderId JobOrderForecastReview_jobOrderId_fkey C
JobOrderIndustryPreferences.jobOrderId JobOrderIndustryPreferences_jobOrderId_fkey C
JobOrderJobTitles.jobOrderId JobOrderJobTitles_jobOrderId_fkey C
JobOrderLanguages.jobOrderId JobOrderLanguages_jobOrderId_fkey C
JobOrderMarketplaceListings.jobOrderId JobOrderMarketplaceListings_jobOrderId_fkey C
JobOrderPrioritizeds.jobOrderId JobOrderPrioritizeds_jobOrderId_fkey C
JobOrderReopeneds.jobOrderId JobOrders_jobOrderId_fkey C
JobOrders.associatedJobOrderId JobOrders_associatedJobOrderId_fkey N
JobOrderSkills.jobOrderId JobOrderSkills_jobOrderId_fkey C
RecruiterSavedTalentStatusLogs.jobOrderId RecruiterSavedTalentStatusLogs_jobOrderId_fkey C
SupersourceRejecteds.jobOrderId SupersourceRejecteds_jobOrderId_fkey C
SupersourceSaveds.jobOrderId SupersourceSaveds_jobOrderId_fkey C
position text 2147483647 null
isFarmed bool 1 √ null
headcount int4 10 null
isGlintsManagedTalentServiceRequired bool 1 √ null
location "superpowered"."enum_JobOrders_location" 2147483647 √ null
employment "superpowered"."enum_JobOrders_employment" 2147483647 null
probationInMonth int4 10 √ null
description text 2147483647 √ null
mustHaveRequirement text 2147483647 √ null
goodToHaveRequirement text 2147483647 √ null
reportingStructure text 2147483647 √ null
teamSize int4 10 √ null
careerProgression text 2147483647 √ null
hiringProcess text 2147483647 √ null
performanceReviewAndRaise text 2147483647 √ null
note text 2147483647 √ null
expiredAt timestamptz 35,6 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
experiencesInMonth int4range 2147483647 √ null
basicSalariesInMonth int8range 2147483647 √ null
bonusSalariesInYear int8range 2147483647 √ null
currencyId varchar 255 null
Currencies.code JobOrders_currencyId_fkey R
jobCategoryId int4 10 √ null
JobCategories.id JobOrders_jobCategoryId_fkey R
inChargedRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrders_inChargedRecruiterId_fkey R
teamId uuid 2147483647 √ null
Teams.id JobOrders_teamId_fkey R
hubspotDealId text 2147483647 √ null
HubspotDeals.id JobOrders_hubspotDealId_fkey N
hubspotTicketId text 2147483647 √ null
HubspotTickets.id JobOrders_hubspotTicketId_fkey R
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrders_createdByRecruiterId_fkey R

Recruiter id that created the job
recruitmentConsultantId uuid 2147483647 √ null
Recruiters.id JobOrders_recruitmentConsultantId_fkey N
recommendedSourcingSalariesCurrencyId varchar 10 √ null
Currencies.code JobOrders_recommendedSourcingSalariesCurrencyId_fkey R
recommendedSourcingSalariesInMonth int8range 2147483647 √ null
budgetNotes text 2147483647 √ null
contractDurationInMonth int4 10 √ null
lastJobOrderForecastReviewId uuid 2147483647 √ null
JobOrderForecastReview.id JobOrders_lastJobOrderForecastReviewId_fkey N
status "superpowered"."enum_JobOrders_status" 2147483647 'OPEN'::superpowered."enum_JobOrders_status"
latestStatusId uuid 2147483647 √ null
prioritization "superpowered"."enum_JobOrders_prioritization" 2147483647 'PRIORITY'::superpowered."enum_JobOrders_prioritization"
latestPrioritizationId uuid 2147483647 √ null
replacementHire bool 1 √ null
associatedJobOrderId uuid 2147483647 √ null
JobOrders.id JobOrders_associatedJobOrderId_fkey N
managementFee numeric 10,2 √ null
glintsService "superpowered"."enum_Superpowered_Glints_Service" 2147483647 √ null
typeOfPlacementFee "superpowered"."enum_Superpowered_Placement_Fee" 2147483647 √ null
placementPercentageFeeRate numeric 10,2 √ null
readyTalentTakeRatePercentage numeric 10,2 √ null
fixedRate numeric 10,2 √ null
minimumPlacementFee numeric 10,2 √ null
jovMTS numeric 10,2 √ null
totalJovPlacement numeric 10,2 √ null
clientScheduledOnboardingDate date 13 √ null
expectedCandidateJoinDate date 13 √ null
hubspotJobOrderId text 2147483647 √ null
HubspotJobOrders.id fk_hubspot_job_order_id N
typeOfReadyTalentFee "superpowered"."enum_Superpowered_Ready_Talent_Fee_Type" 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
JobOrders_pkey Primary key Asc id
JobOrders_createdAt_idx Performance Asc createdAt
JobOrders_createdByRecruiterId_idx Performance Asc createdByRecruiterId
JobOrders_currencyId_idx Performance Asc currencyId
JobOrders_hubspotDealId_idx Performance Asc hubspotDealId
JobOrders_inChargedRecruiterId_idx Performance Asc inChargedRecruiterId
JobOrders_jobCategoryId_idx Performance Asc jobCategoryId
JobOrders_position_trgm_idx Performance Asc position
JobOrders_teamId_idx Performance Asc teamId

Check Constraints

Constraint Name Constraint
JobOrders_probationInMonth_check (("probationInMonth" <@ '[1,13)'::int4range))
JobOrders_teamSize_check (("teamSize" <@ '[0,101)'::int4range))
JobOrders_headcount_check ((headcount <@ '[1,101)'::int4range))

Relationships

Close relationships within degrees of separation