Customer Table (AdventureWorks)

Contains current customer information. Customers are categorized by type: individual consumer or retail store.

Customer Table Definition

The Customer table is contained in the Sales schema.

Column Data type Nullability Description

CustomerID

int

Not null

Primary key for Customer rows.

TerritoryID

int

Null

ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.

AccountNumber

int

Not null

Unique number that identifies the customer.

CustomerType

nchar(1)

Not null

Customer type:

I = Individual

S = Store

rowguid

uniqueidentifier ROWGUIDCOL

Not null

ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

CustomerAddress Table (AdventureWorks)
Individual Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesTerritory Table (AdventureWorks)
Store Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance