Territory
Inheritance hierarchy
| Hierarchy type |
None |
| Is abstract |
False |
Relationships
The Territory entity is part of the following relationships
| Related Entity |
Full description |
| Employee |
Employee.Territories - Territory.Employees (m:n) (via EmployeeTerritories) |
| EmployeeTerritories |
EmployeeTerritories.Territories - Territory.EmployeeTerritories (m:1) |
| Region |
Territory.Region - Region.Territories (m:1) |
Fields
The following fields are defined in the Territory entity
| Name |
Type |
Is PK |
Is FK |
Optional |
Read-only |
Max. length |
Precision |
Scale |
| RegionId |
int (System.Int32) |
|
Yes |
|
|
0 |
0 |
0 |
| TerritoryDescription |
string (System.String) |
|
|
|
|
50 |
0 |
0 |
| TerritoryId |
string (System.String) |
Yes |
|
|
|
20 |
0 |
0 |
| Test |
byte[] (System.Byte[]) |
|
|
Yes |
|
50 |
0 |
0 |
Unique Constraints
None.
None.
Mappings
| Aspect |
Value |
| Type of target |
Table |
| Actions allowed |
Create / Retrieve / Update / Delete |
| Entity Field |
Target field |
Nullable |
Type |
Length |
Precision |
Scale |
Sequence |
Type converter |
| RegionId |
RegionID |
|
int |
0 |
10 |
0 |
|
|
| TerritoryDescription |
TerritoryDescription |
|
nchar |
50 |
0 |
0 |
|
|
| TerritoryId |
TerritoryID |
|
nvarchar |
20 |
0 |
0 |
|
|
| Test |
test |
Yes |
binary |
50 |
0 |
0 |
|
|
Setting values
Territory (Entity)
| Setting name |
Value |
| Entity base class name |
CommonEntityBase |
RegionId (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
TerritoryDescription (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
TerritoryId (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
Test (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
Employees (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
EmployeeTerritories (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Region (NavigatorSingleValue)
| Setting name |
Value |
| Navigator property is public |
True |
Attribute definitions per element
TerritoryDescription (NormalField)
TerritoryId (NormalField)
Region (NavigatorSingleValue)
Additional interface definitions per element
None.
Additional namespace definitions per element
None.