Constraints

29 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
MaterialLog_userId_fkey
MaterialLog.userId
User.id
Cascade on delete
AccomplishmentPortfolioStatus_userId_fkey
AccomplishmentPortfolioStatus.userId
User.id
Restrict delete
UserEligibility_userId_fkey1
UserEligibility.userId
User.id
Restrict delete
UserEligibility_jobId_fkey
UserEligibility.jobId
User.id
Restrict delete
UserEligibility_userId_fkey2
UserEligibility.userId
User.id
Restrict delete
UserEligibility_userId_fkey3
UserEligibility.userId
User.id
Restrict delete
UserEligibility_userId_fkey
UserEligibility.userId
User.id
Cascade on delete
UserEligibility_userId_fkey4
UserEligibility.userId
User.id
Restrict delete
UserEligibility_eligibilityId_fkey
UserEligibility.eligibilityId
Eligibility.id
Cascade on delete
UserEligibility_jobId_fkey3
UserEligibility.jobId
Jobs.id
Restrict delete
UserEligibility_userId_fkey5
UserEligibility.userId
User.id
Restrict delete
UserEligibility_jobId_fkey1
UserEligibility.jobId
User.id
Restrict delete
UserEligibility_jobId_fkey2
UserEligibility.jobId
User.id
Restrict delete
Log_organizationId_fkey
Log.organizationId
Organization.id
Restrict delete
Announcement_createdBy_fkey
Announcement.createdBy
User.id
Restrict delete
Announcement_organizationId_fkey
Announcement.organizationId
Organization.id
Restrict delete
Accomplishment_userId_fkey
Accomplishment.userId
User.id
Restrict delete
JobConfig_jobId_fkey
JobConfig.jobId
Jobs.id
Cascade on delete
fk_jobviews_job_id
JobViews.job_id
Jobs.uuid
Cascade on delete
fk_jobviews_userId
JobViews.userId
User.uuid
Cascade on delete
Jobs_company_id_fkey
Jobs.company_id
Companies.id
Cascade on delete
Teammember_company_id_fkey
Teammember.company_id
Companies.id
Cascade on delete
InterviewRounds_job_id_fkey
InterviewRounds.job_id
Jobs.id
Cascade on delete
Eligibility_jobId_fkey
Eligibility.jobId
Jobs.id
Cascade on delete
fk_applications_job_id
Applications.job_id
Jobs.id
Cascade on delete
UserRound_job_id_fkey
UserRound.job_id
Jobs.id
Cascade on delete
UserRound_userId_fkey
UserRound.userId
User.id
Cascade on delete
UserRound_round_id_fkey
UserRound.round_id
InterviewRounds.id
Cascade on delete
User_organizationId_fkey
User.organizationId
Organization.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint