Answer the question
In order to leave comments, you need to log in
What scheme to choose for a database with n-th table nesting?
Hello! There is a need to write a program to view the auto-parts hierarchy. To make it easier to understand, let's take an airplane for example. The aircraft conventionally consists of a body, wings, engine, tail and cockpit. The engine, in turn, consists of a turbine, a combustion chamber, etc. The combustion chamber, in turn, also consists of simpler components. It turns out that each detail can have the n-th level of nesting
Simplified:
Please share your experience in creating a database schema for similar cases. Perhaps there is a specific pattern?
Thanks in advance)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question