Employee
Inheritance hierarchy
Hierarchy type |
Target per entity |
Is abstract |
True |
Employee (Hierarchy root)
Relationships
The Employee entity is part of the following relationships
Related Entity |
Full description |
Department |
Employee.WorksForDepartment - Department.Employees (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 |
Id |
int (System.Int32) |
Yes |
|
|
Yes |
0 |
0 |
0 |
Name |
string (System.String) |
|
|
|
|
50 |
0 |
0 |
StartDate |
datetime (System.DateTime) |
|
|
|
|
0 |
0 |
0 |
WorksForDepartmentId |
int (System.Int32) |
|
Yes |
Yes |
|
0 |
0 |
0 |
Unique Constraints
The following unique constraints are defined at the entity level
Name |
Fields |
IXEmployee |
Name |
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 |
Id |
EmployeeID |
|
int |
0 |
10 |
0 |
SCOPE_IDENTITY() |
|
Name |
Name |
|
varchar |
50 |
0 |
0 |
|
|
StartDate |
StartDate |
|
datetime |
0 |
0 |
0 |
|
|
WorksForDepartmentId |
WorksForDepartmentID |
Yes |
int |
0 |
10 |
0 |
|
|
Setting values
Employee (Entity)
Setting name |
Value |
Entity base class name |
CommonEntityBase |
Id (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Name (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
StartDate (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
WorksForDepartmentId (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
WorksForDepartment (NavigatorSingleValue)
Setting name |
Value |
Navigator property is public |
True |
Attribute definitions per element
WorksForDepartment (NavigatorSingleValue)
Additional interface definitions per element
None.
Additional namespace definitions per element
None.