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