Customer
Inheritance hierarchy
Hierarchy type |
None |
Is abstract |
False |
Relationships
The Customer entity is part of the following relationships
Related Entity |
Full description |
CustomerCustomerDemo |
CustomerCustomerDemo.Customers - Customer.CustomerCustomerDemo (m:1) |
Employee |
Customer.Employees - Employee.Customers (m:n) (via TestGroup.Order) |
Shipper |
Customer.Shippers - Shipper.Customers (m:n) (via TestGroup.Order) |
TestGroup.Order |
TestGroup.Order.Customers - Customer.Orders (m:1) |
Fields
The following fields are defined in the Customer entity
Name |
Type |
Is PK |
Is FK |
Optional |
Read-only |
Max. length |
Precision |
Scale |
CompanyName |
string (System.String) |
|
|
|
|
40 |
0 |
0 |
ContactName |
string (System.String) |
|
|
Yes |
|
30 |
0 |
0 |
ContactTitle |
string (System.String) |
|
|
Yes |
|
30 |
0 |
0 |
CustomerId |
string (System.String) |
Yes |
|
|
|
5 |
0 |
0 |
Fax |
string (System.String) |
|
|
Yes |
|
24 |
0 |
0 |
Phone |
string (System.String) |
|
|
Yes |
|
24 |
0 |
0 |
PostalCode |
string (System.String) |
|
|
Yes |
|
10 |
0 |
0 |
VisitingAddress |
AddressVt |
|
|
|
|
0 |
0 |
0 |
Unique Constraints
The following unique constraints are defined at the entity level
Name |
Fields |
CompanyName |
CompanyName |
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 |
CompanyName |
CompanyName |
|
nvarchar |
40 |
0 |
0 |
|
|
ContactName |
ContactName |
Yes |
nvarchar |
30 |
0 |
0 |
|
|
ContactTitle |
ContactTitle |
Yes |
nvarchar |
30 |
0 |
0 |
|
|
CustomerId |
CustomerID |
|
nchar |
5 |
0 |
0 |
|
|
Fax |
Fax |
Yes |
nvarchar |
24 |
0 |
0 |
|
|
Phone |
Phone |
Yes |
nvarchar |
24 |
0 |
0 |
|
|
PostalCode |
PostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
|
|
VisitingAddress.Address |
Address |
Yes |
nvarchar |
60 |
0 |
0 |
|
|
VisitingAddress.City |
City |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
VisitingAddress.Country |
Country |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
VisitingAddress.Region |
Region |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
Setting values
Customer (Entity)
Setting name |
Value |
Entity base class name |
CommonEntityBase |
CompanyName (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
CustomerId (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Fax (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Phone (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
PostalCode (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
VisitingAddress (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
CustomerCustomerDemo (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Employees (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Orders (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Shippers (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Attribute definitions per element
Customer (Entity)
CompanyName (NormalField)
StringLength
SomeAttribute
CustomerId (NormalField)
Fax (NormalField)
Phone (NormalField)
PostalCode (NormalField)
Employees (NavigatorCollection)
Additional interface definitions per element
Customer (Entity)
Additional namespace definitions per element
Customer (Entity)