Table currencies

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the different installed currencies information.


Table Details

Primary Key

currencies_id

Indexed Fields

None.


Columns

currencies_id Primary Key

A unique, auto incremented value, to identify each currency record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


title

The title of the currency record.
Type: varchar(32)
Null: No
Default:


code

The three-character code of the currency record.
Type: char(3)
Null: No
Default:


symbol_left

The text/symbols preceeding the currency record for display purposes.
Type: varchar(24)
Null: Yes
Default: NULL


symbol_right

The text/symbols trailing the currency record for display purposes.
Type: varchar(24)
Null: Yes
Default: NULL


decimal_point

The symbol used to represent the decimal point of the currency record for display purposes.
Type: char(1)
Null: Yes
Default: NULL


thousands_point

The symbol used to represent the thousands separator of the currency record for display purposes.
Type: char(1)
Null: Yes
Default: NULL


decimal_places

The number of decimal places of the currency record.
Type: char(1)
Null: Yes
Default: NULL


value

The value of the currency record in relation to the default currency for currency conversion purposes.
Type: float(13,8)
Null: Yes
Default: NULL


last_updated

The date and time that the record was last updated.
Type: datetime
Null: Yes
Default: NULL


Default Entries

currencies_id: 1
title: US Dollar
code: USD
symbol_left: $
symbol_right:
decimal_point: .
thousands_point: ,
decimal_places: 2
value: 1.00000000
last_updated: This value will always initially be the date and time that the database was setup.


currencies_id: 2
title: Euro
code: EUR
symbol_left:
symbol_right: EUR
decimal_point: .
thousands_point: ,
decimal_places: 2
value: 1.20389998
last_updated: This value will always initially be the date and time that the database was setup.