JobTitles


Description

Job Titles - a level below Job Categories.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"JobTitles_id_seq"'::regclass)
SeoCustomSlugPageJobTitles.job_title_id SeoCustomSlugPageJobTitles_job_title_id_fkey R
JobJobTitleDrafts.JobTitleId JobJobTitleDrafts_JobTitleId_fkey C
JobJobTitles.JobTitleId JobJobTitles_JobTitleId_fkey C
JobRolePreferences.JobTitleId JobRolePreferences_JobTitleId_fkey C
JobTitleSkills.JobTitleId JobTitleSkills_JobTitleId_fkey C
LegacyJobCategoryMappings.LegacyJobTitleId LegacyJobCategoryMappings_LegacyJobTitleId_fkey R
SalaryEstimates.JobTitleId SalaryEstimates_JobTitleId_fkey C
JobOrderJobTitles.jobTitleId JobOrderJobTitles_jobTitleId_fkey C

Primary Key.
name varchar 255 √ null

Name of job title.
bannerPic varchar 255 √ null

File name linking to their resumes in s3 bucket glints-dashboard/job-title-banner-pic.
JobCategoryId int4 10 √ null
JobCategories.id JobTitles_JobCategoryId_fkey C

Foreign Key to JobCategory Table.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
HierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id JobTitles_HierarchicalJobCategoryId_fkey R

Indexes

Constraint Name Type Sort Column(s)
JobTitles_pkey Primary key Asc id
JobTitles_HierarchicalJobCategoryId_idx Performance Asc HierarchicalJobCategoryId
JobTitles_name_trgm_idx Performance Asc name

Relationships

Close relationships within degrees of separation