Diagrams

Table

Item Attribute Value

DynamicsDocs.comItem Attribute Value«Table 7501»Item Attribute ValueAttribute ID [PK,NN]ID [PK]ValueNumeric ValueBlockedAttribute Name«Table 7505»Item Attribute Value MappingTable ID [PK]No. [PK]Item Attribute ID [PK]Item Attribute Value ID«Table 7500»Item AttributeID [PK,NN]Name [NN]BlockedType; [Option,Text,Integer,Decimal]Unit of Measure<Attribute ID><Item Attribute Value ID><Item Attribute ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Attribute ID (Attribute ID) Integer NotBlank: Yes
2 ID (ID) Integer AutoIncrement: Yes
3 Value (Value) Text250
4 Numeric Value (Numeric Value) Decimal BlankZero: Yes
6 Blocked (Blocked) Boolean
10 Attribute Name (Attribute Name) Text250 FlowField

Keys

# Fields
0 Attribute ID,ID (Attribute ID,ID) Clustered: Yes
1 Value (Value)

Table Relations To Other Tables

Field Related Table Related Field
Attribute ID (Attribute ID) Item Attribute ID (ID) 1..n

Table Relations From Other Tables

From Table From Field
Item Attribute Value Mapping Item Attribute Value ID (Item Attribute Value ID) 1..n