Currencies


Description

Currency.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
code varchar 255 null
Candidates.currentSalaryCurrencyCode Candidates_currentSalaryCurrencyCode_fkey N
Candidates.expectedSalaryCurrencyCode Candidates_expectedSalaryCurrencyCode_fkey N
CurrencyConversionRates.FromCurrencyCode CurrencyConversionRates_FromCurrencyCode_fkey C
CurrencyConversionRates.ToCurrencyCode CurrencyConversionRates_ToCurrencyCode_fkey C
JobSalaries.CurrencyCode JobSalaries_CurrencyCode_fkey N
JobSalaryDrafts.CurrencyCode JobSalaryDrafts_CurrencyCode_fkey N
LocationWageGuidance.CurrencyCode LocationWageGuidance_CurrencyCode_fkey R
Preferences.CurrencyCode Preferences_CurrencyCode_fkey N
SalaryEstimates.CurrencyCode SalaryEstimates_CurrencyCode_fkey C
SourcedJobs.SalaryCurrencyCode SourcedJobs_SalaryCurrencyCode_fkey R
SuggestedSalaries.currencyCode SuggestedSalaries_currencyCode_fkey C
JobOrders.currencyId JobOrders_currencyId_fkey R
JobOrders.recommendedSourcingSalariesCurrencyId JobOrders_recommendedSourcingSalariesCurrencyId_fkey R

Primary Key. Currency Code following ISO 4217.
name varchar 255 √ null

Name of the Currency.
namePlural varchar 255 √ null

Name of the Currency in plural form.
symbol varchar 255 √ null

International Currency Symbol.
symbolNative varchar 255 √ null

Native Currency Symbol.
decimal int4 10 √ null

Maximum number of decimal places with regards to the currency symbol.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
isSupported bool 1 false

Signifies if a currency is supported for conversion or not.

Indexes

Constraint Name Type Sort Column(s)
Currencies_pkey Primary key Asc code

Relationships

Close relationships within degrees of separation