By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | item |
|---|---|
| 1 | DEP |
| 2 | DEP Item 1 |
| 3 | DEP Item 10 |
| 5 | DEP Item 24 |
| 6 | DEP G1 Item B 1 |
| 8 | DEP G1 Item B 11 |
| 9 | DEP G1 Item B 24 |
| 10 | DEP A Item B 1 1 A |
| 11 | DEP A Item B 1 10 |
| 13 | DEP A Item B 1 24 A B C |
| 14 | DEP A Item B 1 1 A B C |
| path | n | id | item |
|---|---|---|---|
| DEP | 1 | 1 | DEP |
| DEP,Item | 2 | 2 | DEP Item 1 |
| DEP,Item | 2 | 3 | DEP Item 10 |
| DEP,Item | 2 | 5 | DEP Item 24 |
| DEP,G1,Item,B | 4 | 6 | DEP G1 Item B 1 |
| DEP,G1,Item,B | 4 | 8 | DEP G1 Item B 11 |
| DEP,G1,Item,B | 4 | 9 | DEP G1 Item B 24 |
| DEP,A,Item,B,1 | 5 | 11 | DEP A Item B 1 10 |
| DEP,A,Item,B,1 | 5 | 13 | DEP A Item B 1 24 A B C |
| DEP,A,Item,B,1,1,A | 7 | 10 | DEP A Item B 1 1 A |
| DEP,A,Item,B,1,1,A | 7 | 14 | DEP A Item B 1 1 A B C |