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