Table address book

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

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

A unique, auto incremented value, to identify each address book record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

customers_id

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

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

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

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