By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 5
| id | hash |
|---|---|
| 1 | h1 |
| 2 | h2 |
| 3 | h3 |
| 4 | h4 |
| 5 | h5 |
SELECT 5
CREATE TABLE
INSERT 0 5
| transaction_id | field1 | value |
|---|---|---|
| 1 | f1 | v1 |
| 1 | f2 | v2 |
| 2 | f3 | v3 |
| 3 | f4 | v4 |
| 4 | f4x | v4x |
SELECT 5
CREATE TABLE
INSERT 0 4
| transaction_id | tag1 | value |
|---|---|---|
| 1 | t1 | v1 |
| 2 | t2 | v2 |
| 2 | t3 | v3 |
| 5 | t5 | v5 |
SELECT 4
| id | hash | tags_array | logs_array |
|---|---|---|---|
| 3 | h3 | null | {"{"f4" : "v4"}"} |
| 5 | h5 | {"{"t5" : "v5"}"} | null |
SELECT 2