Sales.SalesTerritoryHistory Table

Information

Name	SalesTerritoryHistory
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
SalesTerritoryHistory	TABLE	MS_Description	Sales representative transfers to other sales territories.

Columns

Name	Data Type	References	Default
SalesPersonID	int	Sales.SalesPerson.SalesPersonID
TerritoryID	int	Sales.SalesTerritory.TerritoryID
StartDate	datetime
EndDate	datetime
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID	Clustered			SalesPersonID, StartDate, TerritoryID
AK_SalesTerritoryHistory_rowguid	NonClustered			rowguid

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_SalesTerritoryHistory_EndDate				([EndDate]>=[StartDate] OR [EndDate] IS NULL)

Foreign Key Constraints

Name	Type	Referenced Table
FK_SalesTerritoryHistory_SalesPerson_SalesPersonID	Foreign key	Sales.SalesPerson
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID	Foreign key	Sales.SalesTerritory

SQL Script

CREATE TABLE [Sales].[SalesTerritoryHistory] (
    [SalesPersonID] int NOT NULL,
    [TerritoryID] int NOT NULL,
    [StartDate] datetime NOT NULL,
    [EndDate] datetime NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SalesTerritoryHistory_rowguid] on [Sales].[SalesTerritoryHistory]([rowguid]);