AdventureWorks
| Table Name: | Sales.SalesTerritory |
| Description: | Sales territory lookup table. |
| Primary Keys: | TerritoryID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| TerritoryID | int - Identity | None | No | Primary key for SalesTerritory records. |
| Name | nvarchar (50) | None | No | Sales territory description |
| CountryRegionCode | nvarchar (3) | None | No | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. |
| Group | nvarchar (50) | None | No | Geographic area to which the sales territory belong. |
| SalesYTD | money | ((0.00)) | No | Sales in the territory year to date. |
| SalesLastYear | money | ((0.00)) | No | Sales in the territory the previous year. |
| CostYTD | money | ((0.00)) | No | Business costs in the territory year to date. |
| CostLastYear | money | ((0.00)) | No | Business costs in the territory the previous year. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_SalesTerritory_TerritoryID | Yes | Yes | TerritoryID |
| AK_SalesTerritory_Name | No | Yes | Name |
| AK_SalesTerritory_rowguid | No | Yes | rowguid |
| Check Constraint | Text |
|---|---|
| CK_SalesTerritory_SalesYTD | ([SalesYTD]>=(0.00)) |
| CK_SalesTerritory_SalesLastYear | ([SalesLastYear]>=(0.00)) |
| CK_SalesTerritory_CostYTD | ([CostYTD]>=(0.00)) |
| CK_SalesTerritory_CostLastYear | ([CostLastYear]>=(0.00)) |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Customer_SalesTerritory_TerritoryID | Sales.Customer | TerritoryID |
| FK_SalesOrderHeader_SalesTerritory_TerritoryID | Sales.SalesOrderHeader | TerritoryID |
| FK_SalesPerson_SalesTerritory_TerritoryID | Sales.SalesPerson | TerritoryID |
| FK_SalesTerritoryHistory_SalesTerritory_TerritoryID | Sales.SalesTerritoryHistory | TerritoryID |
| FK_StateProvince_SalesTerritory_TerritoryID | Person.StateProvince | TerritoryID |