Jobs


Description

Job Posting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
JobExtensionOrderItems.jobId JobExtensionOrderItems_jobId_fkey R
JobPostOrderItems.jobId JobPostOrderItems_jobId_fkey R
PointsTopUpOrderRelatedJobDrafts.publishedJobId PointsTopUpOrderRelatedJobDraft_publishedJobId_fkey C
PointsTopUpOrderRelatedJobs.jobId PointsTopUpOrderRelatedJob_jobId_fkey C
CompanyProductInventoryUsageFromBalanceLogs.relatedJobId CompanyProductInventoryUsageFromBalanceLogs_relatedJobId_fkey N
CreditProductPurchaseOrderAfterPurchaseActionLogs.relatedJobId CreditProductPurchaseOrderAfterPurchaseAction_relatedJobId_fkey N
JobBoostRecords.jobId JobBoostRecords_jobId_fkey C
JobProductInventories.jobId JobProductInventories_jobId_fkey C
JobProductInventoryLogs.jobId JobProductInventoryLogs_jobId_fkey C
PurchaseOrderProductAfterPaymentActionLogs.relatedJobId PurchaseOrderProductAfterPaymentActionLogs_relatedJobId_fkey N
ApplicationDrafts.JobId ApplicationDrafts_JobId_fkey R
Applications.JobId Applications_JobId_fkey R
Bookmarks.ForJobId Bookmarks_ForJobId_fkey R
Bookmarks.JobId Bookmarks_JobId_fkey R
ChatAutoInvitations.jobId ChatAutoInvitations_jobId_fkey C
Comments.JobId Comments_JobId_fkey R
DailyMetricsForJobs.JobId DailyMetricsForJobs_JobId_fkey R
EmployerActivityExperimentJobs.JobId EmployerActivityExperimentJobs_JobId_fkey C
FraudUpdateForJobs.jobId FraudUpdateForJobs_jobId_fkey C
GroupJobs.JobId GroupJobs_JobId_fkey R
InterceptedFraudMessages.jobId InterceptedFraudMessages_jobId_fkey N
JobBenefits.JobId JobBenefits_JobId_fkey R
JobBoostingTasks.JobId JobBoostingTasks_JobId_fkey C
JobExtensionLogs.jobId JobExtensionLogs_jobId_fkey C
JobFeaturesMaximum.jobId JobFeaturesMaximum_jobId_fkey C
JobJobTitles.JobId JobJobTitles_JobId_fkey R
JobNotificationReceivers.JobId JobNotificationReceivers_JobId_fkey R
JobQualityIssues.JobId JobQualityIssues_JobId_fkey C
JobSalaries.JobId JobSalaries_JobId_fkey R
JobScreeningQuestions.jobId JobScreeningQuestions_jobId_fkey C
JobShares.JobId JobShares_JobId_fkey R
JobSkills.JobId JobSkills_JobId_fkey R
JobStatusLogs.jobId JobStatusLogs_jobId_fkey C
Recommendations.JobId Recommendations_JobId_fkey C
ReferralApplications.JobId ReferralApplications_JobId_fkey R
ReportedCandidates.jobId ReportedCandidates_jobId_fkey N
ReportedJobs.JobId ReportedJobs_JobId_fkey C
SourcedJobs.GlintsJobId SourcedJobs_GlintsJobId_fkey R
SystemPredictionLogs.JobId SystemPredictionLogs_JobId_fkey C
SystemPredictionResolutions.JobId SystemPredictionResolutions_JobId_fkey C
TalentHuntJobApplications.JobId TalentHuntJobApplications_JobId_fkey R
TalentHuntJobInfo.JobId TalentHuntJobInfo_JobId_fkey R

Primary Key.
title varchar 255 null

Job Title.
status enum_Jobs_status 2147483647 null

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

File name linking to their resumes in s3 bucket glints-dashboard/job-banner-pic.
type enum_Jobs_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 Jobs_CreatorId_fkey N

