Sales SalesTerritoryHistory (table)

wikibot ¶

Table	Sales.SalesTerritoryHistory
Description	Sales representative transfers to other sales territories.

Columns ¶

Column	Data Type	Nullable	Default	Description
SalesPersonID	int	not null		Primary key for SalesTerritoryHistory records.
TerritoryID	int	not null		Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
StartDate	datetime	not null		Date the sales representive started work in the territory.
EndDate	datetime	null		Date the sales representative left work in the territory.
rowguid	uniqueidentifier	not null	(newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID	SalesPersonID, TerritoryID, StartDate

Indexes ¶

Index	Type	Columns
AK_SalesTerritoryHistory_rowguid	Unique	rowguid

Check Constraints ¶

Check Constraint	Expression	Description
CK_SalesTerritoryHistory_EndDate	(EndDate>=StartDate OR EndDate IS NULL)	Check constraint EndDate >= StartDate OR EndDate IS NULL

Foreign Keys ¶

Relation	Column	Referenced Column
Sales.SalesPerson	SalesPersonID	SalesPersonID
Sales.SalesTerritory	TerritoryID	TerritoryID

References ¶

Dependency Type	Object Type	Referenced Object
Schema	Schema	Sales