JobDrafts


Description

Job Posting Draft.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
PointsTopUpOrderRelatedJobDrafts.jobDraftId PointsTopUpOrderRelatedJobDraft_jobDraftId_fkey N
JobBenefitDrafts.JobDraftId JobBenefitDrafts_JobDraftId_fkey C
JobDraftScreeningQuestions.jobDraftId JobDraftScreeningQuestions_jobDraftId_fkey C
JobJobTitleDrafts.JobDraftId JobJobTitleDrafts_JobDraftId_fkey C
JobNotificationReceiverDrafts.JobDraftId JobNotificationReceiverDrafts_JobDraftId_fkey C
JobPreferredKeywordDrafts.jobDraftId JobPreferredKeywordDrafts_jobDraftId_fkey C
JobSalaryDrafts.JobDraftId JobSalaryDrafts_JobDraftId_fkey C
JobSkillDrafts.JobDraftId JobSkillDrafts_JobDraftId_fkey C

Primary Key.
title varchar 255 √ null

Job Title.
status enum_JobDrafts_status 2147483647 √ null

Status of the job posting the draft relates to (ie. OPEN, CLOSED).
bannerPic varchar 255 √ null

File name linking to their resumes in s3 bucket glints-dashboard/job-banner-pic.
type enum_JobDrafts_type 2147483647 √ null

Type of job (ie. FULL_TIME, INTERNSHIP …).
attachments jsonb 2147483647 '[]'::jsonb

File name of attachment files, in s3 glints-dashboard/job-attachment.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
CreatorId uuid 2147483647 null
Users.id JobDrafts_CreatorId_fkey N

Id of user who created the job draft. Foreign Key References Users.
CompanyId uuid 2147483647 null
Companies.id JobDrafts_CompanyId_fkey R

Foreign Key to Company Table.
numberOfHires int4 10 1

Number of Hires for this job posting.
JobCategoryId int4 10 √ null
JobCategories.id JobDrafts_JobCategoryId_fkey N

Foreign Key to JobCategory Table.
isRemote bool 1 false

Boolean indicating whether a job is remote.
descriptionRaw jsonb 2147483647 √ null

Description of the job, in a JSON object format, to work with DraftJS.
CityId int4 10 √ null
Cities.id JobDrafts_CityId_fkey N

Foreign Key to Cities Table.
CountryCode varchar 255 √ null
Countries.code JobDrafts_CountryCode_fkey N

Country Code of country that this job is in. Foreign Key References Countries
minYearsOfExperience int4 10 √ null
maxYearsOfExperience int4 10 √ null
startDate date 13 √ null
endDate date 13 √ null
acceptsForeignApplications bool 1 false

Boolean indicating whether a job accepts foreign applications.
CitySubDivisionId int4 10 √ null
CitySubDivisions.id JobDrafts_CitySubDivisionId_fkey R
isCoverLetterMandatory bool 1 false
shouldPublishOnLinkedin bool 1 false

Consent given by a company user to post their job on Linkedin.
shouldShowBenefits bool 1 true

Consent given by a company user to show job benefits to candidates.
interviewProcessRaw jsonb 2147483647 √ null

Interview process of the job, in a JSON object format, to work with DraftJS.
shouldShowSalary bool 1 true

Boolean indicating if employer wants to show the job salary or not.
HierarchicalJobCategoryId uuid 2147483647 √ null
HierarchicalJobCategories.id JobDrafts_HierarchicalJobCategoryId_fkey N

Foreign Key to Hierarchical Job Category Table. Only level 3 hierarchical job category is allowed.
DistrictId uuid 2147483647 √ null
Locations.id JobDrafts_DistrictId_fkey N

Foreign Key to Location Table. Only District level key is allowed.
educationLevel enum_EducationLevel_type 2147483647 √ null

Education level required for the job
EmployerServiceRepId uuid 2147483647 √ null
Users.id JobDrafts_EmployerServiceRepId_fkey N
minAge int2 5 √ null
maxAge int2 5 √ null
gender enum_Users_gender 2147483647 √ null

Gender preferred for the job
isLocationRequiredForCandidate bool 1 √ null

Boolean indicating if candidate location is required.
isEducationRequiredForCandidate bool 1 √ null

Boolean indicating if candidate education is required.
workArrangementOption enum_public_Jobs_workArrangementOption 2147483647 'ONSITE'::"enum_public_Jobs_workArrangementOption"

Work arrangement option for the job
isResumeRequiredForCandidate bool 1 √ null

Boolean indicating if candidate resume is required.
screeningQuestionsEnabled bool 1 false

Boolean indicates if screening question is enabled or not
vipCandidateInformation jsonb 2147483647 √ null

Contains a list of candidate information. Only if the job is from a VIP company
externalApplyURL text 2147483647 √ null
CompanyAddressId uuid 2147483647 √ null
CompanyAddresses.id JobDrafts_CompanyAddressId_fkey N
metadata jsonb 2147483647 √ null

Additional metadata info about the job draft including workshift fields (workShifts, workingDaysPerWeek, requiresWeekendHolidays)

Indexes

Constraint Name Type Sort Column(s)
JobDrafts_pkey Primary key Asc id
JobDrafts_CreatorId_idx Performance Asc CreatorId
JobDrafts_DistrictId_idx Performance Asc DistrictId

Check Constraints

Constraint Name Constraint
JobDrafts_maxAge_check (((("maxAge" IS NOT NULL) AND ("maxAge" >= 0) AND ("maxAge" <= 100)) OR ("maxAge" IS NULL)))
JobDrafts_minAge_check (((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))
minAge_and_maxAge_check (((("minAge" IS NOT NULL) AND ("maxAge" IS NOT NULL) AND ("minAge" < "maxAge")) OR ("minAge" IS NULL) OR ("maxAge" IS NULL)))

Relationships

Close relationships within degrees of separation