complex_foreign_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

1 row where f3 = 1

View and edit SQL

pk ▼ f1 f2 f3
1 hello 1 world 2 hello 1

Advanced export

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

CSV options:

CREATE TABLE "complex_foreign_keys" (
  pk varchar(30) primary key,
  f1 text,
  f2 text,
  f3 text,
  FOREIGN KEY ("f1") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f2") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f3") REFERENCES [simple_primary_key](id)
);
Powered by Datasette · Query took 14.446ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo