ccdw_dim_currency
This table provides details about various currencies. Each row represents an ISO 4217 currency.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
currency_id (PK) | SMALLINT | PK | Unique identifier for a currency. | Yes |
alpha_code | VARCHAR | Alpha-3 code for the currency (for example, "USD", "EUR"). | Yes | |
display_name | VARCHAR | User-friendly display name for the currency. | No | |
numeric_code | INTEGER | Numeric code for the currency. | No | |
symbol | VARCHAR | Symbol for the currency (for example, "$", "€"). | No | |
default_fraction_digits | SMALLINT | Number of default fraction digits for the currency. | No |