SourcedJobs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
GlintsJobId uuid 2147483647 √ null
Jobs.id SourcedJobs_GlintsJobId_fkey R
convertedToGlintsJobAt timestamptz 35,6 √ null
expiryDate date 13 null
title varchar 255 null
type enum_Jobs_type 2147483647 null
workArrangementOption enum_public_Jobs_workArrangementOption 2147483647 √ null
descriptionRaw jsonb 2147483647 null
SourcedCompanyId uuid 2147483647 null
SourcedCompanies.id SourcedJobs_SourcedCompanyId_fkey R
SalaryCurrencyCode varchar 255 √ NULL::character varying
Currencies.code SourcedJobs_SalaryCurrencyCode_fkey R
minSalary int4 10 √ null
maxSalary int4 10 √ null
educationLevel enum_EducationLevel_type 2147483647 √ null
minYearsOfExperience int4 10 √ null
maxYearsOfExperience int4 10 √ null
LocationId uuid 2147483647 null
Locations.id SourcedJobs_LocationId_fkey R
HierarchicalJobCategoryId uuid 2147483647 √ null
HierarchicalJobCategories.id SourcedJobs_HierarchicalJobCategoryId_fkey R
externalApplyURL varchar 255 null
metadata jsonb 2147483647 √ null
isActive bool 1 true

Indexes

Constraint Name Type Sort Column(s)
SourcedJobs_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation