Every order has at most one parent but may have multiple dependent orders. The
application stores this hierarchical structure as one record per edge, identifying the child order
and its parent. At each order, the depth of the order is maintained. The dependencies must be
acyclic.
The root order has no parent and is marked as Hierarchy Level of 0. For every edge, the
Hierarchy Level of the child is derived from its parent, incrementing it by 1. The assumption is
that a parent order is always created first for any edge. For example, consider the following
hierarchical dependency tree structure:Figure 1. Parent-Child Dependency
Relationship Example Tree Structure
The application inserts the following records in the YFS_TRANSACTIONAL_RELATION table.
Table 1. Sample records in the
YFS_TRANSACTIONAL_RELATION table for hierarchical dependencies