HierarchicalJobCategories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
HierarchicalJobCategoryFreeRecommendedTalentCount.hierarchicalJobCategoryId HierarchicalJobCategoryFreeRecom_hierarchicalJobCategoryId_fkey C
CandidateJobCategoryPreferences.hierarchicalJobCategoryId CandidateJobCategoryPreferences_hierarchicalJobCategoryId_fkey C
CandidatePreferredJobCategories.hierarchicalJobCategoryId CandidatePreferredJobCategories_hierarchicalJobCategoryId_fkey C
CandidateWorkExperiences.hierarchicalJobCategoryId CandidateWorkExperiences_hierarchicalJobCategoryId_fkey N
CandidateWorkExperiences.inferredHJCId fk_inferredhjcid N
InferredCandidateWorkExperiences.hierarchicalJobCategoryId InferredCandidateWorkExperiences_hierarchicalJobCategoryId_fkey N
InferredJobRoles.hierarchicalJobCategoryId InferredJobRoles_hierarchicalJobCategoryId_fkey N
SeoCustomSlugPageJobCategories.hierarchical_job_category_id SeoCustomSlugPageJobCategorie_hierarchical_job_category_id_fkey N
SeoCustomSlugPageJobSubCategories.job_sub_category_id SeoCustomSlugPageJobSubCategories_job_sub_category_id_fkey R
SeoCustomSlugPageJobTitles.hierarchical_job_category_id SeoCustomSlugPageJobTitles_hierarchical_job_category_id_fkey N
SeoJobCategoryMetadatas.hierarchical_job_category_id SeoJobCategoryMetadatas_hierarchical_job_category_id_fkey N
SeoJobCategoryTextualContents.hierarchical_job_category_id SeoJobCategoryTextualContents_hierarchical_job_category_id_fkey N
ApplicationFormConfigByJobCategories.HierarchicalJobCategoryId ApplicationFormConfigByJobCatego_HierarchicalJobCategoryId_fkey R
HierarchicalJobCategory_MPTT.id HierarchicalJobCategory_MPTT_id_fkey R
JobCategories.HierarchicalJobCategoryId JobCategories_HierarchicalJobCategoryId_fkey R
JobDrafts.HierarchicalJobCategoryId JobDrafts_HierarchicalJobCategoryId_fkey N
JobFeaturesMaximum.hierarchicalJobCategoryId JobFeaturesMaximum_hierarchicalJobCategoryId_fkey C
JobRolePreferences.HierarchicalJobCategoryId JobRolePreferences_HierarchicalJobCategoryId_fkey N
JobRoleSkills.JobRoleId JobRoleSkills_JobRoleId_fkey C
Jobs.HierarchicalJobCategoryId Jobs_HierarchicalJobCategoryId_fkey N
JobTitleHierarchicalJobCategoryMappings.HierarchicalJobCategoryId JobTitleHierarchicalJobCategoryMappings_HierarchicalJobCategory C
JobTitles.HierarchicalJobCategoryId JobTitles_HierarchicalJobCategoryId_fkey R
LegacyJobCategoryMappings.HierarchicalJobCategoryId LegacyJobCategoryMappings_HierarchicalJobCategoryId_fkey R
SourcedJobs.HierarchicalJobCategoryId SourcedJobs_HierarchicalJobCategoryId_fkey R
SuggestedJobValuesByCategory.hierarchicalJobCategoryId SuggestedJobValuesByCategory_hierarchicalJobCategoryId_fkey C
SuggestedSalaries.hierarchicalJobCategoryId SuggestedSalaries_hierarchicalJobCategoryId_fkey C
JobOrderJobTitles.hierarchicalJobCategoryId JobOrderJobTitles_hierarchicalJobCategoryId_fkey C
translationKey varchar 255 √ null
defaultName varchar 255 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
slug varchar 255 √ NULL::character varying

Slug for the job category
isActive bool 1 true

Indexes

Constraint Name Type Sort Column(s)
HierarchicalJobCategories_pkey Primary key Asc id
HierarchicalJobCategories_defaultName_fts_idx Performance
public_HierarchicalJobCategories_slug_idx Performance Asc slug

Relationships

Close relationships within degrees of separation