Employee
Inheritance hierarchy
| Hierarchy type |
None |
| Is abstract |
False |
Relationships
The Employee entity is part of the following relationships
| Related Entity |
Full description |
| Customer |
Customer.Employees - Employee.Customers (m:n) (via TestGroup.Order) |
| Employee |
Employee.Manager - Employee.ManagedEmployees (m:1) |
| EmployeeTerritories |
EmployeeTerritories.Employees - Employee.EmployeeTerritories (m:1) |
| Region |
Employee.Region_ - Region.Employee (m:1) |
| Region |
Region.Employee_ - Employee.Region__ (m:n) (via Employee) |
| Shipper |
Shipper.Employees - Employee.Shippers (m:n) (via TestGroup.Order) |
| Territory |
Employee.Territories - Territory.Employees (m:n) (via EmployeeTerritories) |
| TestGroup.Order |
TestGroup.Order.Employees - Employee.Orders (m:1) |
Fields
The following fields are defined in the Employee entity
| Name |
Type |
Is PK |
Is FK |
Optional |
Read-only |
Max. length |
Precision |
Scale |
| Address |
AddressVt |
|
|
|
|
0 |
0 |
0 |
| BirthDate |
datetime (System.DateTime) |
|
|
Yes |
|
0 |
0 |
0 |
| EmployeeId |
int (System.Int32) |
Yes |
|
|
Yes |
0 |
0 |
0 |
| Extension |
string (System.String) |
|
|
Yes |
|
4 |
0 |
0 |
| FirstName |
string (System.String) |
|
|
|
|
10 |
0 |
0 |
| HireDate |
datetime (System.DateTime) |
|
|
Yes |
|
0 |
0 |
0 |
| HomePhone |
string (System.String) |
|
|
Yes |
|
24 |
0 |
0 |
| LastName |
string (System.String) |
|
|
|
|
20 |
0 |
0 |
| Notes |
string (System.String) |
|
|
Yes |
|
1073741823 |
0 |
0 |
| Photo |
byte[] (System.Byte[]) |
|
|
Yes |
|
2147483647 |
0 |
0 |
| PhotoPath |
string (System.String) |
|
|
Yes |
|
255 |
0 |
0 |
| PostalCode |
string (System.String) |
|
|
Yes |
|
10 |
0 |
0 |
| RegionId |
int (System.Int32) |
|
Yes |
Yes |
|
0 |
0 |
0 |
| ReportsTo |
int (System.Int32) |
|
Yes |
Yes |
|
0 |
0 |
0 |
| Title |
string (System.String) |
|
|
Yes |
|
30 |
0 |
0 |
| TitleOfCourtesy |
string (System.String) |
|
|
Yes |
|
25 |
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 |
| Address.Address |
Address |
Yes |
nvarchar |
60 |
0 |
0 |
|
|
| Address.City |
City |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
| Address.Country |
Country |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
| Address.Region |
Region |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
| BirthDate |
BirthDate |
Yes |
datetime |
0 |
0 |
0 |
|
|
| EmployeeId |
EmployeeID |
|
int |
0 |
10 |
0 |
SCOPE_IDENTITY() |
|
| Extension |
Extension |
Yes |
nvarchar |
4 |
0 |
0 |
|
|
| FirstName |
FirstName |
|
nvarchar |
10 |
0 |
0 |
|
|
| HireDate |
HireDate |
Yes |
datetime |
0 |
0 |
0 |
|
|
| HomePhone |
HomePhone |
Yes |
nvarchar |
24 |
0 |
0 |
|
|
| LastName |
LastName |
|
nvarchar |
20 |
0 |
0 |
|
|
| Notes |
Notes |
Yes |
ntext |
1073741823 |
0 |
0 |
|
|
| Photo |
Photo |
Yes |
image |
2147483647 |
0 |
0 |
|
|
| PhotoPath |
PhotoPath |
Yes |
nvarchar |
255 |
0 |
0 |
|
|
| PostalCode |
PostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
|
|
| RegionId |
RegionID |
Yes |
int |
0 |
10 |
0 |
|
|
| ReportsTo |
ReportsTo |
Yes |
int |
0 |
10 |
0 |
|
|
| Title |
Title |
Yes |
nvarchar |
30 |
0 |
0 |
|
|
| TitleOfCourtesy |
TitleOfCourtesy |
Yes |
nvarchar |
25 |
0 |
0 |
|
|
Setting values
Employee (Entity)
| Setting name |
Value |
| Entity base class name |
CommonEntityBase |
Address (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
BirthDate (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
EmployeeId (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
Extension (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
FirstName (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
HireDate (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
HomePhone (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
LastName (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
Notes (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
Photo (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
PhotoPath (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
PostalCode (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
RegionId (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
ReportsTo (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
Title (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
TitleOfCourtesy (NormalField)
| Setting name |
Value |
| Generate as nullable type |
True |
| Field property is public |
True |
| Field property has private setter |
False |
Customers (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
EmployeeTerritories (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
ManagedEmployees (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Manager (NavigatorSingleValue)
| Setting name |
Value |
| Navigator property is public |
True |
Orders (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Region_ (NavigatorSingleValue)
| Setting name |
Value |
| Navigator property is public |
True |
Region__ (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Shippers (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Territories (NavigatorCollection)
| Setting name |
Value |
| Navigator property is public |
True |
Attribute definitions per element
Extension (NormalField)
FirstName (NormalField)
HomePhone (NormalField)
LastName (NormalField)
Notes (NormalField)
PhotoPath (NormalField)
PostalCode (NormalField)
Title (NormalField)
TitleOfCourtesy (NormalField)
Manager (NavigatorSingleValue)
Region_ (NavigatorSingleValue)
Additional interface definitions per element
None.
Additional namespace definitions per element
None.