SalaryEstimates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"SalaryEstimates_id_seq"'::regclass)
JobTitleId int4 10 null
JobTitles.id SalaryEstimates_JobTitleId_fkey C

foreign key, refer to JobTitle.
CurrencyCode varchar 255 null
Currencies.code SalaryEstimates_CurrencyCode_fkey C

Currency of the desired salary estimate
CountryCode varchar 255 null
Countries.code SalaryEstimates_CountryCode_fkey C

Country of the desired salary estimate
seniority enum_Salary_estimates_seniority 2147483647 null

Enum value describing the seniority of the job title
minAmount int4 10 null

Minimum estimated salary amount
maxAmount int4 10 √ null

Maximum estimated salary amount
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
SalaryEstimates_pkey Primary key Asc id
SalaryEstimates_JobTitleId_seniority_CountryCode_key Must be unique Asc/Asc/Asc JobTitleId + seniority + CountryCode

Relationships

Close relationships within degrees of separation