Sales.SalesTerritoryHistory

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  TerritoryID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  StartDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  EndDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID
  UNIQUE CLUSTERED
  BusinessEntityID , TerritoryID , StartDate
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SalesTerritoryHistory_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Foreign Keys

• //

  Foreign key constraint referencing SalesPerson.SalesPersonID.
  FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID
  Sales.SalesPerson
  BusinessEntityID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing SalesTerritory.TerritoryID.
  FK_SalesTerritoryHistory_SalesTerritory_TerritoryID
  Sales.SalesTerritory
  TerritoryID ⥱ TerritoryID

Check Constraints

• //

  Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
  CK_SalesTerritoryHistory_EndDate
  ([EndDate]>=[StartDate] OR [EndDate] IS NULL)

Sample Data