Owner: | dbo |
Creation Date: | 08/06/2000 |
Located On: | PRIMARY |
Data Size KB: | 8 |
Index Size KB: | 24 |
Rows: | 49 |
Description: |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
|
|
EmployeeID | int | 4 |
|
|
|
||
|
|
TerritoryID | nvarchar | 40 |
|
|
|
Index | Primary | Unique | Description | |
|
PK_EmployeeTerritories |
|
|
|
|
_WA_Sys_TerritoryID_36B12243 |
|
|
Table | Foreign Key | Primary Key or Unique Constraint | |
|
dbo.Employees | FK_EmployeeTerritories_Employees | PK_Employees |
|
dbo.Territories | FK_EmployeeTerritories_Territories | PK_Territories |
Objects that [dbo].[EmployeeTerritories] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Employees | dbo | Table | 1 |
|
Region | dbo | Table | 1 |
|
Territories | dbo | Table | 2 |
CREATE TABLE [EmployeeTerritories] (
[EmployeeID] [int] NOT NULL ,
[TerritoryID] [nvarchar] (20) COLLATE Cyrillic_General_CI_AS NOT NULL ,
CONSTRAINT [PK_EmployeeTerritories] PRIMARY KEY NONCLUSTERED
(
[EmployeeID],
[TerritoryID]
) ON [PRIMARY] ,
CONSTRAINT [FK_EmployeeTerritories_Employees] FOREIGN KEY
(
[EmployeeID]
) REFERENCES [Employees] (
[EmployeeID]
),
CONSTRAINT [FK_EmployeeTerritories_Territories] FOREIGN KEY
(
[TerritoryID]
) REFERENCES [Territories] (
[TerritoryID]
)
) ON [PRIMARY]
GO
See Also
List of tables