Recommendations


Description

Talent recommendations to TalentHunt jobs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
RecommendationRejectionReasons.RejectionRecommendationId RecommendationRejectionReasons_RejectionRecommendationId R
RecommendationStatusLogs.RecommendationId RecommendationStatusLogs_RecommendationId_fkey R

Primary Key.
status enum_Recommendations_status 2147483647 'PENDING'::"enum_Recommendations_status"

Status of recommendation, as decided by TalentHunt employer (ie. REJECTED, PENDING, ACCEPTED).
note text 2147483647 √ null

Recruiter’s note to company.
JobId uuid 2147483647 √ null
Jobs.id Recommendations_JobId_fkey C

Foreign Key to Job Table.
CandidateId uuid 2147483647 √ null
Users.id Recommendations_CandidateId_fkey C

Foreign Key to User Table, relating to candidate being recommended.
CreatorId uuid 2147483647 √ null
Users.id Recommendations_CreatorId_fkey C

Foreign Key to User Table, relating to recruiter who made the recommendation.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
responseMedium enum_Recommendations_responseMedium 2147483647 √ null
isMadeByAI bool 1 false
relevancePercentage int4 10 √ 0

Indexes

Constraint Name Type Sort Column(s)
Recommendations_pkey Primary key Asc id
Recommendations_CandidateId_idx Performance Asc CandidateId
Recommendations_CreatorId_idx Performance Asc CreatorId
Recommendations_JobId_CandidateId_key Must be unique Asc/Asc JobId + CandidateId
Recommendations_JobId_idx Performance Asc JobId

Relationships

Close relationships within degrees of separation