By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | name | color |
|---|---|---|
| 1 | abc | black |
| 2 | cde | white |
| id | name | roll_header_id |
|---|---|---|
| 1 | aaa | 1 |
| 2 | bbb | 1 |
| 3 | ccc | 1 |
| 4 | ddd | 2 |
| 5 | eee | 2 |
| 6 | fff | 2 |
| id | name | roll_header_id | header_id | header_name | header_color |
|---|---|---|---|---|---|
| 1 | aaa | 1 | 1 | abc | black |
| 2 | bbb | 1 | null | null | null |
| 3 | ccc | 1 | null | null | null |
| 4 | ddd | 2 | 2 | cde | white |
| 5 | eee | 2 | null | null | null |
| 6 | fff | 2 | null | null | null |