Northwind Explorer

Territories table

US sales territories, each in one region. 53 rows.

Columns

PRAGMA table_info

#	Name	Type	Not null	Default	Key	References
0	`TerritoryID`	`TEXT`	yes	—	PK
1	`TerritoryDescription`	`TEXT`	yes	—
2	`RegionID`	`INTEGER`	yes	—		Region.RegionID

Indexes

PRAGMA index_list

Name	Columns	Unique	Created by
`sqlite_autoindex_Territories_1`	`TerritoryID`	yes	PRIMARY KEY

Referenced by

EmployeeTerritories.TerritoryID → Territories.TerritoryID

Definition

from sqlite_schema

CREATE TABLE Territories (
    TerritoryID          TEXT NOT NULL PRIMARY KEY,
    TerritoryDescription TEXT NOT NULL,
    RegionID             INTEGER NOT NULL REFERENCES Region (RegionID)
)