Field |
Type |
Default |
Description |
currencies_id |
int (11) |
NOT NULL |
PRIMARY KEY - Auto-increment number for record id. |
title |
varchar |
|
Textual description of the currency |
code |
char |
|
ISO currency code |
symbol_left |
varchar |
|
A single character that is appended to a value left of the number |
symbol_right |
varchar |
|
A single character that is appended to a value right of the number |
decimal_point |
char |
|
Character to use to separate whole numbers from the fractional part |
thousands_point |
char |
|
Character to use to separate three digit groups |
decimal_places |
char |
|
Number of number characters to round following the decimal point character |
value |
float |
|
Stores the conversion value from the default currency. This value needs to be manually updated through the Setup -> Currencies screen |
last_updated |
datetime |
|
Time stamp of the last time the record was updated |