SuggestedSalaries


Columns

Column Type Size Nulls Auto Default Children Parents Comments
hierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id SuggestedSalaries_hierarchicalJobCategoryId_fkey C

Foreign key to HierarchicalJobCategory
min int4 10 null

Minimum salary
max int4 10 null

Maximum salary
currencyCode varchar 255 null
Currencies.code SuggestedSalaries_currencyCode_fkey C

ISO 4217 currency code that salary is in
countryCode varchar 255 null
Countries.code SuggestedSalaries_countryCode_fkey C

Country Code of country that this job is in
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
SuggestedSalaries_pkey Primary key Asc/Asc/Asc hierarchicalJobCategoryId + countryCode + currencyCode

Relationships

Close relationships within degrees of separation