gistfile1.txt

-- add the columns needed to store NodeConfigId:
-- - one in reportExectution, "nodeConfigId"
ALTER TABLE ReportsExecution ADD COLUMN nodeConfigId text;

-- - one in ExpectedReportsNode, "nodeConfigIds" (with 's')
ALTER TABLE expectedReportsNodes ADD COLUMN nodeConfigIds text[];

-- - the table for node config ids
CREATE TABLE nodes_info (
  node_id    text PRIMARY KEY CHECK (node_id <> '')
  -- configs ids are a dump of json: [{"configId":"xxxx", "dateTime": "iso-date-time"} ]
, config_ids text
);