Diagrams

Table

Item Attribute Value Mapping

DynamicsDocs.comItem Attribute Value Mapping«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«Table 7501»Item Attribute ValueAttribute ID [PK,NN]ID [PK]ValueNumeric ValueBlockedAttribute Name<Item Attribute ID><Item Attribute Value ID><Attribute ID>

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

Fields

# Name Type
1 Table ID (Table ID) Integer
2 No. (No.) Code20
3 Item Attribute ID (Item Attribute ID) Integer
4 Item Attribute Value ID (Item Attribute Value ID) Integer

Keys

# Fields
0 Table ID,No.,Item Attribute ID (Table ID,No.,Item Attribute ID) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field