report_technologies

2 rows where report_id = "41f168f3-c8bb-4ce9-9476-89ae91514de1"

✎ View and edit SQL

This data as json, CSV (advanced)

Link report_id name type source
41f168f3-c8bb-4ce9-9476-89ae91514de1,Rekai,runtime https://www.nrm.se/ 41f168f3-c8bb-4ce9-9476-89ae91514de1 Rekai tools runtime
41f168f3-c8bb-4ce9-9476-89ae91514de1,SiteVision,runtime https://www.nrm.se/ 41f168f3-c8bb-4ce9-9476-89ae91514de1 SiteVision platform runtime

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE report_technologies (
  report_id TEXT NOT NULL REFERENCES reports(id) ON DELETE CASCADE,
  name      TEXT NOT NULL,
  type      TEXT NOT NULL,
  source    TEXT NOT NULL,
  PRIMARY KEY (report_id, name, source)
);
CREATE INDEX idx_report_technologies_name ON report_technologies(name);