Candidacies


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
CandidacyComments.candidacyId CandidacyComments_candidacyId_fkey R
CandidacyHandovereds.candidacyId CandidacyHandovereds_candidacyId_fkey C
CandidacyHireds.candidacyId CandidacyHireds_candidacyId_fkey C
CandidacyOffereds.candidacyId CandidacyOffereds_candidacyId_fkey C
CandidacyRecommendeds.candidacyId CandidacyRecommendeds_candidacyId_fkey C
CandidacySelectionScheduledFinals.candidacyId CandidacySelectionScheduledFinals_candidacyId_fkey C
CandidacySelectionScheduleds.candidacyId CandidacySelectionScheduleds_candidacyId_fkey C
CandidacySourceds.candidacyId CandidacySourceds_candidacyId_fkey C
CandidacyUnsuiteds.candidacyId CandidacyUnsuiteds_candidacyId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
mergedTalentProfileId uuid 2147483647 null
MergedTalentProfiles.id Candidacies_mergedTalentProfileId_fkey R
recruiterId uuid 2147483647 null
Recruiters.id Candidacies_recruiterId_fkey R
jobOrderId uuid 2147483647 null
JobOrders.id Candidacies_jobOrderId_fkey C
inboundApplicationId uuid 2147483647 √ null
InboundApplications.id Candidacies_inboundApplicationId_fkey C

Indexes

Constraint Name Type Sort Column(s)
Candidacies_pkey Primary key Asc id
Candidacies_inboundApplicationId_key Must be unique Asc inboundApplicationId
Candidacies_jobOrderId_idx Performance Asc jobOrderId
Candidacies_mergedTalentProfileId_idx Performance Asc mergedTalentProfileId
Candidacies_mergedTalentProfileId_jobOrderId_key Must be unique Asc/Asc mergedTalentProfileId + jobOrderId
Candidacies_recruiterId_idx Performance Asc recruiterId
superpowered_Candidacies_createdAt_idx Performance Asc createdAt
superpowered_Candidacies_inboundApplicationId_idx Performance Asc inboundApplicationId

Relationships

Close relationships within degrees of separation