Id of user who posted the job. Foreign Key References Users Table..
CompanyId uuid 2147483647 null
Companies.id Jobs_CompanyId_fkey R

Foreign Key to Company Table.
numberOfHires int4 10 1

Number of Hires for this job posting.
isPublic bool 1 true

Boolean indicating whether a job can be shown on main Glints site.
JobCategoryId int4 10 √ null
JobCategories.id Jobs_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 Jobs_CityId_fkey N

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

Country Code of country that this job is in. Foreign Key Reference Countries.
expiryDate date 13 √ null
minYearsOfExperience int4 10 √ 0
maxYearsOfExperience int4 10 √ 50
startDate date 13 √ null
endDate date 13 √ null
isCoverLetterMandatory bool 1 √ false
externalApplyURL varchar 255 √ null
closedAt timestamptz 35,6 √ null
acceptsForeignApplications bool 1 false
CitySubDivisionId int4 10 √ null
CitySubDivisions.id Jobs_CitySubDivisionId_fkey R
isHot 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 Jobs_HierarchicalJobCategoryId_fkey N

Foreign Key to Hierarchical Job Category Table. Only level 3 hierarchical job category is allowed.
DistrictId uuid 2147483647 √ null
Locations.id Jobs_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 Jobs_EmployerServiceRepId_fkey N
fraudReportFlag enum_Jobs_fraudReportFlag 2147483647 √ null

An identifier for the CR team to know in which stage is the current job in, in terms of the report investigation
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
metadata jsonb 2147483647 √ null
isResumeRequiredForCandidate bool 1 false
screeningQuestionsEnabled bool 1 false

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

This field will contains list of VIP fields with the current value set for a job
vipCandidateInformation jsonb 2147483647 √ null

Contains a list of candidate information. Only if the job is from a VIP company
CompanyAddressId uuid 2147483647 √ null
CompanyAddresses.id Jobs_CompanyAddressId_fkey R
varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
Jobs_pkey Primary key Asc id
Jobs_CompanyId_idx Performance Asc CompanyId
Jobs_CompanyId_status_fraudReportFlag_idx Performance Asc/Asc/Asc CompanyId + status + fraudReportFlag
Jobs_CountryCode_idx Performance Asc CountryCode
Jobs_CreatorId_idx Performance Asc CreatorId
Jobs_expiryDate_idx Performance Asc expiryDate
Jobs_id_CompanyId_idx Performance Asc/Asc id + CompanyId
Jobs_status_idx Performance Asc status
Jobs_title_idx Performance Asc title
Jobs_type_idx Performance Asc type
Jobs_updatedAt_idx Performance Asc updatedAt

Check Constraints

Constraint Name Constraint
Jobs_minAge_check (((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))
Jobs_maxAge_check (((("maxAge" IS NOT NULL) AND ("maxAge" >= 0) AND ("maxAge" <= 100)) OR ("maxAge" IS NULL)))
Jobs_no_duplicate_job_constraint (((companies_get_country_code("CompanyId") <> 'VN'::text) OR (status <> 'OPEN'::"enum_Jobs_status") OR jobs_check_duplicate_job(id, (title)::text, "DistrictId", "descriptionRaw"))) NOT VALID
Jobs_expiryDate_check (("expiryDate" <= (now() + '41 days'::interval))) NOT VALID
minAge_and_maxAge_check (((("minAge" IS NOT NULL) AND ("maxAge" IS NOT NULL) AND ("minAge" < "maxAge")) OR ("minAge" IS NULL) OR ("maxAge" IS NULL)))
Jobs_closedAt_check ((((status = 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NOT NULL)) OR ((status <> 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NULL))))
Jobs_HierarchicalJobCategoryId_not_null_non_closed_Jobs (((status = 'CLOSED'::"enum_Jobs_status") OR ("HierarchicalJobCategoryId" IS NOT NULL)))

Relationships

Close relationships within degrees of separation