# 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     |