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.
|