InboundApplications


Description

This table contains talent profile ids that apply to a job.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
Candidacies.inboundApplicationId Candidacies_inboundApplicationId_fkey C
InboundMarketplaceApplications.inboundApplicationId InboundMarketplaceApplications_inboundApplicationId_fkey C
jobOrderId uuid 2147483647 null
JobOrders.id InboundApplications_jobOrderId_fkey C
mergedTalentProfileId uuid 2147483647 null
MergedTalentProfiles.id InboundApplications_mergedTalentProfileId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
source enum_Applications_source 2147483647 √ null

Tells the source from where the application was submitted

Indexes

Constraint Name Type Sort Column(s)
InboundApplications_pkey Primary key Asc id
InboundApplications_jobOrderId_mergedTalentProfileId_key Must be unique Asc/Asc jobOrderId + mergedTalentProfileId
superpowered_InboundApplications_jobOrderId_idx Performance Asc jobOrderId
superpowered_InboundApplications_mergedTalentProfileId_idx Performance Asc mergedTalentProfileId

Relationships

Close relationships within degrees of separation