complex_foreign_keys

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

1 row where f3 = 1

descending

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

Advanced export

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

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)
);