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