Table address book

From Zen Cart(tm) Wiki
Revision as of 15:01, 26 May 2007 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 addresses that a customer creates for shipping, billing and personal data.


Table Details

Primary Key

address_book_id

Indexed Fields

customers_id


Columns

address_book_id Primary Key

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


customers_id Foreign Key Index

Links the address book record to the customer that created it. Foreign key to customers.customers_id.
Type: int(11)
Null: No
Default: 0


entry_gender

The gender of the person referenced in the address book record. Can be set to m (male) or f (female).
Type: char(1)
Null: No
Default:


entry_company

The company name of the person referenced in the address book record.
Type: varchar(32)
Null: Yes
Default: NULL


entry_firstname

The first name of the person referenced in the address book record.
Type: varchar(32)
Null: No
Default:


entry_lastname

The last name of the person referenced in the address book record.
Type: varchar(32)
Null: No
Default:


entry_street_address

The street address of the person referenced in the address book record.
Type: varchar(64)
Null: No
Default:


entry suburb

The suburb of the person referenced in the address book record. Could also potentially be used as the Address Line 2 field (which occurs when your site is configured using USA defaults).
Type: varchar(32)
Null: Yes
Default: NULL
Info.png Localization Issue!
In some areas of the world, suburb is used in a mailing address.


entry_postcode

The postal code of the person referenced in the address book record.
Type: varchar(10)
Null: No
Default:


entry_city

The city of the person referenced in the address book record.
Type: varchar(32)
Null: No
Default:


entry_state

The state of the person referenced in the address book record.
Type: varchar(32)
Null: Yes
Default: NULL


entry_country_id Foreign Key

Links the address book record to a country id. Foreign key to countries.country_id.
Type: int(11)
Null: No
Default: 0


entry_zone_id Foreign Key

Links the address book record to a zone id. Foreign key to zones.zones_id.
Type: int(11)
Null: No
Default: 0


Default Entries (assuming demo data installed)

address_book_id: 1
customers_id: 1
entry_gender: m
entry_company: JustaDemo
entry_firstname: Bill
entry_lastname: Smith
entry_street_address: 123 Any Avenue
entry_suburb:
entry_postcode: 12345
entry_city: Here
entry_state:
entry_country_id: 223
entry_zone_id: 12