HoustonJobImports


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
title varchar 255 null
companyId uuid 2147483647 null
CompanyDeal.companyId Implied Constraint R
jobId uuid 2147483647 √ null
TalentHuntJobInfo.JobId Implied Constraint R
jobCategoryName varchar 255 null
jobCategoryId uuid 2147483647 √ null
type enum_HoustonJobImports_type 2147483647 null
workArrangement enum_HoustonJobImports_workArrangement 2147483647 null
country varchar 255 null
countryCode varchar 255 √ null
countryId uuid 2147483647 √ null
province varchar 255 null
provinceId uuid 2147483647 √ null
city varchar 255 null
cityId uuid 2147483647 √ null
district varchar 255 null
districtId uuid 2147483647 √ null
descriptionRaw jsonb 2147483647 √ null
description text 2147483647 √ null
minSalary int4 10 null
maxSalary int4 10 √ null
shouldShowSalary bool 1 null
gender enum_HoustonJobImports_gender 2147483647 null
minAge int4 10 null
maxAge int4 10 null
skills jsonb 2147483647 null
skillIds jsonb 2147483647 √ null
educationLevel enum_HoustonJobImports_educationLevel 2147483647 null
minYearsOfExperience int4 10 √ null
maxYearsOfExperience int4 10 √ null
isProfilePictureRequiredForCandidate bool 1 √ null
isResumeRequiredForCandidate bool 1 √ null
creatorEmail varchar 255 null
creatorId varchar 255 √ null
status enum_HoustonJobImports_status 2147483647 'PENDING'::"enum_HoustonJobImports_status"
errorMessage varchar 255 √ null
createdAt timestamptz 35,6 √ CURRENT_TIMESTAMP
updatedAt timestamptz 35,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
HoustonJobImports_pkey Primary key Asc id
houston_job_imports_id Performance Asc id
houston_job_imports_status Performance Asc status

Relationships

Close relationships within degrees of separation