Supplier
Inheritance hierarchy
Hierarchy type |
None |
Is abstract |
False |
Relationships
The Supplier entity is part of the following relationships
Related Entity |
Full description |
Category |
Category.Suppliers - Supplier.Category (m:n) (via Product) |
Product |
Product.Suppliers - Supplier.Products (m:1) |
Fields
The following fields are defined in the Supplier entity
Name |
Type |
Is PK |
Is FK |
Optional |
Read-only |
Max. length |
Precision |
Scale |
Address |
string (System.String) |
|
|
Yes |
|
60 |
0 |
0 |
City |
string (System.String) |
|
|
Yes |
|
15 |
0 |
0 |
CompanyName |
string (System.String) |
|
|
|
|
40 |
0 |
0 |
ContactName |
string (System.String) |
|
|
Yes |
|
30 |
0 |
0 |
ContactTitle |
string (System.String) |
|
|
Yes |
|
30 |
0 |
0 |
Country |
string (System.String) |
|
|
Yes |
|
15 |
0 |
0 |
Fax |
string (System.String) |
|
|
Yes |
|
24 |
0 |
0 |
HomePage |
string (System.String) |
|
|
Yes |
|
1073741823 |
0 |
0 |
Id |
int (System.Int32) |
Yes |
|
|
Yes |
0 |
0 |
0 |
Phone |
string (System.String) |
|
|
Yes |
|
24 |
0 |
0 |
PostalCode |
string (System.String) |
|
|
Yes |
|
10 |
0 |
0 |
Region |
string (System.String) |
|
|
Yes |
|
15 |
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 |
Yes |
nvarchar |
60 |
0 |
0 |
|
|
City |
City |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
CompanyName |
CompanyName |
|
nvarchar |
40 |
0 |
0 |
|
|
ContactName |
ContactName |
Yes |
nvarchar |
30 |
0 |
0 |
|
|
ContactTitle |
ContactTitle |
Yes |
nvarchar |
30 |
0 |
0 |
|
|
Country |
Country |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
Fax |
Fax |
Yes |
nvarchar |
24 |
0 |
0 |
|
|
HomePage |
HomePage |
Yes |
ntext |
1073741823 |
0 |
0 |
|
|
Id |
SupplierID |
|
int |
0 |
10 |
0 |
SCOPE_IDENTITY() |
|
Phone |
Phone |
Yes |
nvarchar |
24 |
0 |
0 |
|
|
PostalCode |
PostalCode |
Yes |
nvarchar |
10 |
0 |
0 |
|
|
Region |
Region |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
Setting values
Supplier (Entity)
Setting name |
Value |
Entity base class name |
CommonEntityBase |
Address (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
City (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
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 |
Country (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 |
HomePage (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Id (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 |
Region (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Category (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Products (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Attribute definitions per element
Address (NormalField)
City (NormalField)
CompanyName (NormalField)
Country (NormalField)
Fax (NormalField)
HomePage (NormalField)
Phone (NormalField)
PostalCode (NormalField)
Region (NormalField)
Additional interface definitions per element
None.
Additional namespace definitions per element
None.