| Column | Data Type | Nullable | Default | Description / PK / Index |
| SalesPersonID | int | not null | | Primary key for SalesTerritoryHistory records.
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID |
| TerritoryID | int | not null | | Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID |
| StartDate | datetime | not null | | Date the sales representive started work in the territory.
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID |
| 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.
AK_SalesTerritoryHistory_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|