Databases > Northwind > Tables > EmployeeTerritories

Northwind

EmployeeTerritories

Created: Modified:

Columns

  • EmployeeID
    [int] NOT NULL
  • TerritoryID
    [nvarchar](20) NOT NULL

Indexes

  • PK_EmployeeTerritories
    UNIQUE NONCLUSTERED
    EmployeeID , TerritoryID

Foreign Keys

  • FK_EmployeeTerritories_Employees
    Employees
    EmployeeID ⥱ EmployeeID
  • FK_EmployeeTerritories_Territories
    Territories
    TerritoryID ⥱ TerritoryID

Sample Data

EmployeeID
TerritoryID
1
06897
1
19713
2
01581
2
01730
2
01833
2
02116
2
02139
2
02184
2
40222
3
30346
3
31406
3
32859
3
33607
4
20852
4
27403
4
27511
5
02903
5
07960
5
08837
5
10019
5
10038
5
11747
5
14450
6
85014
6
85251