Category
Inheritance hierarchy
Hierarchy type |
None |
Is abstract |
False |
Relationships
The Category entity is part of the following relationships
Related Entity |
Full description |
Product |
Product.Category - Category.Products (m:1) |
Supplier |
Category.Suppliers - Supplier.Category (m:n) (via Product) |
Fields
The following fields are defined in the Category entity
Name |
Type |
Is PK |
Is FK |
Optional |
Read-only |
Max. length |
Precision |
Scale |
CategoryName |
string (System.String) |
|
|
Yes |
|
15 |
0 |
0 |
Description |
string (System.String) |
|
|
Yes |
|
1073741823 |
0 |
0 |
Id |
int (System.Int32) |
Yes |
|
|
Yes |
0 |
0 |
0 |
Picture |
byte[] (System.Byte[]) |
|
|
Yes |
|
2147483647 |
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 |
CategoryName |
CategoryName |
Yes |
nvarchar |
15 |
0 |
0 |
|
|
Description |
Description |
Yes |
ntext |
1073741823 |
0 |
0 |
|
|
Id |
CategoryID |
|
int |
0 |
10 |
0 |
SCOPE_IDENTITY() |
|
Picture |
Picture |
Yes |
image |
2147483647 |
0 |
0 |
|
|
Setting values
Category (Entity)
Setting name |
Value |
Entity base class name |
CommonEntityBase |
CategoryName (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Description (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 |
Picture (NormalField)
Setting name |
Value |
Generate as nullable type |
True |
Field property is public |
True |
Products (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Suppliers (NavigatorCollection)
Setting name |
Value |
Navigator property is public |
True |
Attribute definitions per element
CategoryName (NormalField)
Description (NormalField)
Additional interface definitions per element
None.
Additional namespace definitions per element
None.