CurrencyConversionRates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FromCurrencyCode varchar 255 null
Currencies.code CurrencyConversionRates_FromCurrencyCode_fkey C

foreign key, refer to Currencies.
ToCurrencyCode varchar 255 null
Currencies.code CurrencyConversionRates_ToCurrencyCode_fkey C

foreign key, refer to Currencies.
rate float8 17,17 null

Conversion rate. Multiply currency in FromCurrencyCode with rate to get amount in ToCurrencyCode
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CurrencyConversionRates_pkey Primary key Asc/Asc FromCurrencyCode + ToCurrencyCode

Relationships

Close relationships within degrees of separation