Sales.Customer

Generated using SQL Data Dictionary demo version.

Table Sales.Customer (19,820 rows)

Current customer information. Also see the Person and Store tables.

	Column	Data Type	Identity	Nullable	Default
PK	CustomerID	int	X
Primary key.
FK	PersonID	int		X
Foreign key to Person.BusinessEntityID
FK	StoreID	int		X
Foreign key to Store.BusinessEntityID
FK	TerritoryID	int		X
ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
UK	AccountNumber	varchar(10)
Unique number identifying the customer assigned by the accounting system.
UK	rowguid	uniqueidentifier			newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_Customer_CustomerID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- CustomerID

AK_Customer_AccountNumber
- (Unique)
Unique nonclustered index.
- AccountNumber

AK_Customer_rowguid
- (Unique)
Unique nonclustered index. Used to support replication samples.
- rowguid

IX_Customer_TerritoryID
Nonclustered index.
- TerritoryID

References:

Person.Person
- BusinessEntityID (PersonID)

Sales.SalesTerritory
- TerritoryID

Sales.Store
- BusinessEntityID (StoreID)

Referenced by:

Sales.SalesOrderHeader
- CustomerID

Used by:

Function
dbo.ufnGetContactInformation
- PersonID
- StoreID
Trigger
Sales.iduSalesOrderDetail on Sales.SalesOrderDetail
- CustomerID
- PersonID
View
Sales.vIndividualCustomer
- PersonID
- StoreID