EmployeeTerritories

Fields

Field name Ordinal Native type Length Precision Scale Is Nullable Is PK Is FK Is Identity Is Computed Default value Default sequence
EmployeeID 1 int 0 10 0 Yes Yes
TerritoryID 2 nvarchar 20 0 0 Yes Yes

Foreign key constraints

FK_EmployeeTerritories_Employees

Aspect Value
Primary key table dbo.Employees
Delete rule NoAction
Update rule NoAction
Foreign key field Primary key field
EmployeeID dbo.Employees.EmployeeID

FK_EmployeeTerritories_Territories

Aspect Value
Primary key table dbo.Territories
Delete rule NoAction
Update rule NoAction
Foreign key field Primary key field
TerritoryID dbo.Territories.TerritoryID

Model elements mapped on this table

Model Element Element type
EmployeeTerritories Entity