wws_customers - West Wind Web Store .NET

wws_customers

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. varchar(2048)
city	City of the customer varchar(30)
company	Company name of the customer. varchar(80)
country	Long country name description varchar(40)
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 varchar(256)
entered	Date entered smalldatetime(16)
fax	Fax number for the customer varchar(256)
firstname	First name of the customer varchar(40)
lastname	Last name of the customer varchar(40)
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 varchar(128)
pk	Primary Key int
referral	Referral value from the Web site. Last referral only. varchar(255)
shipping	A full shipping address used for the last invoice. text
state	The two letter state or province code. char(2)
storepk	Pk of the store this belongs to int
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)