Table address format

From Zen Cart(tm) Wiki
Revision as of 12:02, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the available formats for the ouput of an address stored in the address_book table.


These formats are used to display addresses in the correct format, as selected by the related address_format field in the countries table.


These formats are ISO standards.


Table Details

Primary Key

address_format_id

Indexed Fields

None.


Columns

address_format_id Primary Key

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


address_format

The format used for displaying the shipping/billing address.
Type: varchar(128)
Null: No
Default:
Info.png Variables!
Possible variables are:
  • $firstname - first name
  • $lastname - last name
  • $cr - forces line break
  • $streets - street address
  • $city - city
  • $state - state
  • $statecomma - state followed by a comma and a space
  • $postcode - postcode
  • $country - country
  • Punctuation, spaces and other characters can be added as well before or after the variables


address_summary

Summary of the address format used for display purposes.
Type: varchar(48)
Null: No
Default:


Default Entries

address_format_id: 1
address_format: $firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country
address_summary: $city / $country


address_format_id: 2
address_format: $firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country
address_summary: $city, $state / $country


address_format_id: 3
address_format: $firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country
address_summary: $state / $country


address_format_id: 4
address_format: $firstname $lastname$cr$streets$cr$city ($postcode)$cr$country
address_summary: $postcode / $country


address_format_id: 5
address_format: $firstname $lastname$cr$streets$cr$postcode $city$cr$country
address_summary: $city / $country