home / public

report_technologies

0 rows where report_id = "2d02a98a-b1aa-4507-9795-ef0471ed87fb"

✎ View and edit SQL

This data as json

0 records

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);
Powered by Datasette · Queries took 6.593ms