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. |