I'm trying to model the following relationships between entities of type Product, Item and Part.
A product consists of one Item and the item itself contains two or more parts. In my domain the sort order of the parts matter per product. So I need to create a model which allows easy querying of parts starting from a product.
The challenge I'm facing is where to place the information on how the parts are sorted depending on the product they belong to. That means in case of Product A the item has Part 1 and Part 2, in case of Product B the item has Part 2 and 1. The entities stay the same but the sort order of the items is different per Product.
What is the recommended way to design this in a graphDB?