By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | Description | ParentId | DataValue |
|---|---|---|---|
| 1 | Root | 0 | 0 |
| 2 | Component A | 1 | 0 |
| 3 | Component B | 1 | 0 |
| 4 | Component A | 1 | 1 |
| 5 | Component B | 1 | 1 |
| 6 | Capacity | 2 | 10.5 |
| 7 | Temperature | 2 | 22 |
| 8 | Sub Component A | 2 | 0 |
| 9 | Viscosity | 8 | 0.8 |
| 10 | Sub Component A | 2 | 1 |
| 11 | Viscosity | 10 | 1.2 |
| Lvl1Description | Id1 | ParentId1 | Datavalue1 | Lvl2Description | Id2 | ParentId2 | Datavalue2 | Lvl3Description | Id3 | ParentId3 | Datavalue3 | LeafDescription | Id4 | ParentId4 | Datavalue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Root | 1 | 0 | 0 | Component A | 2 | 1 | 0 | null | 6 | 2 | null | Capacity | null | null | 10.5 |
| Root | 1 | 0 | 0 | Component A | 2 | 1 | 0 | null | 7 | 2 | null | Temperature | null | null | 22 |
| Root | 1 | 0 | 0 | Component A | 2 | 1 | 0 | Sub Component A | 8 | 2 | 0 | Viscosity | 9 | 8 | 0.8 |
| Root | 1 | 0 | 0 | Component A | 2 | 1 | 0 | Sub Component A | 10 | 2 | 1 | Viscosity | 11 | 10 | 1.2 |
| Root | 1 | 0 | 0 | Component A | 4 | 1 | 1 | null | null | null | null | null | null | null | null |
| Root | 1 | 0 | 0 | Component B | 3 | 1 | 0 | null | null | null | null | null | null | null | null |
| Root | 1 | 0 | 0 | Component B | 5 | 1 | 1 | null | null | null | null | null | null | null | null |