report_technologies
2 rows where report_id = "6a58cd6e-6b2b-424e-9343-47f6888a13e2"
This data as json, CSV (advanced)
| Link | report_id | name | type | source |
|---|---|---|---|---|
| 6a58cd6e-6b2b-424e-9343-47f6888a13e2,Matomo Tag Manager,runtime | https://goteborg.se/ 6a58cd6e-6b2b-424e-9343-47f6888a13e2 | Matomo Tag Manager | analytics | runtime |
| 6a58cd6e-6b2b-424e-9343-47f6888a13e2,Rekai,runtime | https://goteborg.se/ 6a58cd6e-6b2b-424e-9343-47f6888a13e2 | Rekai | tools | runtime |
Advanced export
JSON shape: default, array, newline-delimited, object
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);