JobCategories


Description

Job Category.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"JobCategories_id_seq"'::regclass)
SeoCustomSlugPageJobCategories.job_category_id SeoCustomSlugPageJobCategories_job_category_id_fkey R
SeoJobCategoryMetadatas.job_category_id SeoJobCategoryMetadatas_job_category_id_fkey R
SeoJobCategoryTextualContents.job_category_id SeoJobCategoryTextualContents_job_category_id_fkey R
ExpertClassCategoryJobCategoryMappings.jobCategoryId ExpertClassCategoryJobCategoryMappings_jobCategoryId_fkey C
JobCategorySkills.JobCategoryId JobCategorySkills_JobCategoryId_fkey C
JobDrafts.JobCategoryId JobDrafts_JobCategoryId_fkey N
JobRolePreferences.JobCategoryId JobRolePreferences_JobCategoryId_fkey C
Jobs.JobCategoryId Jobs_JobCategoryId_fkey N
JobTitles.JobCategoryId JobTitles_JobCategoryId_fkey C
LegacyJobCategoryMappings.LegacyJobCategoryId LegacyJobCategoryMappings_LegacyJobCategoryId_fkey R
JobOrders.jobCategoryId JobOrders_jobCategoryId_fkey R

Primary Key.
name varchar 255 √ null

Name of this Job Category.
bannerPic varchar 255 √ null

File name linking to their resumes in s3 bucket glints-dashboard/job-category-banner-pic.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
descriptionHTML text 2147483647 √ null

Description of this job category in HTML.
descriptionMarkdown text 2147483647 √ null

Description of this job category in MarkDown.
sections jsonb 2147483647 √ null
HierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id JobCategories_HierarchicalJobCategoryId_fkey R

Indexes

Constraint Name Type Sort Column(s)
JobCategories_pkey Primary key Asc id
JobCategories_HierarchicalJobCategoryId_idx Performance Asc HierarchicalJobCategoryId

Relationships

Close relationships within degrees of separation