dim_currency


Description

All available currencies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
currency_id varchar 256 null
fct_contract_cancellation.currency_id Implied Constraint R
fct_idle_period.currency_id fct_idle_period_currency_id_fkey R
fct_payment_run.currency_id fct_payment_run_currency_id_fkey R
fct_revenue.currency_id Implied Constraint R
fct_revenue_cash_based.currency_id Implied Constraint R

Primary key of this table.
name varchar 256 √ null

Human readable name of the currency
code varchar 256 √ null

ISO 4217 currency code
numeric_code int8 19 √ null

ISO 4217 numeric code
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation