10rows
10 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
TerritoryID | INTEGER | no | PK | — |
Name | TEXT | no | — | — |
CountryRegionCode | TEXT | no | — | Person.CountryRegion.CountryRegionCode |
Group | TEXT | no | — | — |
SalesYTD | NUMERIC | no | — | — |
SalesLastYear | NUMERIC | no | — | — |
CostYTD | NUMERIC | no | — | — |
CostLastYear | NUMERIC | no | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_SalesTerritory_AK_SalesTerritory_NameNameSales_SalesTerritory_AK_SalesTerritory_rowguidrowguid2 unique indexes inspected
Sales_SalesTerritory_AK_SalesTerritory_NameNameCREATE UNIQUE INDEX "Sales_SalesTerritory_AK_SalesTerritory_Name" ON "Sales.SalesTerritory" ("Name")Sales_SalesTerritory_AK_SalesTerritory_rowguidrowguidCREATE UNIQUE INDEX "Sales_SalesTerritory_AK_SalesTerritory_rowguid" ON "Sales.SalesTerritory" ("rowguid")Data preview
Sample records
| TerritoryID | Name | CountryRegionCode | Group | SalesYTD | SalesLastYear | CostYTD |
|---|---|---|---|---|---|---|
| 1 | Northwest | US | North America | 7887186.7882 | 3298694.4938 | 0 |
| 2 | Northeast | US | North America | 2402176.8476 | 3607148.9371 | 0 |
| 3 | Central | US | North America | 3072175.118 | 3205014.0767 | 0 |
| 4 | Southwest | US | North America | 10510853.8739 | 5366575.7098 | 0 |
| 5 | Southeast | US | North America | 2538667.2515 | 3925071.4318 | 0 |
| 6 | Canada | CA | North America | 6771829.1376 | 5693988.86 | 0 |
| 7 | France | FR | Europe | 4772398.3078 | 2396539.7601 | 0 |
| 8 | Germany | DE | Europe | 3805202.3478 | 1307949.7917 | 0 |
Interactive explorer