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 |