The master customer table that holds all information about visitors. The Customer table is also used for profile management of users on the site, so temporary visitors get temporary customer records.

Table Indexes

• company
  Index Key: company
  
• custtype
  Index Key: custtype
  
• PK_wws_customers
  Index Key: pk
  
• userid
  Index Key: userid
  

Table Fields

Field	Description
address	Address of the customer. text
city	City of the customer char(20)
company	Company name of the customer. char(40)
country	Long country name description char(30)
countryid	Two letter ISO country code (US,CA,MX,DE etc.) char(2)
custtype	not used numeric(3)
downloaded	Flag that determines whether the customer was previously downloaded. (not used) bit
email	Email address for the customer text
entered	Date entered smalldatetime(16)
fax	Fax number for the customer text
firstname	First name of the customer char(20)
lastname	Last name of the customer char(30)
lastorder	Date of the Last Order placed. smalldatetime(16)
notes	Any notes about the customer or orders. text
password	User's Profile password. char(15)
phone	The phone number for the customer text
pk	int
referral	Referral value from the Web site. Last referral only. text
shipping	A full shipping address used for the last invoice. text
source	text
state	The two letter state or province code. char(2)
storepk	Pk of the store this belongs to int
timestamp_column	timestamp
updated	Last time customer record was updated smalldatetime(16)
userid	UserId which maps to the user's session cookie char(9)
xml	XML Properties field for custom properties. text
zip	The zip or postal code for the customer char(12)
zip4	Zip+4 value (not used) char(4)