By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | number | name | context |
|---|---|---|---|
| 1 | 1234 | Test 1 | car |
| 2 | 1235 | Test 2 | car |
| 3 | 1236 | Test 3 | car |
| 4 | 1237 | Test 4 | car |
| id | parent | child | count |
|---|---|---|---|
| 1 | 1234 | 1235 | 1 |
| 2 | 1234 | 1236 | 1 |
| 3 | 1236 | 1237 | 2 |
| number | name | context | count | path |
|---|---|---|---|---|
| 1234 | Test 1 | car | null | 1234 |
| 1235 | Test 2 | car | 1 | 1234/1235 |
| 1236 | Test 3 | car | 1 | 1234/1236 |
| 1237 | Test 4 | car | 2 | 1234/1236/1237 |