Territories
Fields
| Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
Is PK |
Is FK |
Is Identity |
Is Computed |
Default value |
Default sequence |
| TerritoryID |
1 |
nvarchar |
20 |
0 |
0 |
|
Yes |
|
|
|
|
|
| TerritoryDescription |
2 |
nchar |
50 |
0 |
0 |
|
|
|
|
|
|
|
| RegionID |
3 |
int |
0 |
10 |
0 |
|
|
Yes |
|
|
|
|
| test |
4 |
binary |
50 |
0 |
0 |
Yes |
|
|
|
|
|
|
Foreign key constraints
FK_Territories_Region
| Aspect |
Value |
| Primary key table |
dbo.Region |
| Delete rule |
NoAction |
| Update rule |
NoAction |
| Foreign key field |
Primary key field |
| RegionID |
dbo.Region.RegionID |
Model elements mapped on this table