CustomerAddress

CustomerAddress is an auto generated table

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	ID
City	String	False	City name
Company	String	False	Company
CountryId	String	False	Country code in ISO_3166-2 format
CustomerId	Int	False	Customer ID
DefaultBilling	Bool	False	If this address is default billing address
DefaultShipping	Bool	False	If this address is default shipping address.
ExtensionAttributes	String	False	This is an auto-generated column
Fax	String	False	Fax number
Firstname	String	False	First name
Lastname	String	False	Last name
Middlename	String	False	Middle name
Postcode	String	False	Postcode
Prefix	String	False	Prefix
Region	String	False	This is an auto-generated column
RegionId	Int	False	Region ID
Street	String	False	Street
Suffix	String	False	Suffix
Telephone	String	False	Telephone number
VatId	String	False	Vat id

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
AddressId_p	Int	This is an auto-generated column

JDBC Driver for Magento

CustomerAddress

Columns

Pseudo-Columns