Generated using SQL Data Dictionary demo version.


Table Sales.SalesTerritoryHistory (17 rows)


Sales representative transfers to other sales territories.


  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.
PK, FK TerritoryID int
Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
PK StartDate datetime
Primary key. Date the sales representive started work in the territory.
EndDate datetime X
Date the sales representative left work in the territory.
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:


References: