For my current project, I need to create a database table to store a recursive association. I've done a lot of searching and have read answers on questions, such as Naming convention for associative entity and How do you name your many-to-many relationship tables?, but they don't discuss the case of a recursive relationship.
My company ships out inventory, and they want some parts to automatically include other parts on an order. For example, an order for a Widget will automatically have a Widget Guide added automatically.
The table's schema will basically just be two columns, each a foreign key to the
InventoryProduct table. My struggle has been naming this table and these columns. I've considered something like:
InventoryAssociation -------------------- ParentInventoryProductId : int, FK ChildInventoryProductId : int, FK
But I don't feel like "InventoryAssociation" is a great name for the table/entity, nor do I think the association between the two inventory products is really a parent/child relationship.
Does anyone have suggestions for better names? Thanks!