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 | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
SalesLastYear | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
CostYTD | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | no | — | — |
CostLastYear | DECIMAL_TEXT(19,4)Exact decimal · precision 19, scale 4 · text storage | 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 | .0000 |
| 2 | Northeast | US | North America | 2402176.8476 | 3607148.9371 | .0000 |
| 3 | Central | US | North America | 3072175.1180 | 3205014.0767 | .0000 |
| 4 | Southwest | US | North America | 10510853.8739 | 5366575.7098 | .0000 |
| 5 | Southeast | US | North America | 2538667.2515 | 3925071.4318 | .0000 |
| 6 | Canada | CA | North America | 6771829.1376 | 5693988.8600 | .0000 |
| 7 | France | FR | Europe | 4772398.3078 | 2396539.7601 | .0000 |
| 8 | Germany | DE | Europe | 3805202.3478 | 1307949.7917 | .0000 |
Interactive explorer