UnifiedTalentProfiles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidateId uuid 2147483647 null
Candidates.id UnifiedTalentProfiles_candidateId_fkey C
mergedTalentProfileId uuid 2147483647 null
MergedTalentProfiles.id UnifiedTalentProfiles_mergedTalentProfileId_fkey C
userId uuid 2147483647 √ null
Users.id UnifiedTalentProfiles_userId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
UnifiedTalentProfiles_pkey Primary key Asc id
UnifiedTalentProfiles_candidateId_mergedTalentProfileId_key Must be unique Asc/Asc candidateId + mergedTalentProfileId
UnifiedTalentProfiles_mergedTalentProfileId_idx Performance Asc mergedTalentProfileId

Relationships

Close relationships within degrees of separation