By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
ROOT_ITEM_ID | ROOT_ITEM | ITEM_ID | ITEM | ASSEMBLY_ID | PATH_ITEM_ID | PATH_ITEM |
---|---|---|---|---|---|---|
2 | componentA | 4 | modulAB | 50 | ,2,4 | ,componentA,modulAB |
5 | componentA | 7 | modulAC | 100 | ,5,7 | ,componentA,modulAC |
5 | componentA | 7 | modulAC | 100 | ,5,7 | ,componentA,modulAC |
5 | componentA | 11 | modulACDE | 500 | ,5,7,11 | ,componentA,modulAC,modulACDE |