Jobs

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

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
Applications_copy1.JobId	Applications_copy1_JobId_fkey	R
Bookmarks.ForJobId	Bookmarks_ForJobId_fkey	R
Bookmarks.JobId	Bookmarks_JobId_fkey	R
ChatAutoInvitations.jobId	ChatAutoInvitations_jobId_fkey	C
ChatBlockingList.jobId	ChatBlockingList_jobId_fkey	N
Comments.JobId	Comments_JobId_fkey	R
DailyMetricsForJobs.JobId	DailyMetricsForJobs_JobId_fkey	R
EmployerCustomMessages.JobId	EmployerCustomMessages_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
JobPreferredKeywords.jobId	JobPreferredKeywords_jobId_fkey	C
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
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

Id of user who posted the job. Foreign Key References Users Table..

CompanyId

uuid

2147483647

null

Companies.id

Jobs_CompanyId_fkey

Foreign Key to Company Table.

numberOfHires

int4

Number of Hires for this job posting.

isPublic

bool

true

Boolean indicating whether a job can be shown on main Glints site.

JobCategoryId

int4

√

null

JobCategories.id

Jobs_JobCategoryId_fkey

Foreign Key to JobCategory Table.

isRemote

bool

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

√

null

Cities.id

Jobs_CityId_fkey

Foreign Key to Cities Table.

CountryCode

varchar

255

null

Countries.code

Jobs_CountryCode_fkey

Country Code of country that this job is in. Foreign Key Reference Countries.

expiryDate

date

√

null

minYearsOfExperience

int4

√

maxYearsOfExperience

int4

√

startDate

date

√

null

endDate

date

√

null

isCoverLetterMandatory

bool

√

false

externalApplyURL

varchar

255

√

null

closedAt

timestamptz

35,6

√

null

acceptsForeignApplications

bool

false

CitySubDivisionId

int4

√

null

CitySubDivisions.id

Jobs_CitySubDivisionId_fkey

isHot

bool

√

false

shouldPublishOnLinkedin

bool

false

Consent given by a company user to post their job on Linkedin.

shouldShowBenefits

bool

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

true

Boolean indicating if employer wants to show the job salary or not.

HierarchicalJobCategoryId

uuid

2147483647

√

null

HierarchicalJobCategories.id

Jobs_HierarchicalJobCategoryId_fkey

Foreign Key to Hierarchical Job Category Table. Only level 3 hierarchical job category is allowed.

DistrictId

uuid

2147483647

√

null

Locations.id

Jobs_DistrictId_fkey

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

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

√

null

maxAge

int2

√

null

gender

enum_Users_gender

2147483647

√

null

Gender preferred for the job

isLocationRequiredForCandidate

bool

√

null

Boolean indicating if candidate location is required.

isEducationRequiredForCandidate

bool

√

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

false

screeningQuestionsEnabled

bool

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

Indexes

Constraint Name	Type	Sort	Column(s)
Jobs_pkey	Primary key	Asc	id
Jobs_CompanyId_createdAt_id_idx	Performance	Asc/Desc/Desc	CompanyId + createdAt + id
Jobs_CompanyId_HierarchicalJobCategoryId_updatedAt_idx	Performance	Asc/Asc/Desc	CompanyId + HierarchicalJobCategoryId + updatedAt
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_DistrictId_idx	Performance	Asc	DistrictId
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_HierarchicalJobCategoryId_not_null_non_closed_Jobs	(((status = 'CLOSED'::"enum_Jobs_status") OR ("HierarchicalJobCategoryId" IS NOT NULL)))
Jobs_maxAge_check	(((("maxAge" IS NOT NULL) AND ("maxAge" >= 0) AND ("maxAge" <= 100)) OR ("maxAge" IS NULL)))
Jobs_closedAt_check	((((status = 'CLOSED'::"enum_Jobs_status") AND ("closedAt" IS NOT NULL)) OR (status = 'DELETED'::"enum_Jobs_status") OR ((status <> ALL (ARRAY['CLOSED'::"enum_Jobs_status", 'DELETED'::"enum_Jobs_status"])) AND ("closedAt" 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)))
Jobs_expiryDate_check	(("expiryDate" <= (now() + '41 days'::interval))) NOT VALID
Jobs_metadata_closureInfo_valid	( CASE WHEN ((jsonb_typeof(metadata) = 'object'::text) AND (metadata ? 'closureInfo'::text)) THEN (((jsonb_typeof((metadata -> 'closureInfo'::text)) = 'object'::text) AND (((metadata -> 'closureInfo'::text) ->> 'triggerType'::text) = ANY (ARRAY['EMPLOYER_DEACTIVATION'::text, 'JOB_EXPIRY'::text])) AND (((metadata -> 'closureInfo'::text) ->> 'employerResponseStatus'::text) = ANY (ARRAY['PENDING'::text, 'DISMISSED'::text, 'SUBMITTED'::text])) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'jobStatusLogId'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'jobStatusLogId'::text))) > 0) AND ((((metadata -> 'closureInfo'::text) ->> 'employerResponseStatus'::text) <> 'SUBMITTED'::text) OR ((jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'answers'::text)) = 'object'::text) AND (jsonb_typeof((((metadata -> 'closureInfo'::text) -> 'answers'::text) -> 'reason'::text)) = 'string'::text) AND (length(btrim((((metadata -> 'closureInfo'::text) -> 'answers'::text) ->> 'reason'::text))) > 0) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'submittedAt'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'submittedAt'::text))) > 0) AND (jsonb_typeof(((metadata -> 'closureInfo'::text) -> 'submittedByUserId'::text)) = 'string'::text) AND (length(btrim(((metadata -> 'closureInfo'::text) ->> 'submittedByUserId'::text))) > 0)))) IS TRUE) ELSE true END) NOT VALID
Jobs_minAge_check	(((("minAge" IS NOT NULL) AND ("minAge" >= 0) AND ("minAge" <= 100)) OR ("minAge" IS NULL)))

Description

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation